Importing tables and Relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a VBA utility that imports tables in a MS SQL Server 2000 database to
an Access 2000 database and also provides the user with a function to delete
these tables again. This Access database is only for users to view data,
hence I cannot link the tables as I do not want them making any changes to
the data.

They do, however, need the Relationship diagram set up. This is not possible
as each time re-importing of the tables take place, the tables need to be
deleted first which causes an error if part of the Relationship diagram.

How can I save the Relationship diagram and allow users to re-import and
delete tables?

Any help will be appreciated,
Janine
 
Janine

It sounds like the underlying need is to provide users a view of data which
they cannot change. This does not require importing a copy.

If you link to the SQL Server data using a DSN that relies on a read-only
password in SQL Server, they won't be able to update the SQL Server data.
Set your security in SQL Server.
 
See:
http://www.lebans.com/saverelationshipview.htm
NEW - Feb 04/2004 A2KSave-Restore-ModifyRelationshipWindow.zip is an
MDB containing functions to:

1) To allow the saving of the layout of the Relationship window to a
table.
2) To allow the restoration of the layout of the Relationship Window
from a table.
3) To allow the saving/restoration of multiple Relationship Window
views.
4) To allow the importing of the layout of the Relationship Window from
an external MDB.

Here is the A97 version:A97Save-Restore-ModifyRelationshipWindow.zip

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Dear Jeff

Thanks for the quick response and advise. Unfortunately, my client does not
want a 'dynamic' Access version of his SQL database. He wants to do the
import and work with the data without it changing all the time.
 
Dear Stephen

Thank you for the response. I downloaded the file and will take a look at
it. Even if it doesn't help me with my current problem, it seems to be handy
to keep around.

Regards,
Janine
 
Back
Top