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" <(E-Mail Removed)> wrote in message
news:3A7F201F-5EA9-46BA-9488-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:3A7F201F-5EA9-46BA-9488-(E-Mail Removed)...
> > 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
>
>