Database already open exclusively..Pl. help

[pthakar]

I have an autoexec macro that opens up a form during the startup of the application but when a user opens the application the other user would get the error that database is already open what I am doing wrong???
Pl. help me....
Thanks in advance

 

[psemianonymous]

Go to everyone's (including your) computer and ensure that they aren't opening the database in exclusive mode. This can happen either by using a particular shortcut (check for "/excl" and remove it) or by their Access settings. To check their settings (I have Access97 so yours may differ some):

1.Click on Tools->Options
2.Go to the "Advanced" tab
3.Under "Default Open Mode", ensure it is set to "Shared", NOT TO EXCLUSIVE.
4.If you changed anything, click on the "OK" button to close it.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

 

[Trendsetter]

When you open a database manually you ahve the option to check the box asking for Exclusive opening.. This means that nobody else can get in whilst you have it open and is usually only used by the DB Administrator.
Have a look in your start up options to make sure you have not inadvertantly assigned the opening as exclusive.

 

[pthakar]

Thank you
But for some reason It locks up the form and other user can't use it and now I have another message that "form is in use??
Do u have ny idea.
thanks

 

[telephoto]

I have experienced similar problems when using multi user dbs on NT.

If everyone has change permission, then no problem.
If one has read only and the other has change: problem

I suggest you check permissions, and if it would cause no security problem then set any users to change. It is possible to protect the db in software with an API call to establish the user.

Telephoto