can i automatically delete relationships between tables in access

C

Concrete Hippo

when i import a database, i rename the old tables and then delete them, and
rename the imported tables.
when i import again the tables relationships have been recreated and cause
an error.
is it possible to automatically delete relationships or prevent them being
created.

Access 2003
 
B

Brendan Reynolds

When importing, in the Import Objects dialog box, click the 'Options'
button. This will expand the dialog box to show some additional options, and
one of those options is whether or not to import relationships. The option
is selected by default. Unselect it (uncheck the box labelled
'Relationships') and relationships will not be imported.
 
C

Concrete Hippo

I managed to find it on my own,
but thanks for the helpful answer.

The Concrete Hippo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top