Is there a way in Access 2007 to open a database with linked tables exclusively when the other database containing the tables is also open? I was told by the user that this could be done in Access 2000, but I think it is a security restriction in Access 2007. Thank you.
Carol McSween-Brooks
Hi Carol. I suspect you've been misinformed about A2000, and that A2007 does what other versions of Access have done for many years.
If an Access database is open in non-exclusive mode then it cannot be opened exclusively by anyone else.
When a connection is made to tables in the current database, or to linked back-end tables in another Access database, Access creates a lock file named after the database concerned but with extension .LDB. It uses this to record users currently accessing the database. If a user is active in using linked tables then the LDB file will show that they have access to the database concerned. Until the lock file is cleared there is no way that another user can grab exclusive use of the database.
Once all other users have exited it is of course possible to open a database in exclusive mode - but then no-one else will be able to access it until the exclusive lock is removed.
-Stewart
3 5976
Hi Carol. I suspect you've been misinformed about A2000, and that A2007 does what other versions of Access have done for many years.
If an Access database is open in non-exclusive mode then it cannot be opened exclusively by anyone else.
When a connection is made to tables in the current database, or to linked back-end tables in another Access database, Access creates a lock file named after the database concerned but with extension .LDB. It uses this to record users currently accessing the database. If a user is active in using linked tables then the LDB file will show that they have access to the database concerned. Until the lock file is cleared there is no way that another user can grab exclusive use of the database.
Once all other users have exited it is of course possible to open a database in exclusive mode - but then no-one else will be able to access it until the exclusive lock is removed.
-Stewart
Thank you, Stewart. It didn't seem like a good idea to have the linked tables open by more than one user if changes were being made to them - even if they weren't to the same records.
Carol
Hi Carol. Databases are inherently multi-user, so more than one person editing records at the same time is not a problem. What can be is how to handle more than one person editing the same record at the same time. By default, Access adopts an optimistic locking strategy, where it will only apply a lock to the current record (lock meaning denial of edit access) at the last moment, as it tries to save the changes. It will warn any other user that the record has been changed by a different user.
This lock strategy can be changed if required, so that Access locks a record from the moment a user starts to edit that record.
This would avoid a possible problem with optimistic locking, which is cascaded edits overwriting each other (one user saving changes, which are immediately overwritten by another user).
Exclusive access is more about allowing for design changes or system maintenance such as backup, as this access mode effectively makes the database single-user only. As it denies all other users access it is not normal to open a database in exclusive mode except for maintenance purposes.
-Stewart
Sign in to post your reply or Sign up for a free account.
Similar topics
by: pinballjim |
last post by:
Hello everyone,
I'm looking for a simple way to create a local copy of a linked table.
I've got a database that links about 10 tables from other databases.
This works fine on my machine, but I...
|
by: Internet Arrow Limited |
last post by:
Hi,
I have a requirement to write an access application that must run
under access97 and access2K. Some users will use Acess2K to access
data that will also be accessed by Access97 users. The...
|
by: anand |
last post by:
Hi,
I have an Access 2000 database, which contains some native tables,
and some linked tables which belong to an ORACLE database, through
ODBC.
Using VB.NET, I am trying to fetch some data by...
|
by: MeganF via AccessMonster.com |
last post by:
Hi.
I've been working on a database for a while now between my desktop and my
laptop. Each time I copy the files, I go into the Linked Table Manager and
update my path to my linked databases....
|
by: Julia |
last post by:
Hello there.
I have a question somewhat related to this topic, and I don't know
where else to go. I hope somebody can help. I've created a database
in access, that I'd like to share with less...
|
by: Jill Elaine |
last post by:
I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database,...
|
by: falbrech_www |
last post by:
Hi all,
we got here one database which has several linked tables, whereas the
link points to several csv-files. Currently we also have 2 different
queries using the linked tables. Now one of us...
|
by: bubbles |
last post by:
Using Access 2003 front-end, with SQL Server 2005 backend.
I need to make the front-end application automatically refresh the
linked
SQL Server tables.
New tables will be added dynamically in...
|
by: sherryj2 |
last post by:
Hello, I'm a total newbie here, but I have been searching for days for the answer to this without any luck.
I used your function to refresh my linked tables upon opening the front end of my...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |