|
Home > Archive > MS Access data conversion > June 2005 > Problem Copying DB Structure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem Copying DB Structure
|
|
| Why Not 2005-06-21, 8:25 pm |
| I am working with an enhanced version of the NorthWinds DB that came with a
book from Microsoft Press. It does everything I need to do for a project at
work. However, I cannot delete the existing records in order to adapt it
for my use. I've used the Access utility to copy database structure to
clone the database using the "Definition Only" option, but it did not work.
(The utility did successfully clone another Acess database, so I know it
works.) Apparently, there is some addiitonal protection that prevents the
removal of its records.
When I try to remove the relationship between two tables I get an error
message that I can't delete relationships from "linked tables" from an
"inherited" database.
When I open a table in Design View I get a warning that the table structure
cannot be modified.
If I edit a relationship between two tables I can see that referential
integrity is checked, but it is greyed out, so I can't change it.
This database does everything I need it to do. All I need is to purge the
exisitng data and my project is done. Question: Does anyone know how to
hack into such a database so that I can clone the structure or delete the
existing records?
| |
| Jeff Boyce 2005-06-22, 9:24 am |
| From the messages you report, it would appear that you are working with
linked tables. You can't alter the definition or relationships between
tables in another database (i.e., linked tables). To do this, you'll need
to go to the back-end, where the data tables are actually defined.
Consider making a backup copy before making any changes!
--
Good luck
Jeff Boyce
<Access MVP>
"Why Not" <mcgolrick@starpower.net> wrote in message
news:RImdneaOPbY6IyX
fRVn-hA@rcn.net...
> I am working with an enhanced version of the NorthWinds DB that came with
a
> book from Microsoft Press. It does everything I need to do for a project
at
> work. However, I cannot delete the existing records in order to adapt it
> for my use. I've used the Access utility to copy database structure to
> clone the database using the "Definition Only" option, but it did not
work.
> (The utility did successfully clone another Acess database, so I know it
> works.) Apparently, there is some addiitonal protection that prevents the
> removal of its records.
>
> When I try to remove the relationship between two tables I get an error
> message that I can't delete relationships from "linked tables" from an
> "inherited" database.
>
> When I open a table in Design View I get a warning that the table
structure
> cannot be modified.
>
> If I edit a relationship between two tables I can see that referential
> integrity is checked, but it is greyed out, so I can't change it.
>
> This database does everything I need it to do. All I need is to purge the
> exisitng data and my project is done. Question: Does anyone know how to
> hack into such a database so that I can clone the structure or delete the
> existing records?
>
>
>
>
>
|
|
|
|
|