limiting to one instance? Access 2000

[jlm722]

Is there a setting or a simple way to accomplish this? I have shortcuts that open my databases. However, if I click on the shortcut again, it brings another instance of the database up. ie: if i click my shortcut 5 times, my database is open 5 times. Is there a possible way to fix this where if it's already open clicking on the shortcut will bring the one up that's already open and not a new one each time?

 

[dtaylor]

I found this awhile back and can't remember where. Thanks to whoever if it was posted in this forum.

The .zip contains to files. The .txt is the module and the image is how I shows how I call it from my AUTOEXEC macro. It works really well for us.

Hope this helps.

 

[jlm722]

well, i'm sorry, i need to explain farther. The problem I'm having is, I made a database to use as a master db that will access 4 other databases. at the currect time, there is 4 individual shortcuts on my desktop to open each db. I am creating 1 db that can be opened, with a form that has 4 command buttons that i want to open the other dbs. The problem is, the original shortcuts worked fine. i could click, click, click, click on the shortcuts and they would always go back to the open database if it were indeed open. It wouldn't open another instance of it. But when I create a command button to open it, it will open many instances of a db if i keep clicking on the command. If I make it a hyperlink instead, it works great, except when the db opens, there is a toolbar at the top that looks like an internet browser bar! What the heck is this? and is there a way without ten pages of code to make this work correctly? Pleeeeease help!