Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 April 1st, 2004, 10:19 AM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default permit read only while database is OPEN

I need to allow all others read-only access to an Access database while it is open and being updated by another user.
It is currently updated by opening it in Access with no other front-end.

Read-only connections may use ADO.

Thanks

Durwood

Reply With Quote
  #2 (permalink)  
Old April 1st, 2004, 02:46 PM
Authorized User
 
Join Date: Feb 2004
Location: Edmonton, Alberta, Canada.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You may start by looking at the help on the record locking choices. The Tools/Options menu, Advanced tab is the user interface to the settings.

Your question is vague in that it gives no indication as to whether you need all tables locked even if an unrelated table/record is being edited.

Record lock information is maintained in the file with the same name as the database but with an extension '.ldb'. Various tools exist for reading/interpreting the lock file information but it is not trivial. The read only connections can use this information to open non updatable recordsets based on lock file indications.

Alternately, you can set a flag record if you use a form interface (on dirty) to the data and use your ADO access to query the flag record/table and provide appropriate access.

Ciao
Jürgen Welz
Edmonton AB Canada
jwelz@hotmail.com
Reply With Quote
  #3 (permalink)  
Old April 1st, 2004, 03:03 PM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I only need to lock one table. I need to be able to display information on a web page even if the table is being edited. As it is now, If the table is open for editing the "in use . . ." error is given.

Thanks for your assitance
Durwood


Reply With Quote
  #4 (permalink)  
Old April 3rd, 2004, 01:57 AM
Authorized User
 
Join Date: Feb 2004
Location: Edmonton, Alberta, Canada.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sounds like optimistic locking is called for. You may want the web ADO recordset to look at a clone of the table that is being updated if records are continually being updated.

Ciao
Jürgen Welz
Edmonton AB Canada
jwelz@hotmail.com
Reply With Quote
  #5 (permalink)  
Old April 5th, 2004, 12:04 PM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would like to replicate but it may prove unecessary as I specified (we are using DSN on this connection) the connection as read-only.

We shall see.

Reply With Quote
  #6 (permalink)  
Old April 6th, 2004, 08:26 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

DSN has nothing to do with how you lock a record



Sal
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
Read an already open Excel file in VB.NET sunilr General .NET 4 February 28th, 2014 07:20 AM
open access db from read only media (eg. CD) albertos ADO.NET 0 August 27th, 2005 06:54 PM
Read only Database error larry101 Classic ASP Databases 4 September 11th, 2004 08:41 AM
Attempted to open a database that is already open person747 Access 10 September 3rd, 2004 04:31 PM
How to open word document using ASP and read ksaleemkhan Classic ASP Components 3 April 28th, 2004 04:43 PM



All times are GMT -4. The time now is 11:18 PM.


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