Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | 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 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 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 :/


Reply With Quote
  #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.

Reply With Quote
  #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.

Reply With Quote
  #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

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



All times are GMT -4. The time now is 08:39 PM.


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