I'm not really much of an Access expert, so I'm not sure why you're getting
that message. Check your path and filename to make sure they are correct.
Look for a ".ldb" file in the folder to see if anyone else has the database
open. If the lock file is there but you're sure there is no one using the
database, delete the ".ldb" file and try running the macro again. After
that, I suggest going to the Access newsgroup and ask an expert there.

One more thing. Is the database secured? Does it require a
username/password to open it? If so, you might want to read this article:

http://support.microsoft.com/default...b;en-us;192919


"deeds" wrote:

Thanks....1 more problem...it seems to work...and actually opens Access
however I get the following VBA message...Microsoft Access cannot open the
database because it is missing, or opened exclusively by another user"....I
do not have the database open when I try this....can't figure out why it
won't open it...any ideas?

Thanks again