Yet another Microsoft Access question - network issue maybe?

Question

So close yet so far. I have my database completed and is located on a shared network drive. I can access it just fine, but if any of my coworkers try and open it, it says it is currently in use and read only, then to top it off, the form is blank. They can view the form in Design mode, but can't actually use it. I didn't set any security parameters, and I've been in and out of dozens of books. Why on earth is it not letting anyone else on the network use it?

Answer 1

There are a few things to check on with this situation. If your users can open the mdb, then the file sharing issue may be worked out, just check to see if they have read/write/change authority for the folder and/or file. This is in windows.

In Access, you should check in Tools, Options, Advanced tab and see if the file has the Shared option set and then check to see about the "Open databases using record-level locking" is set on. You need this if many people will be updating the same table at the same time. If that was not set, it should still show the form, but not let them save any edits.

I notice that you say your account is able to open the file ok. The users may have access, but if their account is not at the same security level as yours, they need to be granted the specific authorities for the folder and/or file.

Answer 2

The network drive may be "shared" but did you create a new folder and put the database in the folder on the shared drive?

You may need to share the folder as well. Your system admins may have made the top level of the directory shareable so people can store files/folders there but they may not have made those files and folders inherit the permissions set at the top level.

Also, if your coworkers are then trying to access it while you have it open this could be why they get that message. Also you have to go into Access and set the option for "shared use." Go to options, advanced and make sure "shared" mode is checked instead of "exclusive."

Answer 3

I might be wrong on this but I had a pc where I let several peeps use it for free, when they were away from my home, they had been on my user list, But if I was on lets say yahoo, and they were at the library trying to log on, My system would say only one person on one account at one time. Two people sharing the same account cannot log on at the same time period, Kinda confusing but I hope this helps.

Answer 4

you should examine the TCP/IP bindings. make specific that your default gateway is right. make specific that "shopper for Microsoft Networks" and "document and Printer Sharing for Microsoft Networks" are put in and checked on the NIC which you're making use of. in my opinion if it became into me, i might setting up lively itemizing on the Server, set up my consumer money owed and permissions and be achieved with it. No because of the fact that letting a sturdy server pass to waste.

Answer 5

if you have it minimized and closed it will say that, only one person can be in it at a time for modifying