|
|
MS Access
Started by slynn at 09-18-2005 12:53 PM. Topic has 2 replies.
  
|
|
Sort Posts:
|
|
|
|
 09-18-2005, 12:53 PM
|
slynn
Joined on 09-19-2005
Posts 1
|
Using MS Access Dbase to Post Form Data
|
|
|
|
|
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 :-)
|
|
|
|
|
Report
|
|
|
|
|
12-19-2005, 1:35 PM
|
advantage
Joined on 12-20-2005
Posts 2
|
Re: Using MS Access Dbase to Post Form Data
|
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
03-24-2006, 8:29 PM
|
hotwebideas
Joined on 03-25-2006
Posts 6
|
Re: Using MS Access Dbase to Post Form Data
|
|
|
|
|
|
Have you tried uploading a new version of your .MDB file?
|
|
|
|
|
Report
|
|
|
|
|
Webhost4life Fo... » Database Relate... » MS Access » Using MS Access Dbase to Post Form Data
|
|
|
|