Shared DB access using DSN

[rameshmpai]

I have a LAN with a server and clients attached to it. I created a software which links to a MS ACCESS database through a System DSN named MyDSN on the server. Now I want to connect to this database from the client machines using the same dsn name MyDSN so that the database on the server remains shared to all the other clients. Please send me the code. I am using VB 6, MS Access, System DSN, LAN.

[Si_the_geek]

you need to create the DSN on the clients as it is on the server (except maybe the path to the database!) - you can't access the one on the server.

[rbrain]

If I create diff DSN's on the client then I can in no way share the DB on the server. THis also implies that I should keep different copies of the DB on each client. This is unfeasible.

[Si_the_geek]

what the ...???

you just create the same DSN, which is purely a link to the database - so you NEVER EVER copy the database itself.

as long as the clients have access to the database (if it is M$ Access just give them permission to read the directory it is in) you can create a DSN to it.

[rbrain]

Now I have got what u have said. I will try it out and tell u soon. THanks.