Two questions

[Alhousani]

Hi,

Recently I created a database using MS Access for the company and I am the Admin for it. The database is in the share folder and many employees are using it but if I want to take backup or modify any thing a message is appearing saying that one user open the database.

Is there any method to know which user is opening the database and in which PC (workstation) it is open.
--------------------------------------

Is there any way of adding export fuction to the toolbar using modules or macro

 

[Banana]

Read up on splitting the database, front-end and back end and workgroup security. Sharing single database along several users on network is a recipe for data corruption.

I've never done an export function, but yes it can be done. Have you searched that as well?

 

[ghudson]

Open up the record locking file [YourDB.ldb] with NotePad.exe to view the contents. It will be located in the same directory as the opened db. It will tell you the users workgroup name and the computer name that has the db opened. The .ldb does not always release the info when a user closes the db. Once the last user closes the db the .ldb file will delete its self.

 

[Alhousani]

Thanks for the reply

If I can do that is there any way to force user to close the database by any command

 

[ghudson]

Search around for there are threads explaining how to do it. They explain how to have a close db command executed by your command. But your db has to be split.

Those in charge of your network can force the users out of the file if you need it done.