SQL with a Linked Access mdb

[news.la.sbcglobal.net]

I manage an SQL database application that is linked to an Access mdb where I
have linked tables to the SQL database and the other objects reside,
queries, forms, reports. The application is run over a network and there
are multi users accessing it all the time. We recently switched from Win98
and Office97 to WinXP and Office 2002....my problem.
In the past when ever I wanted to edit my reports in Access there was no
problem, NOW, I get a message stating you may not be able to save changes to
this report because you do not exclusive access to this database.
I can create new queries and reports in a copy of the Access mdb, but I can
only IMPORT the queries but not the reports??
I am told this is a Microsoft security issue..Is there a way to do what I
need to do without taking the app off-line so I can have exclusive access to
the mdb?

Please HELP....

 

[MacDermott]

Actually - No.

Starting with Access 2000, changes can only be made to database structure
when the database is open in exclusive mode.
The usual approach to this is to split the database into a back end (tables)
and a front end (everything else).
You can then develop on one copy of the front end, while your users use
another copy.
Both can be linked to the same backend tables.
Then when you have completed your changes, chase everyone out of the
database for a short while, substitute your new front end for the old one,
and relink if necessary.

HTH
- Turtle

 

[Tony Toews]

You can then develop on one copy of the front end, while your users use
another copy.

But in A2000 and newer sharing the FE can lead to corruptions of the
FE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[MacDermott]

But certainly not more so than sharing an entire database?

So ideally the Front End should be distributed to each user's desktop.
Yes.