[AccessD] Passive shutdown.... Driving me mad

Some things to check

http://support.microsoft.com/?kbid=274211
http://support.microsoft.com/?kbid=198756

On some versions of Access when you use "File | Open..." instead of 
using the  shortcut, you will see a
checkbox on the file open dialog with "Exclusive" next to  it. Make sure 
you don't open the db with this  checked.


Error 3734  This error occurs when the new passive
shutdown / connection control is being used.   This indicates that a user
set the database in a mode that prevents other database users from opening
it."

         When all users close the database, is there a locking file left
behind? It will be in the same folder as your database with the same name
and the extension .ldb. Delete it this file, it should be deleted when the
last user closes the database. You may need to reboot if windows will not
let you delete the file.

           If this does not resolve the problem, you may wish to create a
new database and import all objects from the old database in case the
database file is corrupted.

Related article:
Q274211 - PRB: Error Msg. 3734 Occurs When You Repeatedly Open & Close MDB

http://support.microsoft.com/support/kb/articles/q274/2/11.asp


MarkH wrote:

>Hi all...
>
>I have a database (Access XP 2002 format) on widows XP, data in a
>separate backend etc. When I try to connect to the front-end (generating
>reports using ADO in Excel from temp data stored in the FE) I get the
>following message:
>
>"The database has been placed in a state by user on machine 
>that prevents it from being opened or locked. (Error 3734)
>This error occurs when the new passive shutdown/connection control is
>being
>used. This error message indicates that a user set the database in a
>mode
>that will prevent other users from opening it."
>
>I have looked in the help and searched the archives and can't figure it
>out. The backends access, not SQL Server, I'm the only user (at present)
>and I haven't opened the database exclusively or messed with this
>"damned" connection control...
>
>Any one out there know whats going on? (apart from me climbing the walls
>that is)
>
>Cheers
>
>Mark
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003
> 
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada