Msg when an application is opening more then once

[Edu07]

Hi,

I created an access application for several users. At times, they forget
that have the application already open and execute a new one reducing their
available memory. I'd like them to be notified when they try to open a new
application. Can it be done, and if so, how?

TIA

Edu

 

[PNOman]

Here ya go: http://www.mvps.org/access/api/api0041.htm

 

[Edu07]

Thank you.
Do you know if works with acc07/vista? In my case wouldn't execute.
Edu

 

[PNOman]

Probably not, I don't use Vista. I'm still using Access 97 too! Here's
another approach:
1. Create a new database that looks for a .ldb file in the same directory as
the mdb file you want to open.

2. Create a function like this, to open your desired database, if it has no .
ldb file:
Function OpenDB ()
Dim strMyFile
strMyFile = Dir("C:\MyFolder\MyDB*.ldb") 'Find the first file matching this
criteria.
If strMyFile <>"" then
{code to open your database here}
End If
End Function
The only reason this is a function and not a sub is so it can run from
Autoexec. So...

3. Create an Autoexec macro to run the above function, and then a Quit
command after it.

4. Create a Windows shortcut to the new database, instead of the one you
really want to open. If there's already an .ldb file, it won't open it.

NOTE: In the Dir() function, it's good to use the first few letters of your
database name, then an asterisk, in cases where a user's system converts it
to 8 letters. Folder names might also need to be changed to 6 letters
followed by '~1'.

Hopefully this will do something closer to what you want.

Thank you.
Do you know if works with acc07/vista? In my case wouldn't execute.
Edu

Here ya go: http://www.mvps.org/access/api/api0041.htm

[quoted text clipped - 9 lines]