Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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 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
 
Old April 1st, 2004, 10:19 AM
Registered User
 
Join Date: Apr 2004
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

 
Old April 1st, 2004, 02:46 PM
Authorized User
 
Join Date: Feb 2004
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
[email protected]
 
Old April 1st, 2004, 03:03 PM
Registered User
 
Join Date: Apr 2004
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


 
Old April 3rd, 2004, 01:57 AM
Authorized User
 
Join Date: Feb 2004
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
[email protected]
 
Old April 5th, 2004, 12:04 PM
Registered User
 
Join Date: Apr 2004
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.

 
Old April 6th, 2004, 08:26 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

DSN has nothing to do with how you lock a record



Sal





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





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