ASP
I need some help. I built an ASp page to transfer data to an MsAccess DB. but when I want to save fields there is an error :
Server error: Unable to retrieve schema information from the record source 'ISAOP-Reg' in a database using the connection string:
'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=OpCong/Database/Op-Cong.mdb'.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
Thanks
Comments
Database Errors
Hi Reza,
Questions of this sort are usually asked at the Forums of Dmxzone. Not at Request a Tutorial section.
About your problem, this error could be due to lack of appropriate permissions.
Make sure that the account IUSR_<your machine name> has write permissions at your access database file.
Also make sure that your connection string and SQL statements are correct.
Regards,
You must me logged in to write a comment.