Network portion of Access

[nominator]

Hi, i wanan do something like, i have 2 .mdb file, 1 of it is the tables only, and the other .mdb is the form.

i wanna upload the table mdb to my server where it will store records. When i open form mdb from my PC, it will make a connection to the table mdb which is stored in my server. when ever i add a record using the form, the data is stored to the server mdb

is this possible? can some1 show me example of how to do it?

[XLGibbs]

Why not have the form in the same file as the tables? would resolve numerous issues with having to link the tables.....

adding a record to linked tables would require good use of ADODB or DAO VB code to modify the recordset. Far simpler to build one and put it out there on the server.

[geekgirlau]

I may not be understanding the question correctly, but you can have your tables on the server, and have your front-end db (with all the forms, queries, etc.) stored locally, with a link to the tables on the server. If the forms are bound, the server data will be updated automatically as you change, add and delete records in the form.