Replacing a Table with a Table from another database - reference issues

[JHB]

Hi:

I have been developing an application for soenone using dummy data and
am now trying to import a table with real data and replace the test
data I have bene using, and I have a problem.

I have created, in an application we will call CONVERT, a table which
is exactly the same as the test table in format, with new contents. It
also resets the auto number scheme used for identification of table
entries. It has exactly the same name as the table in the developed
application. The database in the new application is seperated from the
code and refers to it. I have tried both import and export and for the
life of me I cannot get the APPLICATION to refer to the new table..
Working in he "be" dataset I have deleted the old table and replaced
it with the new one, using both import and export, IAll to no avail.

Is there some simple techneque to:

Transfer a table from one database into another AND have Access
applications which use the be database refer to the correct table? I
am working with Access 2000!

Any advice much appreciated. In the meantime I will hack around and
see what I can make happen!

Thanks

John Baker

 

[Gloops]

JHB wrote, on 19th June 2012 16:54 UTC + 1 :

Hi:

I have been developing an application for soenone using dummy data and
am now trying to import a table with real data and replace the test
data I have bene using, and I have a problem.

I have created, in an application we will call CONVERT, a table which
is exactly the same as the test table in format, with new contents. It
also resets the auto number scheme used for identification of table
entries. It has exactly the same name as the table in the developed
application. The database in the new application is seperated from the
code and refers to it. I have tried both import and export and for the
life of me I cannot get the APPLICATION to refer to the new table..
Working in he "be" dataset I have deleted the old table and replaced
it with the new one, using both import and export, IAll to no avail.

Is there some simple techneque to:

Transfer a table from one database into another AND have Access
applications which use the be database refer to the correct table? I
am working with Access 2000!

Any advice much appreciated. In the meantime I will hack around and
see what I can make happen!

Thanks

John Baker

Hello,

This seems very strange.
You mean both the source and target databases are Access 2000 ?

Did you try creating a linked table and an empty table with the same
structure, and moving data between both with an SQL query ?