Copying a split database

[PeterJC]

I have a split database (Access 2007) with the back end on a server and
front ends on various local hard drives. I've made copies of the front end
and back end, and linked the front end copy to the back end copy, so that I
can do development on the front end and also test it with data entry, etc,
using the copy of the back end to avoid messing up the original back end.
However, it seems that the front end is linked to copies of all the tables
and is still linked to the original table in the original back end, and any
data changes I make in the front end copy (linked to the back end copy) are
also made in the original back end.
I suppose I should delink the front end copy from the original back end
before I link it to the copy of the back end. How do I do this please?
Thanks in anticipation,

 

[Clif McIrvin]

In A2003 I delete all the tables shown in the FE; then re-link. I don't
know if there is another technique. (Well, not strictly true ... I have
seen threads discussing using VBA to re-link tables but have had no need
to investigate that for my own use.)

 

[Jeff Boyce]

I'm with Clif ...

If I'm only going to need to do it once or twice, I'll step through the list
of linked tables, deleting each link one-by-one, then using External Data to
build new links.

If I anticipate (or find, after the fact) that I need to regularly
de-link/re-link, I add in relinker code -- I believe Armen S. has some at
his J-Street site.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Frank H]

If I understand you question correctly, the fastest thing to do is to delete
the table links in the front end. Then use the access button on the external
data tab to link to the tables in the copy of the back end.

They should have the same names, and everything "should" begin working
properly.

If that's not it, then I don't understand the question.