Solved Moving tables with their relationship (1 Viewer)

KitaYama

Well-known member
Local time
Tomorrow, 01:55
Joined
Jan 6, 2022
Messages
1,489
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:55
Joined
May 7, 2009
Messages
19,169
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

Well-known member
Local time
Tomorrow, 01:55
Joined
Jan 6, 2022
Messages
1,489
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:55
Joined
May 7, 2009
Messages
19,169
I think relationships are imported along with the tables.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:55
Joined
May 7, 2009
Messages
19,169
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.
 

Attachments

  • relationship.accdb
    788 KB · Views: 137

theDBguy

I’m here to help
Staff member
Local time
Today, 09:55
Joined
Oct 29, 2018
Messages
21,358
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.
 
Last edited:

isladogs

MVP / VIP
Local time
Today, 16:55
Joined
Jan 14, 2017
Messages
18,186
Tick Relationships in Import Options

1653635285917.png
 

Attachments

  • 1653635243244.png
    1653635243244.png
    18.4 KB · Views: 139

KitaYama

Well-known member
Local time
Tomorrow, 01:55
Joined
Jan 6, 2022
Messages
1,489
Million thanks.
I was drag & dropping between databases.
Never thought of the import wizard.

I really appreciate your help
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:55
Joined
Feb 19, 2002
Messages
42,971
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.
 

KitaYama

Well-known member
Local time
Tomorrow, 01:55
Joined
Jan 6, 2022
Messages
1,489
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.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:55
Joined
Feb 19, 2002
Messages
42,971
You're welcome. Good luck:)

I use Carbonite on all my computers at home. It automatically backs up changed files. One of my clients even uses it for everyone's laptop.
 

isladogs

MVP / VIP
Local time
Today, 16:55
Joined
Jan 14, 2017
Messages
18,186
Just checking - you do know that the queries can all be transferred from the ACCDE to your new db ....
 

KitaYama

Well-known member
Local time
Tomorrow, 01:55
Joined
Jan 6, 2022
Messages
1,489
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

MVP / VIP
Local time
Today, 16:55
Joined
Jan 14, 2017
Messages
18,186
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

Well-known member
Local time
Tomorrow, 01:55
Joined
Jan 6, 2022
Messages
1,489
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

MVP / VIP
Local time
Today, 16:55
Joined
Jan 14, 2017
Messages
18,186
I have several articles related to this info including



This may also be of interest
 

Users who are viewing this thread

Top Bottom