Insert record behaviour problem (ASP)

[Guest]

The website is comming along fine but I need to use a behaviour that will insert a record into my access database when a client completes a questionnaire.

The Insert record wiizard is easy to use but when I try and test it I get an error that states I need to use an amendable query.

A What?

Any help will be gratefully received.

[bregent]

Probably a permission probelm. Please post the complete error message.

[Guest]

Not sure about permissions. This is only on my localhost and I am the administrator.

Full error message.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

---

Technical Information (for support personnel)

• Error Type:
  Microsoft JET Database Engine (0x80004005)
  Could not use ''; file already in use.
  /wmkweb/AccForm.asp, line 31
  
• Browser Type:
  Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
• Page:
  POST 257 bytes to /wmkweb/AccForm.asp

Any ideas?

[bregent]

File in use errors usually mean just that; the access file is already in use and you are not able to obtain an exclusive lock. Do you have Access or another application that may have a lock on the file open?

[Guest]

Sorry about the error message. This is my usual problem Dreamweaver does

not always close connections to the database. I can handle that.

The error message I was actually referring to is attached.

Any ideas?

[Personal information deleted by moderator]

[Guest]

Had issues trying to access the forum. Could only send an email the error is as follows: