amend asp
Posted On 04 Apr 2007 By a.p.r.pillai. Under MS-Access and Internet.
Click Next for delete.asp ... Continue Reading
No Comments
delete asp
Posted On 04 Apr 2007 By a.p.r.pillai. Under MS-Access and Internet.
DeletedThe record has been deleted.Click Next for delete-select.asp ... Continue Reading
No Comments
delete select asp
Posted On 03 Apr 2007 By a.p.r.pillai. Under MS-Access and Internet.
Delete productClick the product that you want to delete. "> _ Go Top ... Continue Reading
No Comments
MICROSOFT ACCESS HOW TOS
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
IMPLEMENTING MICROSOFT ACCESS SECURITY MICROSOFT ACCESS SECURITY OVERVIEWCreating a User Account Creating a Group Account Add Users to Security Groups Remove Users from Security Groups Deleting a User-Account Deleting ... Continue Reading
4 Comments
DISPLAY PATH AND FILE INFO
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
Displaying Path & File InfoSub ShowFileAccessInfo2()
Dim fs, d, f, s
On Error Goto ShowFileAccessInfo2_Err
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.Getfile("C:\mytext.txt")
s = UCase(f.Path) & vbCrLf
s ... Continue Reading
No Comments
RENAME FILE USING FILESYSTEMOBJECT
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
Renaming a file and displaying Drive & File Information
Sub ShowFileAccessInfo()
Dim fs, f, s
On Error GoTo ShowFileAccessInfo_Err
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.Getfile("C:\mytext.txt")
s ... Continue Reading
No Comments
CREATE TEXT FILE FROM MSACCESS
Posted On 06 Dec 2006 By a.p.r.pillai. Under How Tos.
HOW TO CREATE A TEXT FILE FROM MICROSOFT ACCESS
The FileSystemObject Object provides access to a the computer's file system.The following code illustrates how the FileSystemObject is used to return a ... Continue Reading
5 Comments
CREATE EXCEL WORD FILE FROM ACCESS
Posted On 04 Dec 2006 By a.p.r.pillai. Under How Tos.
CREATE EXCEL OR WORD FILE FROM ACCESS
Create Excel File or Word Document from Microsoft Access and write information into them. Every application that supports Automation provides at ... Continue Reading
1 Comments
IMPORT OBJECTS WITH VBCODE
Posted On 03 Dec 2006 By a.p.r.pillai. Under How Tos.
IMPORT OBJECTS WITH VISUAL BASIC CODE
Normally, Tables, Queries or other objects from another database can be imported manually by selecting Import from Get External Data option ... Continue Reading
1 Comments
SHARE PREVIOUS VERSION DATABASE
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Share a previous-version secured database across several versions of Microsoft Access.
With one exception, the issues involved when sharing a secured database across more than one version of Microsoft Access are ... Continue Reading
No Comments
CONVERT OLDVERSION WORKGROUP FILE
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Convert a workgroup information file from a previous version of Microsoft Access.
To take advantage of security and performance improvements, you should re-create the Workgroup Information File as described below:
Create a ... Continue Reading
1 Comments
CONVERT MSACCESS OLD VERSIONS
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Convert a Microsoft Access 95 or 97 secured database.
When upgrading from Microsoft Access 95 or 97, you need to convert your secured database, but you don't need to convert the ... Continue Reading
No Comments
RUNPERMISSIONS PROPERTY
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
RunPermissions Property
You can use the RunPermissions property in a multi-user environment with a secure workgroup to override the existing user permissions. This allows you to view a query or run ... Continue Reading
No Comments
DEFAULT PERMISSIONS FOR NEW QUERY
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Change default permissions for all new queries.
You can change the default permissions that allow others to view data returned from queries or in the case of action queries, to run ... Continue Reading
No Comments
PERMIT TO VIEW RUN QUERY
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Permit others to view or run my query but not change data or query design.
In a secure workgroup, you can assign others permission to view the data your query returns, ... Continue Reading
No Comments
TRANSFER OWNERSHIP OF DATABASE
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Transfer ownership of an entire database to another administrator
Start Microsoft Access by using a secure workgroup that contains the user account that you want to own the database and its ... Continue Reading
No Comments
VIEW OR TRANSFER OWNERSHIP
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
View or transfer ownership of individual Tables, Queries, Forms, Reports and Macros in a secure database.
If you have Administer permission for a Table, Query, Form, Report or Macro, you can ... Continue Reading
No Comments
ASSIGN DEFAULT PERMISSIONS
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Assign default permissions for new Tables, Queries, Forms, Reports and Macros.
Open the database that contains the Tables, Queries, Forms, Reports and Macros. On the Tools menu, click Security and then click ... Continue Reading
No Comments
ASSIGN OR REMOVE PERMISSIONS
Posted On 28 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Assign or remove permissions for a database and existing Tables, Queries, Forms, Reports and Macros
Open the database that contains the Tables, Queries, Forms, Reports and Macros that you want to ... Continue Reading
1 Comments
CLEAR SECURITY PASSWORD
Posted On 28 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Clear a security account password
To complete this procedure, you must be logged on as a member of the Admins group.
Start Microsoft Access by using the workgroup information file in which ... Continue Reading
No Comments
CREATE OR CHANGE SECURITY PASSWORD
Posted On 28 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Create or change a security account password
A security account password is created to make sure that no other user can log on using that user name. By default, Microsoft Access ... Continue Reading
No Comments
