Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Conversion / June 2005

Tip: Looking for answers? Try searching our database.

Problem Copying DB Structure

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Why Not - 22 Jun 2005 02:28 GMT
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 - 22 Jun 2005 15:23 GMT
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!

Signature

Good luck

Jeff Boyce
<Access MVP>

> 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
[quoted text clipped - 19 lines]
> hack into such a database so that I can clone the structure or delete the
> existing records?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.