Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


March 2001

Synchronizing .mdb Files

RSS
Subscribe to Windows IT Pro | See More Database Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Microsoft Access Database (.mdb) files don't synchronize with other network .mdb files when you store the files in an offline folder. However, you can work around this problem. To synchronize any file, click Start, Run and run gpedit.msc. Navigate to Local Computer Policy, Computer Configuration, Administrative Templates, Network, Offline Files, Files Not Cached. By default, Files Not Cached is set to Not Configured. Set it to Disabled. Log off, and log on again, and set your .mdb files to be available offline.

End of Article



Reader Comments
Have you tested this? I don't think the computer configuration is refreshed at logon, it's refreshed at startup, or 90? minutes. I tried rebooting and it still did not work. I'm pretty sure there's a place that has a list of files that are not synchronized, but I can't remember where it is.

Joe Dubail May 07, 2001


I left a comment on this a few minutes ago, and finally found the KB aritcle. #Q252509 You have to put an entry in and enable it to clear the list.

Joe Dubail May 07, 2001


I can't seem to get this to work.
I have read the article, Joe's comment and Q252509
I have modified both the local machine and domain default
group policies.
Searching the register I can't find any mention of my exclusion string therefore suggesting that the registry isn't getting updated.
Do you have to enable group policies?
Any suggestions what I'm donig wrong?

Alan Marriott May 29, 2001


Please note that you should set the Files Not Cached to Enabled, not to Disabled, for this trick to work.

Omar Salas May 21, 2003


Thank for your help

Gilbert December 03, 2003


Very usefull! I can also add is to domain group policy, so you won't have to set it on each computer in your domain.

Arthur December 04, 2003


Would be great if it worked. Did this setting change on both PCs, but still get "Files of this type cannot be made available offline

Running XP Pro on both machines.

steve February 08, 2004


Absolutely worthless, the proposed solution doesn't work, neither does the Microsoft knowledge base solution, nor the user proposals.

Are you just leaving this up here to get hits?

Anonymous User April 07, 2005 (Article Rating: )


I don't know why the users on 2-8-04 or 4-7-05 had issues, but by following the above steps the Access MDB files synchronized fine.

I am listing the details together for future clarification courtesy of Jason McFeetors and follow-up from Omar Salas.

Microsoft Access Database (.mdb) files don't synchronize with other network .mdb files when you store the files in an offline folder. However, you can work around this problem.

1. To synchronize any file, click Start, Run and run gpedit.msc.
2. Navigate to Local Computer Policy, Computer Configuration, Administrative Templates, Network, Offline Files, Files Not Cached. By default, Files Not Cached is set to Not Configured.
3. Set it to Enable. Do not list any file extensions.
4. I suggest restarting your PC and after logging back in all files will synchronize.

-Nick


Anonymous User July 13, 2005 (Article Rating: )


Administratively assigned offline files
Computer Configuration\Administrative Templates\Network\Offline Files

Description
Lists network files and folders that are always available for offline use. This policy makes the specified files and folders available offline to users of the computer.

To assign a folder, click Show and then click Add. In the Type the name of the item to be added box, type the fully qualified UNC path to the file or folder. Leave the Enter the value of the item to be added field blank.

Andrew210 February 06, 2007 (Article Rating: )


 See More Comments  1   2 

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Top Viewed ArticlesView all articles
Battery Life Issues Almost Certainly Not Windows 7's Fault

While Microsoft is still investigating a notebook battery life issue that was supposedly caused by Windows 7, some interesting trends have emerged. ...

Confirmed: Battery Life Issues Not Windows 7's Fault

Microsoft on Monday issued a lengthy statement about the recent Windows 7 battery controversy, echoing my assessment from earlier in the day, but backing it up with hard, cold evidence. ...

Getting your iPhone to Sync with Exchange 2003

Follow these steps to use an iPhone with Exchange. ...


Windows OSs Whitepapers Protecting Microsoft SharePoint

Related Events Deep Dive into Windows Server 2008 R2 presented by John Savill

The Easiest Way to Save Time and Money on E-mail and SharePoint Management

Check out our list of Free Email Newsletters!

Windows OSs eBooks Understanding and Leveraging Code Signing Technologies

A Guide to Windows Certification and Public Keys

SQL Server Administration for Oracle DBAs

Related Windows OSs Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2010 Penton Media, Inc. Terms of Use | Privacy Statement