A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old August 3rd, 2004, 07:27 PM
Dave Lee
external usenet poster
 
Posts: n/a
Default "Exclusive Access" (or lack thereof) suddenly an issue

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
  #2  
Old August 3rd, 2004, 11:02 PM
Eric Butts [MSFT]
external usenet poster
 
Posts: n/a
Default "Exclusive Access" (or lack thereof) suddenly an issue

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

"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

| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID:
| 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
|

  #3  
Old August 4th, 2004, 01:29 PM
Dave Lee
external usenet poster
 
Posts: n/a
Default "Exclusive Access" (or lack thereof) suddenly an issue

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 [MSFT]" wrote:

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

"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

| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID:
| 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
|


  #4  
Old August 4th, 2004, 01:31 PM
Dave Lee
external usenet poster
 
Posts: n/a
Default "Exclusive Access" (or lack thereof) suddenly an issue

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 [MSFT]" wrote:

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

"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

| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID:
| 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
|


  #5  
Old August 4th, 2004, 03:19 PM
Dave Lee
external usenet poster
 
Posts: n/a
Default "Exclusive Access" (or lack thereof) suddenly an issue

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 [MSFT]" wrote:

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

"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

| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID:
| 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
|


  #6  
Old April 12th, 2005, 08:32 PM
Padubo
external usenet poster
 
Posts: n/a
Default

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" wrote:

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 [MSFT]" wrote:

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

"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

| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID:
| 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
|


  #7  
Old April 14th, 2005, 01:20 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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" wrote in message
...
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" wrote:

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 [MSFT]" wrote:

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

"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


| Subject: "Exclusive Access" (or lack thereof) suddenly an issue
| Date: Tue, 3 Aug 2004 11:27:02 -0700
| Lines: 11
| Message-ID:
| 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
|



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Useless Access 2003 tired, angry, sucidial and bored General Discussion 10 July 21st, 2004 11:52 PM
Save Report With CreateReport Coding Issue Jeff Conrad Setting Up & Running Reports 8 July 12th, 2004 08:39 AM
Access 2002 import wizard issue Cato Database Design 3 July 2nd, 2004 03:28 PM
Access 2003 Runtime Issue IraKeener General Discussion 0 June 30th, 2004 08:42 PM


All times are GMT +1. The time now is 06:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.