Help Newbie

[abhisheksharma]

HI all


1.How do I access a SQL database on the server from a node and work on it ?

2.How do i lock the database if someone is using it and another user want an access to it ?



Thanks

[sebs]

?1:
just set your connection like this:

set conn = server.createobject("ADODB.Connection")
conn.open "w:\blablabla\yourDB.mdb"


?2:

to lock you database you can use a text file:

when someone want to access your DB, look in
your .txt file, if if no one is using your DB, then put in
your text file that your DB is use,(in your .txt, it could be
something like :lock=true or lock=false)
and when your user is finish with your DB, unLock it
in your text file!!


hope it helps!!