MDB or ADP

Hi All,

Using Access 2003

I have been asked to create a database in Access that contains data
imported from several old Lotus Approach tables then add forms and
reports as necessary. The thing is they want the database to be stored
on a server so that multiple people can access the data at the same
time, max 6 or 7 concurrent users say.

I have used Access and SQL Server/MSDE before but have always written
apps using either C# or C++ to interface to them so this is a bit new to
me so I have the following questions.

Is it OK to have an MDB database run over a network like this, i.e.
concurrency issues, two people trying to amend the same record at the
same time?

Would the MSDE be better and interface through Access using an Access
project?

Many thanks

Joe

No, most likely, you will have an MDB on the server containing tables,
relationships, and data. You will have either an MDB or MDE on each user's
machine containing queries, forms, reports, macros, and modules, and perhaps
some local lookup tables. The user MDB/MDE will have links to the tables on
the server.

Access is quite, quite different from the C# and C++ approach... in those
environments, there are no events that are specifically database-related. In
Access, bound tables and controls are simple and easy.

Larry Linson
Microsoft Access MVP



"Joe Black" wrote in message
...
Hi All,

Using Access 2003

I have been asked to create a database in Access that contains data
imported from several old Lotus Approach tables then add forms and reports
as necessary. The thing is they want the database to be stored on a server
so that multiple people can access the data at the same time, max 6 or 7
concurrent users say.

I have used Access and SQL Server/MSDE before but have always written apps
using either C# or C++ to interface to them so this is a bit new to me so
I have the following questions.

Is it OK to have an MDB database run over a network like this, i.e.
concurrency issues, two people trying to amend the same record at the same
time?

Would the MSDE be better and interface through Access using an Access
project?

Many thanks

Joe

Larry,

Thank you for your response.

Joe

Larry Linson wrote:
No, most likely, you will have an MDB on the server containing tables,
relationships, and data. You will have either an MDB or MDE on each user's
machine containing queries, forms, reports, macros, and modules, and perhaps
some local lookup tables. The user MDB/MDE will have links to the tables on
the server.

Access is quite, quite different from the C# and C++ approach... in those
environments, there are no events that are specifically database-related. In
Access, bound tables and controls are simple and easy.

Larry Linson
Microsoft Access MVP