urgent need to connect db in lan please help

[arunkumarinfo]

hi,
how to access Ms Access database from client side .i setup my project as client-server communication.in client side i have java program and in server side i have ms Access database file .how to access the db from client program .please suggest me its urgent i did not use any servlets and all .just simple database access code in java

[sathishsengg]

I think, no server for MS Access!!.
You can do two Think..
1) Manually write code for server side to access the MS Access Database
2) You can link your access Database to SQL Server
Follow this link for second option.
http://www.aspfree.com/c/a/Microsoft...L-2005-Server/

[arunkumarinfo]

hai,thanks for your response ,i need some sample code to connect java with sql server2005 for LAN