By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,401 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,401 IT Pros & Developers. It's quick & easy.

Database locks

P: n/a
Hi all!

I have a data .mdb file (in Access 2000 format) that's being used by
two applications. These applications are built with Access 2K and all
this runs under Windows 2000. Each application is run in a diferent
computer.
When I run application 1, it locks the database access to application
2(the message says that other user has opened the mdb database in
exclusive mode). The applications lock properties are set for sharing
the mdb file (non exclusive).

Anybody can help me to solve the problem??

Thx in advance,

Sergio.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Is there a back-end (data tables) on a commonly accessible
computer/server? Does each user have a copy of the front-end
(queries, forms, reports) on their computer? If not, that is what you
need to do. It sounds like your users are opening a single front-end
(on a commonly accessible computer/server) instead of their own,
separate front-end.

Also, set the forms RecordLocks property to use Optimistic locking (No
Locks).

Also, you usually do not want to open App2 from App1. You want to
have each App use the data file on the server. E.g.:

App1 App2
(PC) (PC)
| |
| |
+-------+-------+
|
Data
(server)
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDuI7IechKqOuFEgEQLUngCghOML2peC1OrpXPl9hRTYzM Aw0XEAoNcn
Ua3DytswHRyyM3TMa+3COkf1
=gYLl
-----END PGP SIGNATURE-----
Sergio wrote:
Hi all!

I have a data .mdb file (in Access 2000 format) that's being used by
two applications. These applications are built with Access 2K and all
this runs under Windows 2000. Each application is run in a diferent
computer.
When I run application 1, it locks the database access to application
2(the message says that other user has opened the mdb database in
exclusive mode). The applications lock properties are set for sharing
the mdb file (non exclusive).


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.