Starting MDB from batch file = single user mode ????

  • Thread starter Thread starter Gabriel Maraqa
  • Start date Start date
G

Gabriel Maraqa

Hi Newsgroup

I have a strange problem. I have an access application
(Access 2002 running in NT4SP6a) beeing started from
within a batchfile (the batch serves as a kind of
middleware). When I do this, then the first user can open
the application but any other users that want to use the
application get an error message indicating that the file
is currently in use. When I use shortcuts to open the
database directly then this problem does not arise; all
users can open the application. This helps me to survive
the next weeks but I need this batch file in the long run.

What's wrong? Any good ideas? Every input is highly
appreciated. Thanks.

Kind regards
Gabriel
 
Gabriel Maraqa said:
I have a strange problem. I have an access application
(Access 2002 running in NT4SP6a) beeing started from
within a batchfile (the batch serves as a kind of
middleware). When I do this, then the first user can open
the application but any other users that want to use the
application get an error message indicating that the file
is currently in use.
Click to expand...

How is this batch file being started? Is it from a means where a
different account is being used? For example a shortcut with the Run
from Different Credentials option selected?

What is the command line being run?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Hi Tony

Thanks you for your feedback. The batch file is beeing
started by a shortcut in the start menu. It's a simple
batch file. It contains basically the full path and the
filename of the mdb. That's it. It runs in the same
security context as the rest of the PC.

Does this help you?

Kind regards
Gabriel
 
Gabriel Maraqa said:
Hi Newsgroup

I have a strange problem. I have an access application
(Access 2002 running in NT4SP6a) beeing started from
within a batchfile (the batch serves as a kind of
middleware). When I do this, then the first user can open
the application but any other users that want to use the
application get an error message indicating that the file
is currently in use. When I use shortcuts to open the
database directly then this problem does not arise; all
users can open the application.
Click to expand...

I think this is a permissions problem and using the batch file vs
shortcuts is obscuring the real problem.

You state "when I use shortcuts it works". Now does this mean you or
the users use shortcuts it works? If you then you have full
permissions to the directory. But the users might not have full
read/write/delete permissions to the directory.

Can they create and delete files using notepad in that directory?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
..... had to add the path to access too and not only the
mdb. Now it works. God know why this is.
 
Back
Top