Re: Using MS Access Dbase to Post Form Data

MS Access

Using MS Access Dbase to Post Form Data

---

slynn 09-18-2005, 12:53 PM
I have am having issues with a MS Acces database that I am using to capture form data.   When I test the dns connection, the connection is successful, but am unable to see the tables, so the data doesn't write to the dbase when submitted.  Permissions set on dbase include read/write/execute.  I shut down my firewall to test any potential security issues, but had no effect.  I have also rebuilt the connection string, deleted the _mmServerScripts folder from both local and server locations.  This process worked 3 months ago, but for some reason now no longer works.  I made no changes to these asp pages during this time so am a bit puzzled.  Any assistance would be appreciated.  I am sure it is something so simple that I am missing it :-)

Re: Using MS Access Dbase to Post Form Data

---

advantage 12-19-2005, 1:35 PM
Please consider switching to MySQL.  Access just isn't made for shared access or data serving. 

The most common problem is a persistant lock on the entire database, not just a table or field.  The cure to this is to execute an invalid sql statement which releases all locks - yeesh.  You can try that, but the problem will come back.

cm
www.bingoadvantage.com

Re: Using MS Access Dbase to Post Form Data

---

hotwebideas 03-24-2006, 8:29 PM
Have you tried uploading a new version of your .MDB file?