Moving Database to Network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a fairly simple database that I would like to move to a network
format. It has two tables, a forma nd subform, and a code module, with
procedures that support the form's tasks. I would like to create workstation
versions of the databse, put them on individual machines (user accounts) and
have them act as the front end to the tables, etc.

My question is: should I add linked tables to the workstation databases or
set the recordsource in the forms in the workstations to a query that has has
its source a file path that accesses the other database? The form and
subform are linked to tables that have a one to many relationship. Will I
have to define that relationship in the workstation database?

Thanks.
 
Assuming you're strictly talking about a Jet database (i.e. an MDB file),
linked tables are fine.

The relationships must exist in the backend, not the frontend.
 
Sorry, I am talking about a Jet database. And I have defined relationships
in what will be the backend.

Are linked tables the best solution, for Jet databases?

Thanks.
 
Back
Top