
November 24th, 2003, 09:36 AM
|
|
Registered User
|
|
Join Date: Nov 2003
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
asp and database configuration problem
hi all. i posted this in the asp forum but maybe you database experts will have more info for me (note: i am NOT a database guru)
am using asp and cdonts to send an html form to both an email address and a database (Access). have used this before but can't get this particular asp file to Execute the SQL. the database is on a different server (Intranet). The database is set up exactly how the one (that works) is on our external Web Server. I don't know if its a driver problem or an ASP problem but if someone can pinpoint it for me, i can either A) worry about my asp syntax or B) turn the matter over to my sys admin.
The error returned is:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be added; no insert permission on 'PBS'.
/pbs.asp, line 258
again, have checked permissions to the database table itself and everyone has read and write permissions.
any gueses? thanks!
|