Synchronizing .mdb files

G

Guest

I have a user that insists on wanting to synchronize his Access Database
files to the Offline Files Folder. I found a work around with no success.
Here are the steps I followed: Click Start, Run and run gpedit.msc. Went to
Local COmputer Policy, Computer Configuration, Administrative Templates,
Network, Offline Files, Files Not Cached set to Disabled. Log off, and log
back on and set your .mdb files to be available offline.

Any assistance is appreciated.
 
A

Arvin Meyer

There is a replication ability within Access, however it should only be used
for data ... NEVER object design. If your user insists on synchronizing
objects, I suggest that he writes his own routine which will check the last
modified date of objects in 2 different databases and build a third database
with the latest object file from each of them. That's not something that can
(or should) be controlled from network administration, other that requiring
proper permissions to the files.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tony Toews

ssills said:
I have a user that insists on wanting to synchronize his Access Database
files to the Offline Files Folder.

Offline Files Folder will not work well with Access. For example -
Users work all day in the database. Someone who is on an offline file
folder makes a change to the database at the end of the day after the
local users are done. The remote user connects to the network and
their copy of the file gets copied across. Not the individual records
but the entire file. Then all the work that the local users have
done during the day gets lost. No backups. Just lost.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
B

beckyoyen

In my case, our users have a mapped drive that is created each time the
user logs in to the server...all their personal/work files are saved to
this drive and we synchronize only this drive; however, we have too
been receiving synch errors such as; can't synch *.mdb or *.pst files
(old ones), but those MDB files are not used/accessed company wide so
we don't have to worry about someone else making changes to it while
one copy is being updated offline. How can we synch these then
successfully?
 
B

beckyoyen

In my case, our users have a mapped drive that is created each time the
user logs in to the server...all their personal/work files are saved to
this drive and we synchronize only this drive; however, we have too
been receiving synch errors such as; can't synch *.mdb or *.pst files
(old ones), but those MDB files are not used/accessed company wide so
we don't have to worry about someone else making changes to it while
one copy is being updated offline. How can we synch these then
successfully?
 

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