Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 16th, 2004, 04:38 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default LNC Rename

Ref: Microsoft Access Application Development

I receive the following error when I try to rename database object:

Error No: 3734; Description: The database has been placed in a state by user 'Admin' on machine 'DISYAD01' that prevents it from being opened or locked.

Admin is me, the machine is mine.

What to do to get around this?

David
Reply With Quote
  #2 (permalink)  
Old July 17th, 2004, 01:05 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi David,

That's definitely one of the most annoying error messages Access generates, and I suspect it can be caused by all sorts of things, including a corrupt .mdb file.

I'm assumimg you're the only user in the db, and don't know if this will help you at all, but the only way I've been able to reproduce the error semi-consistently is by trying to open a connection object to the .mdb file I'm currently working in when that .mdb has unsaved changes pending in a code module somewhere. I'm just thinking that renaming an object is bound to be running some DAO code on the projects current connection under the covers, and unsaved changes might be the culprit in that case too. If you happen to have the VBA editor open while trying to rename the object, try closing it first, which will force a save of pending changes. Otherwise, closing and reopening the .mdb might be your only option.

HTH,

Bob

Reply With Quote
  #3 (permalink)  
Old July 21st, 2004, 02:15 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I tried everything that I could think of. Created a new db, copied in all tables, forms, modules, etc., etc. There are no other references except to the MS libraries needed to compile, and the Replace9.mde. Any more suggestions?

David
Reply With Quote
  #4 (permalink)  
Old July 21st, 2004, 04:37 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi David,

The only other thing that comes to mind is you might try splitting the db if it isn't already split. That'll leave your data and application objects completely independent of one another. What type of object are you trying to rename? Does toggling the Tools --> Options --> Advanced --> Default open mode property between Shared and Exclusive have any impact?

Bob

Reply With Quote
  #5 (permalink)  
Old July 21st, 2004, 04:55 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

The other slightly weird thing in your case is that error value 3734
is an ADO error, not a Jet or VBA error, associated with the adErrOutOfSpace constant in the ADO ErrorValueEnum. The error description associated with this value is:

"Operation cannot be performed. Provider cannot obtain enough storage space. There might not be enough RAM or hard-drive space for temporary files on the server."

...not the description you are reporting. No idea what thats about.

Bob

Reply With Quote
  #6 (permalink)  
Old July 21st, 2004, 05:28 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Tried the shared/exclusive option - same error. Most of my data is in linked tables - to Oracle. Tried removing these links. Leaves me with a couple of small tables - still the same.

FYI: I a running Windows XP on a 3.06 G processor with 1 G of memory.
My db is on the LAN - my department's server.

Anything else come to mind?

David
Reply With Quote
  #7 (permalink)  
Old November 16th, 2006, 09:42 PM
Registered User
 
Join Date: Nov 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi David,

I suspect that your problem can be caused by many sorts of reasons, including a corrupt .mdb file, therefore, you can try our product Advanced Access Repair to repair your Microsoft Access databases. It is a powerful Access recovery tool. It can recover deleted tables and records in Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed information about Advanced Access Repair.

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile Error when running LNC Rename Add-in Dhanick Access 1 December 1st, 2008 08:55 AM
LNC Rename control Add-in error jbage BOOK: Expert One-on-One Access Application Development 7 March 22nd, 2007 08:41 AM
Where is the LNC Rename Add in? billblackett BOOK: Expert One-on-One Access Application Development 2 February 14th, 2007 02:10 PM
LNC Loralee BOOK: Expert One-on-One Access Application Development 0 December 10th, 2004 12:48 AM
LNC Rename Controls tlwaltz BOOK: Expert One-on-One Access Application Development 4 July 30th, 2004 08:23 AM



All times are GMT -4. The time now is 02:28 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.