A2007 Using Tony's AutoFE User still locking FE db

[JimS]

This is crazy. My client installed a new user last week. Everything about the
install is vanilla. He's executing a FEdb located on a network by using
Tony's AutoFE to copy it to a local drive. The BEdb is on the network. Up
until this new guy was installed, everything was going fine.

The new guy (Tom) executes the Autofe shortcut from his desktop and the
Autofe process works peachy, except HE LOCKS THE MASTER FEdb! The lock lasts
for 10-20 minutes, then disappears magically. I can't tell exactly what he's
doing, but my users all have menus they work from. He's a clerk, so he's even
less likely to do something hinkey (especially after I've yelled at him
repeatedly...)

When I check his Access properties, all is good. No references I can see to
the FEdb. All the tables are linked to the backend...there are no permanent
local tables at all. In his case, no local tables at all....

Tony, any idea?

 

[Mr. B]

Jim,

This sounds like a network issue to me. Is "Tom" the only user that is
causing the "Master FEdb" to remain locked for the extended time? If so,
then it may be something to do with the way his permissions are setup or it
could be some issue with security for him.

Just my thoughts.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[JimS]

He's the guy. But he's vanilla. Nothing special. New user is all. Average of
4 users at a time, only he "locks" the FEdb. By which I mean a lock file is
created. Only his name is in it, and I can't delete the lock file.

 

[Tony Toews [MVP]]

He's the guy. But he's vanilla. Nothing special. New user is all. Average of
4 users at a time, only he "locks" the FEdb. By which I mean a lock file is
created. Only his name is in it, and I can't delete the lock file.

So you mean he creates an Access LDB file on the FE MDB on the file
server?

Hmm, I was going to say that's not possible but there is one possible
circumstance. Try using StartMethod=FileExtension.

If something really bizarre is going on then StartMethod=AutoSelect
could be doing something strange with the server FE db.

Otherwise please email me your INI file so I can take a look at it.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/