I have two access databasea one for online, one for offline. Online

database responds to requests from Internet with ASP via ADO. Offline

database is being updated and copied onto the online one after changes are

completed.



My problem is that when a connection is established to online database i

can NOT copy(overwrite) my offline database to my online database because

there is still a connection from internet and the .ldb file of the

corresponding database file is seen. I would like to copy it wihout any

problem.



I used ASP such as:

Should we need to open database with some kind of cursor or lock type in

order to prevent the copy failure when offline database is being copied

(overwrite) to online database?



<%

Set rs = Server.CreateObject("ADODB.Recordset")

strConn = "Driver={Microsoft Access Driver (*.mdb)};

DBQ=c:\MyDatabase.mdb"

SQL = "Select * from MyTable"

 rs.open SQL, strConn

.....

rs.close

Set rs = Nothing

%>

Thanks