Problem duplicating Access 97 database that has linked tables

[jimwei]

We're using an Access 97 database that has a bunch linked tables. We need
to make a duplicated version but instead of linked tables, we need to have
real tables in the duplicated database.

So simply making a copy of the .mdb file won't work. Then from the new
database, we tried to import the tables from the old database, and it only
imported the linked tables, not the actual data. Third attempt, we exported
the tables from the old database into .xls files then import the files into
the new database. This method got the data into the new one alright, but
didn't bring in any of the field formats and lookups that will take forever
to manually recreate, and ofcourse we also don't have any relationships at
all.

Anyone know a better way to do this? Database A has a bunch linked tables,
we want to make a duplicated of A, called B, but we want real tables and
data in B, not just linked tables.

I'm pretty new at this. So if the solution is obvious don't laugh, kindly
point me in the right direction will be highly appreciated.

Thanks,

Jim

 

[Uncle Gizmo]

You should be able to import the tables OK. What appears to have happened is that you have tried to import "Links" and they will only appear as links when you import them. I used to make the same mistake!

So what you need to do is open the DB you want to import from and see if they are "Real" tables or just links. If they are links, find the DB they are linked to and see if they are "Real" if not carry on!!!!

 

[jimwei]

I tried to open the Linked Table Manager but keep on getting the this error message "Invalid Argument". So I can't find out where the real table is at.

Jim

 

[Uncle Gizmo]

What about using the "Search" facility on the "Start button" and do a search for *.mdb This will list all your db's. If there arn't to many, you could look in them for matching table names and as a safeguard, add a new record and see if it shows up... (They might be in an mde though, but its unlikly)

Sorry if thats not much help, can't think of anything else you can do.....

 

[haj1503]

Hi jimwei

What you are database currently used. Its 2000 or XP?

If you are using XP then try go to tab Table and move the mouse to the link table then you can know where the currently table there are Link.

If 2000 then try delete one of the current Link table then open the form that belong to the table, the DB will inform you that current link table. but before you doing this solution try to make a copy.

Hopefully can solve the problem if this can't help you sorry in advance at least we have tried.

Best regards.

 

[jimwei]

It's Access 97. I'll try to delete the table to see if it gives me anything.

Thanks,

Jim