Networks

Ask something
Discussion Locked

Microsoft Access - sharing a database

0 helpful
4 replies

by maecuff

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

4 replies

by jaqui

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.

by maecuff

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!

by sprinkl3s

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.

by echemistry

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.

This discussion is closed to new replies.