How to keep report from locking other users out

[Bill Teske]

I have a multiuser program the works fine except when a report is opened in
print preview other user get a message that the database is locked by user
admin on machine ... Does anyone know how to stop this.

 

[golfinray]

Try Tools\options\advanced and either set no locks or record level locking.
Access locks a RECORD anytime someone enters a form or report. As long as
someone is not trying to view that one record, they should be ok.

 

[Keith Wilby]

I have a multiuser program the works fine except when a report is opened in
print preview other user get a message that the database is locked by user
admin on machine ... Does anyone know how to stop this.

Have you split your application and given each user their own copy of the
FE?

Keith.
www.keithwilby.co.uk

 

[Bill T]

I have it split. The database runs off a network share and there are
potentially a couple hundred PC's that it could run from. I need to have 1
location to make changes and updates so I don't think putting a copy of the
front end (only used for reports) on each PC. I tried Tools -> Options->
advanced and even unchecked use locking since the FE is only used for
reports and there is no data entry through the front end and that didn't
work either. Thanks for the replies.

Bill

 

[Keith Wilby]

I have it split. The database runs off a network share and there are
potentially a couple hundred PC's that it could run from. I need to have 1
location to make changes and updates so I don't think putting a copy of the
front end (only used for reports) on each PC. I tried Tools -> Options->
advanced and even unchecked use locking since the FE is only used for
reports and there is no data entry through the front end and that didn't
work either. Thanks for the replies.

You should not share front end files, you should supply each user with their
own copy. There are various ways to achieve this but I find the batch file
method works well. Have your users' shortcuts point to a batch file that
copies the FE to their local drive and then launches it. Typically:

ECHO OFF

DEL "%userprofile%\desktop\MyShortcut.lnk"
XCOPY "X:\Applications\MyShortcut.lnk" "%userprofile%\desktop" /Q

DEL "%temp%\MyFE.mde"
XCOPY "X:\Applications\MyFE.mde" "%temp%\" /Q
START "%temp%" /MAX "C:\Program Files\Microsoft
Office\Office11\MSACCESS.EXE" "%temp%\MyFE.mde"

Keith.
www.keithwilby.co.uk