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

May 10, 2008 by Georgi Kralev

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.