how do I open a connection read only

[bookouri]

I have an access database on our web page now. The pages are all simple asp pages that only retrieve data, readonly, no updates etc...

I found that if I am working on the database, adding records, etc. the asp pages report that the database is unavailable, locked etc. Can I open the recordsets readonly in my asp code and avoid this error?

thanks