PDA

Click to See Complete Forum and Search --> : Help Newbie


abhisheksharma
Mar 5th, 2001, 06:14 AM
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
Mar 5th, 2001, 10:49 AM
?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!!