Moving a table to the back end

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my haste, I've messed around and created a new table in the FE. I know
that need to move it to the BE, but I'm concerned about the mess it will
cause with the form that uses it. Should I be? If so, what steps should I
take next?

Nicole
 
Should not cause a problem if you follow these steps.

Close the front end file.

Open the back end file. Go to File | Get External Data ... | Import, and
select the front end file. Select the table in question, and import it with
its data (see Options and be sure you've got the Structure and data checkbox
checked) into the back end file. Close the backend file.

Open the front end file. DO NOT open the form or any queries based on that
table until you've finished linking to the table. Go to the table that you
just copied into the back end file. Click on it. Delete it. Go to Tools |
Database Utilities | Linked Table Manager. Select the back end file. Select
the table, and click Ok (or Import, I forget which it's named).

Your front end now is linked to that table, and your form should work
correctly.
 
To add to the reply I just posted:

Before you do anything, make a backup copy of your front end file, just in
case something goes wrong, before you follow the steps that I posted.
 
....and if the backend is SQLServer, then you would need to change the
code
that refers to the tablename.

In SQLServer, the tablename would be something like dbo.myTableName.
A Linked table would have the name dbo_MyTableName

HTH
Bubbles
 
Not necessarily if you use DoCmd.TransferDatabase you can retain the
table_names
Or you can use Docmd.Rename or do it manually offcourse

Pieter
 
Back
Top