hello,

When i run my aspx file(performs database insert record operation), theere
is another file generated name "access.lockFile.9" and its not getting
deleted. Its mdb file's related file.

Why is this file generated? I am getting error running this page.

my code is ...

qry="insert into users(userid,username) values('" & txtUID.text & "','" &
txtUName.text & "')"

dbcommand=new oledbcommand(qry,conn)
dbcommand.connection.open()
dbcommand.executeNonQuery()
dbcommand.connection.close()
bindDataGrid()

Whats the problem in this code? Error : Operation must be an updatable query

I checked the attributes for mdb file and folder. All are ok(no read only
attribute).

Rajani,

Microsoft Access creates the lock file to fetch exclusive locks for a
particular record on a table. This file should get deleted
automatically. Please check the permissions for the impersonating user
so that the file can be deleted automatically. "access.lockFile.9" is
for Access 2000.

Thanks and Regards,
Daniel

Rajani wrote: