"Exclusive Access" (or lack thereof) suddenly an issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a casual Access user who just ran into a new problem. In a relatively simple database I am suddenly getting messages about the fact that I do not have exclusive access to my database. And I suddenly seem to be unable to save changes made to forms for this reason.

This is a single user database installed on a single user system (Win2000 Pro, Access 2003). I have never set up a user group, users, or anything else like that. Whatever is the default is what it is (unless I inadvertently changed it somehow). I am logged onto my system as the administrator (the only established Win2000 login on this computer).

How did this happen and, more importantly, how can I make this go away?

Thanks.

dave

dave
 
Hi Dave,

Close Microsoft Access.
Via Windows Explorer navigate to the folder where your database file
resides.
Do you see a file listed there as [same name as your database].LDB?

If so, delete it. Reopen your database. Are you now able to save design
changes?

If you don't see the related *.LDB file then reopen your database and with
your database file opened look in the folder again to see if you see the
*.LDB file.

Should you not see it then the folder you have your database file in does
not allow you FULL Control.

Other causes are corrupted database (*.LDB file never deletes itself after
you close your database file).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: "Exclusive Access" (or lack thereof) suddenly an issue
| thread-index: AcR5h3jYMyXbTgDESg6Hn3vyTUdFsw==
| X-WBNR-Posting-Host: 165.121.136.27
| From: "=?Utf-8?B?RGF2ZSBMZWU=?=" <Dave (e-mail address removed)>
| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.gettingstarted
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.gettingstarted:153116
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| I am a casual Access user who just ran into a new problem. In a
relatively simple database I am suddenly getting messages about the fact
that I do not have exclusive access to my database. And I suddenly seem to
be unable to save changes made to forms for this reason.
|
| This is a single user database installed on a single user system (Win2000
Pro, Access 2003). I have never set up a user group, users, or anything
else like that. Whatever is the default is what it is (unless I
inadvertently changed it somehow). I am logged onto my system as the
administrator (the only established Win2000 login on this computer).
|
| How did this happen and, more importantly, how can I make this go away?
|
| Thanks.
|
| dave
|
| dave
|
 
Thanks, Eric. While I didn't have a .LDB file with the same filename as the one that I was working on, there was one associated with an old backup copy. I deleted that one and, at least once, was now able to edit my forms without argument from Access.

dave

Eric Butts said:
Hi Dave,

Close Microsoft Access.
Via Windows Explorer navigate to the folder where your database file
resides.
Do you see a file listed there as [same name as your database].LDB?

If so, delete it. Reopen your database. Are you now able to save design
changes?

If you don't see the related *.LDB file then reopen your database and with
your database file opened look in the folder again to see if you see the
*.LDB file.

Should you not see it then the folder you have your database file in does
not allow you FULL Control.

Other causes are corrupted database (*.LDB file never deletes itself after
you close your database file).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: "Exclusive Access" (or lack thereof) suddenly an issue
| thread-index: AcR5h3jYMyXbTgDESg6Hn3vyTUdFsw==
| X-WBNR-Posting-Host: 165.121.136.27
| From: "=?Utf-8?B?RGF2ZSBMZWU=?=" <Dave (e-mail address removed)>
| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.gettingstarted
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.gettingstarted:153116
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| I am a casual Access user who just ran into a new problem. In a
relatively simple database I am suddenly getting messages about the fact
that I do not have exclusive access to my database. And I suddenly seem to
be unable to save changes made to forms for this reason.
|
| This is a single user database installed on a single user system (Win2000
Pro, Access 2003). I have never set up a user group, users, or anything
else like that. Whatever is the default is what it is (unless I
inadvertently changed it somehow). I am logged onto my system as the
administrator (the only established Win2000 login on this computer).
|
| How did this happen and, more importantly, how can I make this go away?
|
| Thanks.
|
| dave
|
| dave
|
Click to expand...
 
Thanks, Eric. While there was not a .LDB file with
the same filename as the one that I was working on,
there was one associated with an old backup copy. I
deleted that one and, at least once, Access allowed
me to edit my forms.

dave

Eric Butts said:
Hi Dave,

Close Microsoft Access.
Via Windows Explorer navigate to the folder where your database file
resides.
Do you see a file listed there as [same name as your database].LDB?

If so, delete it. Reopen your database. Are you now able to save design
changes?

If you don't see the related *.LDB file then reopen your database and with
your database file opened look in the folder again to see if you see the
*.LDB file.

Should you not see it then the folder you have your database file in does
not allow you FULL Control.

Other causes are corrupted database (*.LDB file never deletes itself after
you close your database file).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: "Exclusive Access" (or lack thereof) suddenly an issue
| thread-index: AcR5h3jYMyXbTgDESg6Hn3vyTUdFsw==
| X-WBNR-Posting-Host: 165.121.136.27
| From: "=?Utf-8?B?RGF2ZSBMZWU=?=" <Dave (e-mail address removed)>
| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.gettingstarted
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.gettingstarted:153116
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| I am a casual Access user who just ran into a new problem. In a
relatively simple database I am suddenly getting messages about the fact
that I do not have exclusive access to my database. And I suddenly seem to
be unable to save changes made to forms for this reason.
|
| This is a single user database installed on a single user system (Win2000
Pro, Access 2003). I have never set up a user group, users, or anything
else like that. Whatever is the default is what it is (unless I
inadvertently changed it somehow). I am logged onto my system as the
administrator (the only established Win2000 login on this computer).
|
| How did this happen and, more importantly, how can I make this go away?
|
| Thanks.
|
| dave
|
| dave
|
Click to expand...
 
Thank you both. I was unable to fund the .LDB file but there was one listed
as "record-locking." That seemed to be my problem. I deleted it and was given
free access. Thanks again,
pdb

Dave Lee said:
Thanks, Eric. While there was not a .LDB file with
the same filename as the one that I was working on,
there was one associated with an old backup copy. I
deleted that one and, at least once, Access allowed
me to edit my forms.

dave

Eric Butts said:
Hi Dave,

Close Microsoft Access.
Via Windows Explorer navigate to the folder where your database file
resides.
Do you see a file listed there as [same name as your database].LDB?

If so, delete it. Reopen your database. Are you now able to save design
changes?

If you don't see the related *.LDB file then reopen your database and with
your database file opened look in the folder again to see if you see the
*.LDB file.

Should you not see it then the folder you have your database file in does
not allow you FULL Control.

Other causes are corrupted database (*.LDB file never deletes itself after
you close your database file).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: "Exclusive Access" (or lack thereof) suddenly an issue
| thread-index: AcR5h3jYMyXbTgDESg6Hn3vyTUdFsw==
| X-WBNR-Posting-Host: 165.121.136.27
| From: "=?Utf-8?B?RGF2ZSBMZWU=?=" <Dave (e-mail address removed)>
| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.gettingstarted
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.gettingstarted:153116
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| I am a casual Access user who just ran into a new problem. In a
relatively simple database I am suddenly getting messages about the fact
that I do not have exclusive access to my database. And I suddenly seem to
be unable to save changes made to forms for this reason.
|
| This is a single user database installed on a single user system (Win2000
Pro, Access 2003). I have never set up a user group, users, or anything
else like that. Whatever is the default is what it is (unless I
inadvertently changed it somehow). I am logged onto my system as the
administrator (the only established Win2000 login on this computer).
|
| How did this happen and, more importantly, how can I make this go away?
|
| Thanks.
|
| dave
|
| dave
|
Click to expand...
Click to expand...
 
Padubo

From your description, is there a chance your display doesn't show file
extensions -- Windows can be customized to either display or not show the
extensions. If you found a "record-locking" file, I believe you found the
..LDB file.

--
Good luck

Jeff Boyce
<Access MVP>

Padubo said:
Thank you both. I was unable to fund the .LDB file but there was one listed
as "record-locking." That seemed to be my problem. I deleted it and was given
free access. Thanks again,
pdb

Dave Lee said:
Thanks, Eric. While there was not a .LDB file with
the same filename as the one that I was working on,
there was one associated with an old backup copy. I
deleted that one and, at least once, Access allowed
me to edit my forms.

dave

Eric Butts said:
Hi Dave,

Close Microsoft Access.
Via Windows Explorer navigate to the folder where your database file
resides.
Do you see a file listed there as [same name as your database].LDB?

If so, delete it. Reopen your database. Are you now able to save design
changes?

If you don't see the related *.LDB file then reopen your database and with
your database file opened look in the folder again to see if you see the
*.LDB file.

Should you not see it then the folder you have your database file in does
not allow you FULL Control.

Other causes are corrupted database (*.LDB file never deletes itself after
you close your database file).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: "Exclusive Access" (or lack thereof) suddenly an issue
| thread-index: AcR5h3jYMyXbTgDESg6Hn3vyTUdFsw==
| X-WBNR-Posting-Host: 165.121.136.27
| From: "=?Utf-8?B?RGF2ZSBMZWU=?=" <Dave (e-mail address removed)>
| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.gettingstarted
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.gettingstarted:153116
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| I am a casual Access user who just ran into a new problem. In a
relatively simple database I am suddenly getting messages about the fact
that I do not have exclusive access to my database. And I suddenly seem to
be unable to save changes made to forms for this reason.
|
| This is a single user database installed on a single user system (Win2000
Pro, Access 2003). I have never set up a user group, users, or anything
else like that. Whatever is the default is what it is (unless I
inadvertently changed it somehow). I am logged onto my system as the
administrator (the only established Win2000 login on this computer).
|
| How did this happen and, more importantly, how can I make this go away?
|
| Thanks.
|
| dave
|
| dave
|
Click to expand...
Click to expand...
Click to expand...
 
Back
Top