By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

Urgent Help Needed-Copying a FE/BE db

P: n/a
itm
I have to copy a FE/BE Access 2002 database on a regular basis to a CD
to take to another site to use at that site. The data does not have to
be up to the minute at that site.

Is there a simple way to copy the db with the linked tables but without
the links? In other words, the complete db would be usable on any
computer anywhere. I would really appreciate some help with this asap
as my boss is breathing down my neck. Thanks!

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 21 Jan 2005 08:32:28 -0800, it*@itmservices.com wrote:
I have to copy a FE/BE Access 2002 database on a regular basis to a CD
to take to another site to use at that site. The data does not have to
be up to the minute at that site.

Is there a simple way to copy the db with the linked tables but without
the links? In other words, the complete db would be usable on any
computer anywhere. I would really appreciate some help with this asap
as my boss is breathing down my neck. Thanks!


Create a new blank database.
Click File + Get External Data + Import

Navigate to the back end.
Select all the tables. nClick Options. Select Relationships, Menu and
Toolbar, and Import/Export specs in the Import options, and also
Definitions and data from the import Table options.
Click OK.

Click File + Get External Data + Import (again).
Navigate to the front end.
Select all the Forms, Queries, Reports, Macros, Modules, etc.
NOTE: If the Front end includes any tables (that are not on the back
end), select those as well.
Click OK.
Save the database.
Copy it to a disk.
If you copy it to a CD, it will be read only if you attempt to open
it.
Copy the database from th CD onto the new computer.
Right-Click on the database icon.
Select Properties. Uncheck the Read Only box.
Now it is ready for interactive use.
That should be all you need.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
copy both the front end and the backend to the CD then move it, then
relink it when you put it on the computer in the new place.... the only
thing you might have to watch for is the CD setting the read-only
properties of the files to true, in which case you won't be able to
edit them unless you change it back.

Nov 13 '05 #3

P: n/a
<it*@itmservices.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
I have to copy a FE/BE Access 2002 database on a regular basis to a CD
to take to another site to use at that site. The data does not have to
be up to the minute at that site.

Is there a simple way to copy the db with the linked tables but without
the links? In other words, the complete db would be usable on any
computer anywhere. I would really appreciate some help with this asap
as my boss is breathing down my neck. Thanks!


You can simply delete the linked tables in the front end which you send out
and get code in the front end automatically re-links the tables. Or perhaps
leave the links and if you can't open a linked table - it must need
refreshing. Different people have different strategies for this, but there
are loads of code examples out there.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.