Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Access 2003 VBA
This is the forum to discuss the Wrox book Beginning Access 2003 VBA by Denise M. Gosnell; ISBN: 9780764556593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access 2003 VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 23rd, 2005, 07:53 AM
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 5 Code, problems?

Hello, I have been going step by step through the book. I have had major problems in the Chapter 5 section doing the code for the bound and unbound form. Both give an error when I try to run them. The bound form an error such as

"You do not have exclusive access, so you may not be able to save changes later"

and the unbound one

"The database has been placed in a state by user 'Admin' on machine 'blahblah' that prevents it from being opened or locked."

So I downloaded the book's code and it gave me the same error with the unbound form.

When I change from running the form to going to design mode, it asks if I want to save all information. I click yes then it pops the same error up.

I am spinning my wheels :/


  #2 (permalink)  
Old September 28th, 2005, 01:05 PM
Authorized User
Points: 80, Level: 1
Points: 80, Level: 1 Points: 80, Level: 1 Points: 80, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2004
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would guess this is an ownership or properties issue. Do you sometimes log on as administrator and sometimes as some (ordinary) user? Maybe you started the project as administrator and are now trying to work on it as ordinary user.

If this sounds plausible, log on as admin, go to the db in Explorer, right click the title, then right click "Properties" and then click on the Security tab to give yourself rights as ordinary user.

Hope this helps.

  #3 (permalink)  
Old October 10th, 2005, 10:30 AM
Authorized User
Points: 80, Level: 1
Points: 80, Level: 1 Points: 80, Level: 1 Points: 80, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2004
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

My "ownership/permissions" hypothesis was wrong, I think. I"m now getting similar problems. These two error messages (also when logged in as administrator):

     "The database has been placed in a state by user 'Admin' on machine xxx that prevens it from being opened or locked."

And

     "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them."

I tried running the DB as administrator and got the same problems. This is what happens:
     If I open the form in Form View, it works OK. If I then go to design view and try to write or change the code, I get the error messages. I think that's because of the connection established by first opening in form view.
     If I open the form directly in design view, I can then change the form or the code without this problem arising. I then close the form and reopen it in form view (rather than switching to form view) and it seems to work OK.

Something similar seems to happen if one opens more than one of the forms at once.

  #4 (permalink)  
Old February 12th, 2007, 07:26 AM
Registered User
 
Join Date: Feb 2007
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Save the database. As soon as you change the design, the database is locked and will not accept any more external connections. Though it's you that's connecting, and it's you that has the database open, the adodb connection acts as an external connection and is refused.

That's my understanding anyway, but I am still reading this book so I don't know much LOL



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with chapter 1 macuser BOOK: PHP and MySQL: Create-Modify-Reuse ISBN: 978-0-470-19242-9 2 April 2nd, 2009 12:39 PM
Chapter 6 problems slannesh7 BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 August 15th, 2007 12:52 PM
Yet more Chapter 4 problems Putter BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 3 March 28th, 2007 11:37 PM
Chapter 11 Code Problems vbswshare BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 3 April 9th, 2006 08:39 PM





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