Printable View
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 OLEDB:Database password=admin "
can u help me how to make this package multiuser. its most urgent
thanx in advance
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.
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.Quote:
Originally Posted by kishorepv
Then use \\servername\folder\folder\whatever in your connect string.
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?Quote:
Originally Posted by kishorepv
(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?
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.
You could just select a computer which will serve as your 'server'.