Database replication 1

[kermitforney]

Can you undo a replication?

 

[Remou]

How do you mean? Usually when creating a replica MSAccess strongly recommends that you create a backup. It will do it for you, creating a file called whateverthedatabaseiscalled.bak. You can rename this file .mbd

 

[evalesthy]

I don't have it in front of me right now - but I think MS white paper on Replication addresses this issue.

http://support.microsoft.com/kb/164553/en-us

 

[Remou]

If you do not have the back up, it is possible to unpick (rather than undo) the replica, but it is tedious in the extreme.

 

[kermitforney]

Ok, I am going to keep the replication the way it is for now. But I am having problems with networking now that it is replicated. When I place a copy of it on an end users workstation it cannot find the back-end. When I go through the Link Table Manager it says, "You cannot make design changes to this Replica".

How do I place this onto co-workers workstations and mantain the network setings?

Did the replication affect my split database? In other words, should I have split the database after replication?

 

[Remou]

From what little I have read on the subject, replication only applies to data. This would mean that the stages are:
1. Split database;
2. Replicate back-end only.
You can have as many front-ends as is reasonable, without replicating.

 

[kermitforney]

Oh, ok got it. Thank you . . again Remou.

 

[kermitforney]

Alright now I feel like a real idiot. (

I replicated the front end.

Now I can't find the backup either.

So where was that link again to undo this? (

 

[kermitforney]

Crap I just read how to do it.

This is gonna take forever and a day. (

God, I need to hurry up and get certified.

 

[Remou]

There is no link. It is just something I have done, to see. It really is very, very tedious. Maybe someone does have a link, though. Are you sure you can't remember where you put the backup? :-(

 

[evalesthy]

See page 15 I believe:

http://support.microsoft.com/kb/282977/en-us

 

[kermitforney]

Cardinal Sin #1 - Never delete a backup, even on accident. lololol

But anyways I just created a new blank database and then imported all the front-end stuff I needed.
So I am in good shape again.

Thanks for all of your help though guys.