I recently started working as a technician in a library computer lab. A previous tech configured an Access database for staff to submit computer issues via a Web form.
About a week ago, the Web form stopped working. When I walked through the process of submitting a problem, I encountered the 80040e09 error after pressing the “Submit Problem” button, which leads to a file named “AddIssue.asp”. The error occurs in Line 14 of this file, which is “rsAddTicket.AddNew”.
Minus the hour or so I’ve spent on this problem so far, I have zero experience configuring/troubleshooting Access databases and corresponding Web forms. Brief research has pointed to a permissions issue, but I get the error even when running the form from a local Administrator account (which has full control over the database directory).
Might anyone suggest the next logical troubleshooting step(s)? I feel like this is a simple issue, I just don’t have the simple answer 😀
Many thanks,
Ron M.