Changing .mdb file from workstation can corrupt the .mdb file ?

P

Paul

We have our Access .mdb file located on our server
machine. Someone told me that if we need to make any
changes to the .mdb file, we need to be physically at the
server machine to do it. On my workstation I map a drive
to the server machine, and I was told that if I change
the database from my workstation it could corrupt
the .mdb file. Is this true ? What is the difference of
changing the same .mdb file on the server machine or on
my workstation ? Thanks.
 
A

Allen Browne

Opening the \\MyServer\MyPath\MyFile.mdb over the network should be fine
unless:

- Other users are still connected and using the database at the same time
you are trying to make design changes.
or
- The connection to the server breaks. That should not be an issue in a
reliable network, but certainly is with WiFi connections, dial-ups etc.
 
G

Guest

Thank you very much for your reply.
We are not using wireless network or dial-up, the server machine is in the
same office building with my office (just a few feet away from my office).

You mentioned that opening the \\MyServer\MyPath\MyFile.mdb over the network
should be fine unless:
- Other users are still connected and using the database at the same time
you are trying to make design changes.
But, the same problem will happen if I open the .mdb file on the server
machine itself, right ?

Thanks a lot.
 
A

Allen Browne

Absolutely. Getting an exclusive lock to make design changes can be just as
frustrating if go to the server itself to make the changes.
 
G

Guest

Thank you.
So, really, changing the server's .mdb from either my workstation or from
the server itself will be fine if nobody else is using the database, but if
there are people who are using the database, no matter if I change from my
workstation or from the server itself, I will have the same problem. So, the
important thing is not where you change the database, but whether somebody is
using the database at that time. Do I understand it correctly ? (In other
words, what I was being told not to change the database from my workstation
because it can corrupt the database is not correct).

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top