Thanks for your inputs!!
I need to create a client server application where the user has a front end and a common database is stored in a shared drive.
Could please tell me what are the steps to create a client server application
Thanks,
Yogesh
You need a mapped drive and folder on the server, that is the same on every PC. For example, I use Z:\Bissau
Assuming your database is called mydb.mdb, copy it onto the server and rename it mydbdata.mdb. Put another copy on the server, call it mydbcode.mdb. Now on mydbdata and delete all querys, forms, reports, macros and modules, i.e. just leave the tables.
Now go into mydbcode and delete all the tables. Then go into the File menu option, Import, and select Link Tables. You are presented with a browse button, select mydbdata and select all tables.
You now have a code db that you can copy onto each of your pcs, which links to the data db on the server. Each PC must map to Z:\bissau (or your own folder and drive)
The code db can go anywhere, but the data db must stay in the drive and folder you used to link it with, on all PCs
oh yes, I forgot, take a backup before you start this, just in case