Password access (1 Viewer)

[blue_wyvern]

I obtained a login and user access from someone last year, (can't remember who it was,) and being relatively new to vba in access, have been unable to adapt it for use in access 97. Please can someone help?

The logon works great in access 2000, thanks whoever created it!

thanks
Blue-wyvern

 

[still_rookie]

Here you go... next time please check the ms access help, it is very useful ... this is where i got it from:

Open the Microsoft Access file that you want to convert. If it is a multiuser (multiuser (shared) database: A database that permits more than one user to access and modify the same set of data at the same time.) Access database that is located on a server or in a shared folder, make sure that no one else has it open. 
Important  If you have employed the security features of the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the file by clicking Code  on the Database toolbar and entering the password in the databasename Password dialog box.

If you are converting a security-enabled Access database, you must have Open/Run and Open Exclusive permissions for the database itself, and Read Design permissions for all objects in the database. To help protect a database that has been converted to Access 97, you must open it in Access 97 and apply user-level security (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.).

On the Tools menu, point to Database Utilities, click Convert Database/Project, and then click the file format you want. 
In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save. 
If the database that you are converting to Access 97 contains code, open the new database in Access 97, open a module and click References on the Tools menu, and in the Available References box, clear the check boxes next to any missing references and set a reference to the Microsoft Access DAO 3.51 Object Library. 
If the Access database uses add-ins (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) or library databases (library database: A collection of procedures and database objects that you can call from any application. In order to use the items in the library, you must first establish a reference from the current database to the library database.), you must convert them back to Access 97 as well.

OOOPS !! pls read the next post

 

[still_rookie]

Here you go... next time please check the ms access help, it is very useful ... this is where i got it from:

Open the Microsoft Access file that you want to convert. If it is a multiuser (multiuser (shared) database: A database that permits more than one user to access and modify the same set of data at the same time.) Access database that is located on a server or in a shared folder, make sure that no one else has it open.
Important If you have employed the security features of the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the file by clicking Code on the Database toolbar and entering the password in the databasename Password dialog box.

If you are converting a security-enabled Access database, you must have Open/Run and Open Exclusive permissions for the database itself, and Read Design permissions for all objects in the database. To help protect a database that has been converted to Access 97, you must open it in Access 97 and apply user-level security (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.).

On the Tools menu, point to Database Utilities, click Convert Database/Project, and then click the file format you want.
In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save.
If the database that you are converting to Access 97 contains code then open the new database in Access 97, open a module and click References on the Tools menu, and in the Available References box, clear the check boxes next to any missing references and set a reference to the Microsoft Access DAO 3.51 Object Library.

AND

If the Access database uses add-ins (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) or library databases (library database: A collection of procedures and database objects that you can call from any application. In order to use the items in the library, you must first establish a reference from the current database to the library database.), you must convert them back to Access 97 as well.