Double Access 97 Sessions loading

[defrogs]

Good day all,
I have an Access 97 database stored on a remote server and it runs pretty well (for the most part). My problem is that when a button is clicked on a webpage, to open the database, it opens two sessions of the database. They both will work by themselves, but it's an inconvenience for those entering data to remember to close down the "unused" copy. Does anyone have a solution to this? I remember seeing something in the MicroSoft Access FAQ database, but haven't been able to re-locate it.
Thanks for any help you may provide

 

[Fizzio]

Easiest way is on opening of the database, check for the presence of the ldb file and if it exists, close down the Db.

The only problem with this is if the Db does not close correctly, the ldb will remain on the drive and it will kick you out each time you open it!

 

[ghudson]

The .ldb file will be created as soon as the db is opened so it will always exist and your method would always close down the db even if it is the only one opened.