S
Sally
Hi. I'm new to Access development, and have no knowledge
of VB/VBA, but I suspect I can only do what I want to by
using code.
I have created an 'autoexec' macro that carries out
certain tasks when a user wants to go into the database I
have created and put on the network. For reasons I won't
bore you with, it's important that anyone is prevented
from continuing to run the macro and enter the database if
it is already in use.
Having spent a few hours looking through the reference
books, the only thing I have found is the code 'Set db =
OpenDatabase("NWIND.MDB", True)'. I have tried putting
this (using my database name, obviously!)in as a Run Code
action at the beginning of my macro, but the function
isn't valid.
I would really appreciate any help on this. If it's not
possible, it means I have to re-write my database so that
consecutive access does not cause a problem :-(
Many thanks
Sally
of VB/VBA, but I suspect I can only do what I want to by
using code.
I have created an 'autoexec' macro that carries out
certain tasks when a user wants to go into the database I
have created and put on the network. For reasons I won't
bore you with, it's important that anyone is prevented
from continuing to run the macro and enter the database if
it is already in use.
Having spent a few hours looking through the reference
books, the only thing I have found is the code 'Set db =
OpenDatabase("NWIND.MDB", True)'. I have tried putting
this (using my database name, obviously!)in as a Run Code
action at the beginning of my macro, but the function
isn't valid.
I would really appreciate any help on this. If it's not
possible, it means I have to re-write my database so that
consecutive access does not cause a problem :-(
Many thanks
Sally