Importing tables and Relationships

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.

--
Good luck

Jeff Boyce
Access MVP

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.


"Janine" wrote in message
...
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

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.

"Jeff Boyce" wrote:

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.

--
Good luck

Jeff Boyce
Access MVP

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

"Stephen Lebans" wrote:

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.


"Janine" wrote in message
...
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