Read only back end after syncronising

[Guest]

Hi,

Each week I syncronise the back end at site 1 with the backend at site 2 -
this is done overnignt as the VPN connection is very slow.

This morning the backend at site 2 has come up as read only and nothing can
be edited. I have checked the database properties to see if the read only is
check and it is fine. No other users have the back end open and I have no
icon to show that the backend is open or locked.

All users have a front end on their PC's and all have the sharing option
ticked in the advanced tab in Tools-Options.

We are running Access 2002 / 2003 (dependant on machine)

Charlie

 

[Joseph Meehan]

Hi,

Each week I syncronise the back end at site 1 with the backend at
site 2 - this is done overnignt as the VPN connection is very slow.

This morning the backend at site 2 has come up as read only and
nothing can be edited. I have checked the database properties to see
if the read only is check and it is fine.

Have you checked the "File" properties as opposed the the database
properties. Also how about the directory properties?

 

[Guest]

Yes both of these have been checked and all is as it should be

Charlie

 

[Joseph Meehan]

Yes both of these have been checked and all is as it should be

Charlie

:

Sorry, but that was the extent of my experience. Hopefully someone else
will have a suggestion. I seem to recall someone having a like problem and
one of our regulars had a reference from MS for them.

 

[aaron.kempf]

mdb is a crap database

learn sql server; use sql server

don't ever use mdb for even a single record and a single user.

mdb is passe welcome to the 90s.

 

[Joseph Meehan]

mdb is a crap database

learn sql server; use sql server

don't ever use mdb for even a single record and a single user.

mdb is passe welcome to the 90s.

I am truly sorry you were never able to learn how to use MS Access.