Solved Moving tables with their relationship

[KitaYama]

Is it possible to copy all tables from an accde file to an accdb without loosing the relationships between tables?
I can recreate the relationships in target file, but if there's a way to copy tables with their relationship, it would be a great help.

Unfortunately the database is not split and I need to do some changes to a form.

Thanks.

 

[arnelgp]

Is it possible to copy all tables from an accde file to a accdb

why would you Copy when you have the Original accdb?
you can't create an accde without he accdb.

 

[KitaYama]

why would you Copy when you have the Original accdb?
you can't create an accde without he accdb.

I don't have the original accdb. Unfortunately a hard disk crash wiped off a lot of files.
I'm trying to recreate and split the database. The target accdb is not the original file, but an empty one.

Thanks for helping.

 

[arnelgp]

I think relationships are imported along with the tables.

 

[KitaYama]

I think relationships are imported along with the tables.

They don't.
I've tested it several times.

Thanks.

 

[arnelgp]

if they don't you can copy the form and 2 modules here in your new db.
after importing the tables from the external db, run form1 to
recreate the relationships.

 

[theDBguy]

They don't.
I've tested it several times.

Thanks.

When the Import Objects window opens, you can adjust what else gets imported in the Options.

 

[isladogs]

Tick Relationships in Import Options

 

[KitaYama]

Million thanks.
I was drag & dropping between databases.
Never thought of the import wizard.

I really appreciate your help

 

[isladogs]

 

[KitaYama]

How are you going to recreate the objects? I think if you search here you'll find a link to a site that can help with that.

I have a very old copy of the accdb. Using the existing forms and recreating other forms and queries will do.
It's a small & private database and doesn't worth spending money on it.
Top two weeks will take me back to where I was.

Thanks for the advice though.

 

[isladogs]

Just checking - you do know that the queries can all be transferred from the ACCDE to your new db ....

 

[KitaYama]

Just checking - you do know that the queries can all be transferred from the ACCDE to your new db ....

No I didn't. I just checked and found the query tab.
I must have been blind all these years.

Million thanks. I might have put a lot of time on what it could be copied easily.

 

[isladogs]

You're welcome.
In fact with a bit of effort using a combination of the MSysObjects and MSysQueries system tables you could also retrieve the record source for each form and report together with the row source for each combo and listbox used in each of your forms and reports and save these as queries.
Whether that is worth the effort required is another matter

 

[KitaYama]

Whether that is worth the effort required is another matter

Thanks again. It can be a chance to learn more.
I'll check the contents of the tables you mentioned and will ask google to help.

I'll be back to you if I have more questions.
Thanks again.

 

[isladogs]

I have several articles related to this info including

How Access Stores Queries 1

This article explains how Access uses the MSysQueries system table in conjunction with other system tables to display the query structure in the query design window.

www.isladogs.co.uk

Remove deleted objects

This article explains how to remove 'legacy' deleted objects from the read only MSysObjects system table if you have problems.

www.isladogs.co.uk

This may also be of interest

Relationships-3

This is the last of a three part article discussing the important use of table relationships for enforcing referential integrity. Three methods of adding relationships are discussed. The article also explains how Access uses the MSysRelationships system table to store the relationships that have...

www.isladogs.co.uk