Solved

Access UNreplicated.

Posted on 2007-04-01
9
345 Views
Last Modified: 2008-02-01
Hi all, trust you are well.

Design master/replica scenario all working great. One of our users Compacted and Repaired their replica and straight after doing that it become "unreplicated". I cant sync now with the design master now as the only option i have is to create this replica as the design master. I need the data in this replica - how do i return it to being replicated?

Thanks
Sean
0
Comment
Question by:SeanNij
  • 3
  • 3
  • 3
9 Comments
 
LVL 75
ID: 18834522
And ... there is no backup of that prior to the C&R ?

mx
0
 
LVL 1

Author Comment

by:SeanNij
ID: 18834565
Nope no backup. The user was about to sync and thought it would be nice to do a quick compact and repair.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 18835250
As mx suggests, the C&R typically makes a copy of the file, then performs the compact on that, then deletes the original and renames the copy to match that of the old ... try reviewing the folder where the database lives to see if you find an oddly named file, like "tmp987734343.mdb" or something. Depending on where the glitch happened in the C&R, you might be able to recover from this.

You could also try the JetComp utility, which does a more thorough job of compact and repair and can, at times, cure some ills: http://support.microsoft.com/kb/273956. Of course, make a backup of your file before trying this.

Finally, I'd instruct users that if they wish to C&R before sending that they make a backup first. It's never a wise move to C&R a file without a backup, as it's not unheard of for files to become corrupt in the process.
0
 
LVL 1

Author Comment

by:SeanNij
ID: 18835277
So in a nutshell I cant return the file to its "replicated" state by the sounds of things?
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 84
ID: 18836138
That's hard to say, since there's no way for us to know why it's being reported as unreplicated. You could always contact a repair service (like www.pksolutions.com or www.everythingaccess.com) for assistance, but it won't be free.

Depending on how much data has been entered since the last sync, you may be able to manually update another replica and recover the "lost" data. Of course, this can be a hit-or-miss scenario depending on your particular business and how it uses the data.
0
 
LVL 75
ID: 18838254
LSM ... Just wondering, have you ever actually had JetComp 'work', ie ... actually fix anything?   I have not.  Also ... isn't the 'latest' version of JetComp actually dated pre-A2003?

Thanks ...

SeanNij ... I only have on client using Rep ... and I literally told them: "IF ... you don't do a backup before you do a rep sync ... AND ... you end up with a problem ... THEN ... don't call me, lol (seriously).

mx
0
 
LVL 1

Author Comment

by:SeanNij
ID: 18841375
Mx, there are a lot of my clients i would like too say other things too when they dont backup but i think it would be cencored by EE....

LSM - Jetcomp did work. Must admit it is one of the rare times when it does in defence of mx...

Thanks for all you help.
0
 
LVL 75
ID: 18841439
So, JetComp did work?

If so,  that is good to know!

mx
0
 
LVL 84
ID: 18842176
<LSM ... Just wondering, have you ever actually had JetComp 'work', ie ... actually fix anything?   I have not.  Also ... isn't the 'latest' version of JetComp actually dated pre-A2003?>

Yes, but rarely. Generally if the builtin C&R won't work then JetComp won't either, but I've personally had files that C&R wouldn't fix that JetComp fixed in a hurry. From my understanding, the processes used by JetComp are slightly different than those used by the built ones since JetComp doesn't have to close the current database - it can just immediately perform the C&R.

<isn't the 'latest' version of JetComp actually dated pre-A2003?>

JetComp doesn't really have anything to do with Access versions, as it works on the Jet database engine and has nothing to do with Access itself. It does "work on" Access objects, but that has more to do with the way Access stores those objects than it does with the way JetComp works.

Jet 4.0 has been used since Access 2000, so I doubt any work has been done on it since then.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Conditional Formatting - Date() 8 25
Access MDB/PDF 21 32
Search field on a form 7 17
Minus first query 1 6
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now