ASP locking database

[mcconmw]

I am a complete newbie to ASP and developing in general trying to accomplish something that I thought would be relatively easy with Access 2000 but is turning into a massive headache.

Requirements:
Create a database that can be easily updated and have the data dynamically displayed on the intranet.

Attempt:
I have created a sample database and a query to sort the data. I created a DSN to the database in ODBC. I exported the query as a .asp from Access. When I opened my first window everything displayed fine. When I tried to open a second window I recieved ODBC errors and when I tried to open the database with Access I could only get read access. Even after closing the browsers it took 10 minutes or so before I could access the database with Access. I changed "rs.Open sql, conn, 3, 3" to "rs.Open sql, conn, 3, 1" (quotes aren't on page) and was then able to connect with multiple browsers, but I still can't use Access to update the data.

Questions:
What am I missing? Is this the wrong approach to be taking to meet my requirements?

Thanks in advance.

 

[ToddWW]

Here you go..

thread333-151169

ToddWW

 

[ToddWW]

Whoops, sorry about that. I was trying to reply to the post about Excel worksheets.

ToddWW

 

[gmagerr]

Try this, go to the system DSN you created and highlight it. Click the configure button, next click the advanced button. Now in the options box, scroll down till you see PageTimeout. It's set to 5 by default, change it to 5000 and see if that helps.

 

[mcconmw]

I changed some settings relating to the ODBC timeouts in the Advanced Options in the Access database and now it works. I don't really know what the true fix is though because when I set all of the settings back to their defaults it still worked. Thanks, though.