Distributed Application

  • Thread starter Thread starter fazee.ent
  • Start date Start date
F

fazee.ent

In ms access i have developed a MIS running on a single pc now i want
to to develope a DATA ENTRY MODULE to be used on other pc through LAN
windwos based network

i want to connect that module forms to tables of main application

can any body help me,

thanks and regards

faisal iqbal ch
 
Develop your access database with the tables, queries, forms, reports etc.
Then split the database to place the tables in a backend db, linked to the
frontend (forms reports etc). Tools menu>>Database Utilities>>Split
database. Distribute the frontend, and keep the backend on a server share
all users have full rights to.
 
The simplest way is to link tables. On the computer where the database
resides, share the directory that cointains the database file. On the linking
computer, map the shared directory to a specific drive letter. If you intend
to have multiple computers used for data entry then choose a drive letter
that is not typically used and map the directory to the same drive letter on
each computer.

In Access under the File menu option, choose Get External Data/Link Tables.
You will then have to select the database file. Follow the wizard from there.
After that it is the ssame as if all tables were local.
 
Drive letter = potential problems should the user delete the mapping. Better
to link via network places, so that the link is a full UNC
(\\Server\Share\databse.mdb)
 
Back
Top