General discussion

Locked

Microsoft Access - sharing a database

By maecuff ·
First of all, I have to say that I don't know if this is a network issue or a Microsoft Access issue. I'm by no means an expert in either area, I'm just trying to help two of my employees who are spinning their wheels with a problem we're having.

We have an Access database that is being used by a remote location. This database is set to 'Share' and set to not have record locks. The file permissions on the folder are set as appropriate. The problem is, when one person is in the database, then anyone else who tries to access it can 'read only'. Also, when my employees try to open the database via the shortcut they created, it won't open, but if they browse network neighborhood, they can get to it.

I realize this isn't a lot of information, but it's about all I have to go on right now. I'd be glad to provide more if you have any specific questions.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Jaqui In reply to Microsoft Access - sharin ...

hoo boy, talk about impatient.

Acess not allowing concurrent write access to the database is why this happens, normally this is concidered a good thing, to make sure that you don't lose transactions. get remote acess to the db to only open a connection when actually working on it instead of keeping it open all the time, that will allow the local access the time to make changes.

network session specific shortcut I bet, that is usually the cause of this type of error. new session, such as after logout for lunch break, new session so the network share is not valid any more.

Collapse -

by maecuff In reply to Microsoft Access - sharin ...

Yes, Jaqui..I know, I am impatient. Not always, but I've been getting screeching phone calls and emails and I've had about all I want on that front for a least a few weeks...

Thanks for your help!

Collapse -

by sprinkl3s In reply to Microsoft Access - sharin ...

make an mdw file for the database, this is done through the workgroup administrator wizard in access. this allows more then one user to access the database... you have to use the shortcut that is created.... or atleast a shortcut in the same format.

Collapse -

The solution is put it in an online database

by echemistry In reply to Microsoft Access - sharin ...

You can subscribe an online database, so people can conveniently access it remotely. Some service provide access control, so you could control who can access it. Try Nenest.

Back to Networks Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums