PC Review


Reply
Thread Tools Rate Thread

Copying DB Structure

 
 
Why Not
Guest
Posts: n/a
 
      22nd Jun 2005
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?




 
Reply With Quote
 
 
 
 
TC
Guest
Posts: n/a
 
      22nd Jun 2005
I don't particularly know Northwind, not having looked at it for many
years, but, it sounds to me as if the database is split into a
so-called "front end/back end" structure, where all the tables are in
the back end (BE), and everything else (forms etc.) is in the FE. It
sounds like you are trying to change relationships or table structures
in the FE. You don't do those things in the FE - you do them in the BE;
ie. the database containing the actual tables - not the one containing
the /links/ to those tables.

Does that help?
TC

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Database Structure LBA Microsoft Access 2 26th Aug 2009 07:32 PM
Navigation structure not copying C.M.G. Microsoft Frontpage 2 14th Sep 2006 03:15 AM
copying table structure in VBA =?Utf-8?B?Q2hyaXNC?= Microsoft Access Form Coding 7 2nd Mar 2005 01:25 AM
Re: Copying unmanaged memory pointer of structure to managed structure array Mattias Sjögren Microsoft VC .NET 0 28th Aug 2004 03:19 PM
copying database structure only =?Utf-8?B?VGFn?= Microsoft Access 1 21st Apr 2004 01:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:53 AM.