Thread: Insert Issue revisited
View Single Post
  #12 (permalink)  
Old June 20th, 2005, 05:30 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 33,554, Level: 80
Points: 33,554, Level: 80 Points: 33,554, Level: 80 Points: 33,554, Level: 80
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 10,228
Thanks: 7
Thanked 203 Times in 201 Posts
Default
Yeah, it does support multiple concurrent connections. However, I think you'll run into problems when you have the database open for design in Access on your desktop / server. If, for example, you're changing the design of a table you get this error.

It could also be a permissions issue, where ASP cannot create the .ldb file. Check this FAQ for more information: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=263

However, I don't think this is the problem in your case as you can successfully insert and update records. I think you should just close Access on the server and everything will be fine....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Teardrop by Massive Attack (Track 3 from the album: Mezzanine) What's This?
Reply With Quote