[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Microsoft Access Synchronization Error

Posted on 2013-06-05
9
Medium Priority
?
656 Views
Last Modified: 2013-06-20
Hi Everyone:

I am working from a replica of an mdb in Access 2007.  I recently upgraded to Office 2010 and am no longer able to synchronize with the design master database.  I tried several suggestions, including running a repair install of Office 2010 with no luck.

The following is the complete error:

Microsoft Access can't retrieve information about the replica 'path\my replica name.mdb'

A co-worker had the same issue, and after we ran the repair of 2010, she was able to replicate with the design master.

Any ideas on where to begin?  I was thinking about installing a new version of the jet database engine or ADO, but I am not sure if that will break anything.

Thanks for any help you can give.
0
Comment
Question by:lkunderwood
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 39222329
"I recently upgraded to Office 2010 ..."
Is that the only change or have you changed machines and/or Windows versions as well?
0
 

Author Comment

by:lkunderwood
ID: 39222402
Hi Peter:

Office 2010 was installed about two weeks ago - no other changes.  Haven't been able to synchronize since.  Can't create replicas either.  Had to get another user to create a new replica for me from her computer.  No error - just wouldn't create the replica.

Thanks for posting!

Lana
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39222743
And it's definitely Office 2010 32 bit?

Have you re-compiled your database in A2010?  I think that is a necessary step.
I assume you are seeing the correct menu/ribbon options in your copy of Access?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:lkunderwood
ID: 39222748
Hi Peter:

I have Access 2007 with Office 2010 32-bit, Windows XP.

I did a repair and compact, but do not have a recompile option.

Thanks.

Lana
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39224709
".. do not have a recompile option...."  ?

Do you mean the Compile option is greyed out?
If just type a space on any empty line and then look at the debug menu again- the compile option should now be available.

Just to re-iterate my last Q- are you seeing the correct replication options on the ribbon?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39224730
To add to what I have said above, you need to establish whether the problem lies in Access or with your database.

If you have any other unreplicated mdb around that you can copy and play with , see if you can create a replica from that, and then see if the sync option is OK.  If your problem extends to other mdbs then it would suggest that you have an Access set up problem, although you would also need another test with a different replicated database to be sure.

If you can create a copy of a replica and remove most or all of the data - could you post that here and I'll see what happens on my setup.
0
 

Author Comment

by:lkunderwood
ID: 39225383
Hi Peter:

I feel pretty certain it is a workstation issue and not a database problem.  My co-worker was able to create a replica on her computer and can synchronize, and so can everyone else in the office.  As I mentioned, since upgrading to Office 2010, synchronize no longer works and gives me an error.  I am also unable to create replicas from the design master when opened on my computer, but my co-worker can when she opens the DM on hers.  I'm not sure what files or libraries were overwritten when Office 2010 was installed, but it looks like a jet engine or ADO problem, and I am not familiar enough with how those work to be able to troubleshoot possible solutions.

Any ideas?

Also, I guess I misunderstood when you mentioned compiling.  I do not have a "compile" option - under Manage I see Compact & Repair, Backup DB and DB Properties.  I thought compile was for scripts so I am not sure where to find the option.

Thanks again for sticking with me on this!

Lana
0
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 39225671
A standard installation Of Office 2010 includes all the necessary files to handle accdb and mdb databases. You should not have to get into the detail of this but you need to be sure that your software is bang up-to-date with the latest service releases. Run 'check for Updates' on the File>Help screen to be sure.

There is a potential ADO problem in A2010, although I thought that was limited to Windows7 - I could be wrong.
To compile the app, open any module in design view and do Debug>Compile.  No errors should be reported.
0
 

Author Comment

by:lkunderwood
ID: 39263621
Hi Peter:

Thanks again for all of your help.  I ended up installing Access 2010 and it resolved the issue.  It appears that some of the dll's or components of ADO or the Jet DB engine had issues that I could not figure out.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question