PC Review


Reply
Thread Tools Rate Thread

Access locking up

 
 
bgetson@gmail.com
Guest
Posts: n/a
 
      15th Jan 2007
I've seen this same topic throughout the groups before, but I'm having
trouble figuring out what the source problem is.

Randomly (about 1 in 20 tries) Access 2003 opens with a "Read-Only"
error which prevents users from modifying any data. This is happening
on multiple usernames and doesn't seem to be influenced by how many
computers are accessing the database at one time. The error occurs even
if only one user is opening the file.

I do not believe that the error is caused by permissions because it
does not occur every time. It is possible that the .ldb file is not
being deleted frequently enough because the file is reopened by the
same user with approximately a 5 minute gap. However, this has happened
with as much as a 20 minute gap between openings.

Any insight would be greatly appreciated because this is significantly
slowing processing time.
-BGetson

 
Reply With Quote
 
 
 
 
Bill Mosca, MS Access MVP
Guest
Posts: n/a
 
      15th Jan 2007
Your point about the same user opening the file more than one time within
the life of the LDB should have no bearing on your issue.

I would check to see if the LDB is hanging. Could be a laptop undocking
improperly or someone ending an instance with the task manager or a loss of
connectivity.


--
Bill Mosca, MS Access MVP


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've seen this same topic throughout the groups before, but I'm having
> trouble figuring out what the source problem is.
>
> Randomly (about 1 in 20 tries) Access 2003 opens with a "Read-Only"
> error which prevents users from modifying any data. This is happening
> on multiple usernames and doesn't seem to be influenced by how many
> computers are accessing the database at one time. The error occurs even
> if only one user is opening the file.
>
> I do not believe that the error is caused by permissions because it
> does not occur every time. It is possible that the .ldb file is not
> being deleted frequently enough because the file is reopened by the
> same user with approximately a 5 minute gap. However, this has happened
> with as much as a 20 minute gap between openings.
>
> Any insight would be greatly appreciated because this is significantly
> slowing processing time.
> -BGetson
>



 
Reply With Quote
 
John Vinson
Guest
Posts: n/a
 
      15th Jan 2007
On 15 Jan 2007 08:35:59 -0800, (E-Mail Removed) wrote:

>Any insight would be greatly appreciated because this is significantly
>slowing processing time.


Run, do not walk, to the Database Splitter Wizard. Multiple users
should emphatically NOT be opening the same unitary database.

See http://www.granite.ab.ca/access/splitapp for details.

John W. Vinson[MVP]
 
Reply With Quote
 
bgetson@gmail.com
Guest
Posts: n/a
 
      15th Jan 2007
Thank you for your input, but how would I check to see if the LDB is
hanging?

I know that it is not related to the task manager. In my attempts to
recreate the problem, I can open the Access database as the only user,
but still receive the "read-only" error. The file will open and close
like normal, but something will kick in after so many tries and lock me
out.

Also, about splitting the database: that's one of my next steps. This
is currently a local project, but once it is completed, Access will be
used as a front-end. It shouldn't be affecting this specific problem
though because it is occurring if only a single user is accessing the
file.

If there is some way for me to narrow down the possible causes that
would be great.

-BGetson

 
Reply With Quote
 
Bill Mosca, MS Access MVP
Guest
Posts: n/a
 
      15th Jan 2007
To check if the LDB is hung up, first make sure all users are out of the
database by opening the LDB in notepad and looking at the list of users. If
your database is secured with a workgroup you will have to log in first o
rthe LDB will appear encrypted.

Once you see who is in the LDB file, find out if they are really in the
database by calling them and asking. (At this point, that is the only real
method I know of if the LDB is hung up.)

Ask all users to log off. Log out of the db. Delete the LDB file. If you
cannot delete it, it is hung up and your network people will have to force
it closed and then delete it.

Once you split the database, whether with an Access back end or an SQLS back
end, and you give each user his own front end, this Read-only problem should
go away.

One more thing to check...is anyone opening the database by going through
Windows Explporer and double-clicking the file? That will open it
exclusively if no one else is in it. They can also open it exclusively by
opening Access and opening it in exclusive mode.

I guess that's actually 2 things to check. Those issues can be superficially
avoided if users are given a shortcut with msaccess.exe as the initial part
of the target as in:
"C:\Program Files\Microsoft Office\Office11\msaccess.exe"
"\\MyServer\MyDB.mdb"

--
Bill Mosca, MS Access MVP


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thank you for your input, but how would I check to see if the LDB is
> hanging?
>
> I know that it is not related to the task manager. In my attempts to
> recreate the problem, I can open the Access database as the only user,
> but still receive the "read-only" error. The file will open and close
> like normal, but something will kick in after so many tries and lock me
> out.
>
> Also, about splitting the database: that's one of my next steps. This
> is currently a local project, but once it is completed, Access will be
> used as a front-end. It shouldn't be affecting this specific problem
> though because it is occurring if only a single user is accessing the
> file.
>
> If there is some way for me to narrow down the possible causes that
> would be great.
>
> -BGetson
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 OLE communication error - locking up Access =?Utf-8?B?Um9iIE1jQ29uZWdoeQ==?= Microsoft Access 2 3rd Jan 2008 02:44 PM
Access Locking Up =?Utf-8?B?R2VtaW5pc3Q=?= Microsoft Access 1 17th Nov 2006 01:19 PM
ACCESS 2003 record locking vs page frame locking =?Utf-8?B?c2ltY29u?= Microsoft Access 3 3rd Jul 2006 03:05 PM
Access locking up =?Utf-8?B?Qm9i?= Microsoft Access 0 20th Apr 2004 01:26 PM
Re: Locking access to VB Ed Microsoft Excel Misc 0 26th Aug 2003 02:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 PM.