access data base on LAN / WAN ?

[balu]

Can any one please give one idea/ fundamental need of knowledge / material
..as im trying to place my access - 03 data base on one computer( remote
place) and update / retrive data from many computers ,how to design such data
base for many users please.
your help will change the way of my working with access
thank u

 

[Daniel Pineault]

The most important thing you can do when ever you setup an access db to run
over a lan is to split your db an issuing a copy of the front-end to each
user.

You can get some more information at
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm -Splitting
your db
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html - WANs

You may also want to consider implementing User-Level Security (USL), in
that case read
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[balu]

thank u very much your is working to the extent .
but kindly advise one more thing
i would like to open the front end mdb file with vb
i used it in 3 ways inVB
(1) access application.opencurrentdatabase("database + path,true,password)
but failes the error is " the database does not exist or opened
exclusively by other user"
(2) i used DAO open database method
error is database does not exist and or MDW not found and ofcource
there no way to insert the password and path of my database
(3) i used shell function and syscmd to open my data base but no scope for
using the password of my data base error is " database.mdb does not exist"
how to open my data base using vb6
kindly advise