Access MDb's should be available as offline files.

D

Dave Bootsma

I have searched the access knowledge base and no where do I see where I can
synchronize my mdb file as an offline file. I beleive it cannot be done but
wish somewhere in the knowledge base it would specify just that. Or an
alternative to it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-aab1-5e37e381b1d4&dg=microsoft.public.access
 
A

aaron.kempf

i believe that you might have some luck looking into briefcase
replication.. i just dont know what version supports briefcase
replication
 
T

Tony Toews

Dave Bootsma said:
I have searched the access knowledge base and no where do I see where I can
synchronize my mdb file as an offline file. I beleive it cannot be done but
wish somewhere in the knowledge base it would specify just that. Or an
alternative to it.
Click to expand...

What type of synchronization do you want to do? If it's records then
investigate database replication. The real experts on that hang out
in the microsoft.public.access.replication newsgroup.

See Error Message: Files of This Type Cannot Be Made Available Offline
Q252509 http://support.microsoft.com/?kbid=252509

The problem with using offline files is that it's an all or nothing
thing. That is the entire file is copied up or down. Thus if
someone makes changes on the server and someone makes changes on the
offline line which change wins?

Finally I found that the offline files in Windows 2000 worked very
poorly when doing updates. So much so I gave up after ten minutes of
working with them. No idea if Win XP is any better.

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
 
A

Adam

Why don't you just use make-table queries when your online, then
transfer the data you need, so you can use it when you are offline?
 
Top