jo**********@hotmail.com (Jorge) wrote in message news:<16**************************@posting.google. com>...
We have an application with Access 2000 and normally there are three
designers working simultaneously. But forms or report modifications
requires exclusive use. That force to all others users must get out of
database when a modification is required. Somebody knows how to solve
that.
Yes, you need to "split" your database .mdb file into a front-end (FE)
and back-end (BE) .mdb files. Then the FE tables are linked to the
back-end (done automatically with the Database Splitter or manually
with the Linked Table Manager - both under the Tools menu).
The FE is put on each client's PC with the BE on a share that all can
access.
Now you develop the FE further (on your PC) and distribute to the
users
when appropriate.
Is possible for example keep tables in other better database and share
to access as link?
Somebody can recommend us other database that work as access 97 where
multiple users could make modifications simultaneously?
May be a new access version as 2002?
Any ODBC compliant database will work (Oracle, SQL Server, DB/2,
Informix, MySQL, etc). You'll still have the problem if you are using
a shared FE
..mdb file. Each user needs to get a copy of the FE to prevent this
problem
and to prevent corruption of the .mdb file(s).
'---------------
' John Mishefske
'---------------