SECURITY ISSUE ON REPORTS-HELP US PLEASE

All databases are stored on our server. We have about 8 work stations that each have just been recently upgraded to the new Windows XP with Office 2003. We have converted each Access database into Access 2002-2003 format. The problem is we can no longer create or copy reports if another user is in the system at the same time. Error message that we receive is: Microsoft Office Access can't save design changes or save to a new database object because another user has file open. Must have exclusive access to file to save changes.

How do we fix this??? Help?

On Tue, 22 Jun 2004 12:25:02 -0700, brenna
wrote:

How do we fix this???

Use the Database Splitter Wizard. The tables (and only the tables)
should be in a shared database on the network; each user should have
his or her own copy of a frontend, linked to those tables.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

"brenna" wrote in message
...
All databases are stored on our server. We have about 8 work stations
that each have just been recently upgraded to the new Windows XP with
Office 2003. We have converted each Access database into Access 2002-2003
format. The problem is we can no longer create or copy reports if another
user is in the system at the same time. Error message that we receive is:
Microsoft Office Access can't save design changes or save to a new database
object because another user has file open. Must have exclusive access to
file to save changes.

How do we fix this??? Help?

Go back to Access 97? :-)

Seriously, the newer versions simply do not allow design changes unless you
are the only one in the file. There is no work-around.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com