Avatar of politicalfusion
politicalfusion

asked on 

mdb synchronization in offline files

hello,

server running 2003 (in a 1 dc domain)
laptop running xp pro
i want .mdb files to synchronize.

changed group policy at server and laptop to disable "Files not cached" under Computer Configuration/Administrative Templates/Network/Offline Files
i did this for the local client machine, for the default domain policy, the local policy on the server, the default domain controller policy, and everywhere else i could possibly think of :)

no luck

redid all the above (with appropriate gpupdate commands and logging on and off for good measure) with policy enabled and excluding only *.ldb

no luck

went into the registry and drilled down to HKLM\Software\Microsoft\Windows\CurrentVersion\NetCache\Enabled
&
HKLM\Software\Policies\Microsoft\Windows\NetCache\Enabled
and set from 0 to 1 using modify
did this on the laptop for both entries and the server for the first entry, there was no NetCache key for the second entry.

no luck

i can manually select 'Make available offline' by right-clicking in explorer, but it's just error messages after that.

Edward
Windows Server 2003Windows XPWindows OS

Avatar of undefined
Last Comment
politicalfusion
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Access database files cannot be used as offline files due to the way they are updated
see http://support.microsoft.com/kb/252509
Avatar of politicalfusion
politicalfusion

ASKER

from the same KB article showing a work-around i tried. so it appears they can be synched, it's just not recommended. these databases have only one user, so the default cautions do not apply so much. thank you:

You can modify the list of excluded extensions by editing the appropriate Group Policy object (local, domain, organizational unit, and so on). For example, to remove the .pst extension from the list of excluded files, enable the following sample policy in Policy Editor:
Computer Configuration\Administrative Templates\Network\Offline Files\Files not cached
Then, type the following string in the Extensions box:
*.slm;*.mdb;*.ldb;*.mdw;*.mde;*.db?
Log off, and then log back on. This replaces the default list, preserving all but the *.pst extension. You can use the same method for any of the other extensions. If you want to exclude all extensions, leave the list empty.

To edit the local policy, click Start, click Run, type gpedit.msc, and then click OK. To edit the domain policy, use Active Directory Users and Computers snap-in.
ASKER CERTIFIED SOLUTION
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of politicalfusion

ASKER

i ran both gpupdate and rebooted everything.

current possibility:
i ran into a thread that indicates the solutions will not work with a terminal server set to accept multiple concurrent connections.

best work around:
use a roaming profile and put all the .mdb, etc files you want synched in there. they synch just fine that way.

i'd love additional input or knowing if the current possibility is correct. any other work arounds?

Avatar of politicalfusion

ASKER

i'm upping the point value as this seems to be a pretty tough work around, if possible at all.
Avatar of politicalfusion

ASKER

not sure where the solution occurred. i manually edited the registry to include all entries, modified all group policy, specified the exclusion of only .ldb files rather than deny the group policy altogether, put my key concern files into my roaming profile, and waited for 24 hours. presto! i'm in. here is a great resource link on offline files:
http://blogs.msdn.com/jonathanh/archive/tags/Offline+Files/default.aspx
hope this helps someone else.
Windows Server 2003
Windows Server 2003

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

129K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo