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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
#3
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |