Copy a split database (front end-back end)

P

plfiredis

Fire District has database of running cards (directions to streets). The
database has a front end and back end. We are building a firehouse in a
different location and I need to make another database for the new running
cards. I made a copy of the first database and pasted to another location,
but the new database tables are linked to the first database and the changes
would take place in both places.

How do I make a copy of the database and not have it linked to the first
database?

Thanks.
 
P

plfiredis

It looks like the copied database is linked to the original database. I want
them to be seperate. How do I do that?
 
R

Roger Carlson

Let's back up. You've got a split database (a front-end and a back-end). I
assumed you copied both to a new location. Is that true or did you just
copy the front end?

When you copy a front-end, it will still link to the original back-end. In
order to have it link to the new back-end, you need to use the Linked Table
Manager or delete the existing linked tables and link in the new ones.
 
T

Tony Toews [MVP]

plfiredis said:
Fire District has database of running cards (directions to streets). The
database has a front end and back end. We are building a firehouse in a
different location and I need to make another database for the new running
cards. I made a copy of the first database and pasted to another location,
but the new database tables are linked to the first database and the changes
would take place in both places.
Click to expand...

It's going to be a bit of a pain dealing with two databases.

Why not put a field in key tables and forms telling you what FireHouse
you are dealing with? And use one database for both Firehouses.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
P

plfiredis

We actually have 3 firehouses right now and I have them all in the same
database. We are building 2 new firehouses that will replace 2 of our
current ones. They are in new locations, so I need to keep the current
directions (one database), and make a new set of directions for when we move,
so I would like that to be in a second database. After we move, I won't use
the first database.

Thanks.
 
P

plfiredis

I copied the front and back end, but the front end tables show being linked
to the first table.
 
T

Tony Toews [MVP]

plfiredis said:
We actually have 3 firehouses right now and I have them all in the same
database. We are building 2 new firehouses that will replace 2 of our
current ones. They are in new locations, so I need to keep the current
directions (one database), and make a new set of directions for when we move,
so I would like that to be in a second database. After we move, I won't use
the first database.
Click to expand...

Fair enough.

BTW I'm working on Granite Fleet Manager http://www.granitefleet.com/
which is quite useful now and will have a lot of features for fire
trucks and ambulances in the near future.

Tony.
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
P

plfiredis

The linked table manager just shows the tables linked to the original
database backend and the choices are to select the tables to update the
linked tables. It doesn't give you the option to delete the link or change
it to new tables/database.
 
J

John W. Vinson

The linked table manager just shows the tables linked to the original
database backend and the choices are to select the tables to update the
linked tables. It doesn't give you the option to delete the link or change
it to new tables/database.
Click to expand...

As a matter of fact, it does, though it's perhaps not too obvious. Check the
"Always prompt for new location" checkbox at the bottom of the manager screen.
 
P

plfiredis

Thank you very much -- that is exactly what I needed and I did not see that
before. I appreciate your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE Object Makes Database to Large 11
Front end/Back end table relationships 4
Linking Multiple Front-end Database Files 3
Back end database on Internet 1
Split Database and put back End in C: Drive 2
Lookup tables and front end/back end design 2
Linked Table Relationship Not Visible in Front End 1
moving back end 2

Top