Skip to main content
A
Anonymous
September 11, 2009
Question

Insert record behaviour problem (ASP)

  • September 11, 2009
  • 1 reply
  • 756 views

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.

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
September 11, 2009

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

A
Anonymous
September 11, 2009

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?

A
Anonymous
September 14, 2009

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?


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]

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices