how to make package multiuser

[kishorepv]

hi everyone,

i've developed a package with backend as MS-Access. Its working well on individual system. But now i wan't to make it multiuser. The database connection i used is

provider=Microsoft.jet.OLEDB.4.0;persist security info=false;Data source=" & Path & "HMS.mdb;Jet OLEDBatabase password=admin "

can u help me how to make this package multiuser. its most urgent

thanx in advance

[Hack]

Step number one: Put the database on a network file server, and through your VB front end code, using the UNC path, connect to it.

Consideration number one: MS Access does not perform well in a multiuser environment.

[kishorepv]

hi hack,

thanx for ur reply.

but can u tell me how to place the database in server and the UNC path for it to access.

[Hack]

hi hack,

thanx for ur reply.

but can u tell me how to place the database in server and the UNC path for it to access.

Pick a spot on the server of your choice and copy it out there.

Then use \\servername\folder\folder\whatever in your connect string.

[kishorepv]

thanx hack,

but i'm not using any server. just i wan't to run the pckage in 3 systems at a time which are connected in a LAN.

so, can u tell me how to map the database in the remaining two systems.

[Hack]

thanx hack,

but i'm not using any server. just i wan't to run the pckage in 3 systems at a time which are connected in a LAN.

so, can u tell me how to map the database in the remaining two systems.

If you don't have a network server then how are you running a LAN?

(I'm not a network person...we have a whole department in my shop that handles stuff like that.)

Can you connect, physically, to the other two systems?

[randem]

kishorepv,

Even with all of that... If you did not write Multi-user code you are just asking for trouble with corruption and loss of data. This unfortunately is very common and most people blame the database... But that is not where the problem resides.

[dee-u]

You could just select a computer which will serve as your 'server'.