Users accessing different backend versions for 2 days! 1

[gusbrunston]

Hi:
I've never done it before, but I've done it now! I had a user's box mess up, and I discovered that half of the tables were not properly linked to the back end. When I used link manager to re-link everything, I chose a backup copy of the database rather than the current one. I am reading about replication and synchronization as fast as I can, but...

If someone could lead me through putting two backends together and saving all the data (is this what synchronization means?) I would so greatly appreciate it.

I continue to study and hope someone will help bail me out ASAP. I've got 3 inputters waiting to input, and one accounter waiting to publish September reports.

Thanks, in advance.

Gus

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[Remou]

This is not good news:
Help Data in Two Places
thread705-1113066
DB Comparer
thread1121-1120220
Comparing data & updating
thread705-1061624
How to Compare Two Database's Data...?
thread700-997794

But may be more use than reading about replication.

 

[gusbrunston]

Dear Remou:
Thanks very much for your response to my post.

I have rebuilt the database using Append and Update queries. It seems to be fine, but I'm keeping my fingers crossed.

You can bet that I will be learning a lot about replication and synchronization.

Thanks again,

Gus

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[alvechurchdata]

You have my genuine sympathy - it's an easy mistake to make when you're in a hurry.

My own solution to stop me doing this sort of thing is to rename the backups. This morning's backup of CFData is named 20051006_CFData so I'm not likely to link it in by mistake.

I don't think you need replication at all here. That's for the situation where you really do need to run two copies of the back end.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[gusbrunston]

[tt]Hi, Geoff:

Thanks for your comments.

What saved my tail, and the reason I'm not headed for the border, is that for several years I've used a procedure (which I got here at Tek-tips) for backing up hourly, so I've got backups up the ying-yang.

This morning I woke up with the realization that I had one more table to reconstruct...Got it done remotely before anyone got to the office, before my second cup of coffee.

If you're interested, I use a backup program I got from an article by Jimmy-the-Geek in tek-tips FAQ. I've had people tell me several times you can't back up an open db, but I done it with Jimmy's code successfully for a long time.

Cheers,

Gus[/tt]


[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]