- Sep 30, 2001
- 12,684
- 2
- 81
INSERT INTO group_permissions VALUES((SELECT id FROM permissions WHERE ((permissions.permission) = 'edit_lvl1_concerns')),'DnsAdmins');
fails with error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error.
/testing/securityCenter.asp, line 10
The syntax is correct according to Access... and there are no reserved words in the query
Gotta love the nice description of the error message..
any ideas?
edit: When I run that query in Access it gives me error (-3025)... with the same description as above...