Database locks

[Sergio]

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.

[MGFoster]

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