Chris Seymour
|
| Posted: 04/11/2002, 3:46 PM |
|
Hi All,
I have a form that is capturing a user's name and e-mail (2 fields on a form). I am using ASP & Templates. When the users clicks Submit (Insert), the following error appears: Operation must use an updateable query. (Microsoft JET Database Engine). This only appears on the remote server. When I run locally all is well. DB is Access.
Any thoughts?
Thanks.
|
|
|
 |
artoo
|
| Posted: 04/11/2002, 6:17 PM |
|
Hi Chris,
It could be that you are updating a view (as opposed to a single table) in the back-end. A view would consist of multiple tables join via primary and foreign keys. The DB engine normally does not have the ability to "break down" your posts so that the individual tables are properly updated.
Hope that helps.
|
|
|
|
Andrew B
|
| Posted: 04/11/2002, 7:30 PM |
|
Some things to consider :
1. Make sure the same version of MDAC is installed (from microsoft.com)
2. Make sure that your MDB is not write protected.
3. Check to see if you have a LDB file with your MDB. The errors are different, I think, but they may be reporting as the same thing.
If that fails, try giving iuse_machinename write access to the directory with the MDB in it.
HTH,
Andrew
|
|
|
|
Peter
|
| Posted: 04/11/2002, 7:52 PM |
|
Yes, most of us that use MSAccess have seen it. read the reply before this one. It just points to a (user) configuration error.
|
|
|
|
|
