Chris Seymour
|
| Posted: 05/07/2002, 12:56 PM |
|
Hi All,
I have created a site and published it to my hosting company server. I
have had to make some changes to the database (Access 2000) to add some
additional tables. Now when I try to enter data I get the following error:
Operation must use an updateable query. (Microsoft JET Database Engine)
The database has the same name as the previous version.
Do I need to do anything to the existing ASP and HTML files that were on
the server prior to the new tables being added?
Any thoughts/suggestions would be greatly appreciated.
Thanks.
|
|
|
 |
Barry G. Sumpter
|
| Posted: 05/07/2002, 2:12 PM |
|
Hi Chris,
I've just ran into a similar problem using a MSAccess DB.
I develop on my local HD.
But Publish my ASP to the server.
When I test the ASP - the server files get fired.
But when I make MSAccess DB changes I forget to copy the local HD
database
CHANGES to the server DB.
Hince, the ASP can't find the changes in the server DB.
Note: Please be sure to make the CHANGES to the server DB properly and
DO NOT copy the
entire database to the server. (Yes, I admit it. This one got me.
Only once though.
And only on my
develoment PC at home. Whew!)
Anyway,
I hope this helped someone.
baz
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:9207ABE02cseymourseywarecom@66.180.229.147...
> Hi All,
> I have created a site and published it to my hosting company server. I
> have had to make some changes to the database (Access 2000) to add some
> additional tables. Now when I try to enter data I get the following
error:
>
> Operation must use an updateable query. (Microsoft JET Database Engine)
>
> The database has the same name as the previous version.
>
> Do I need to do anything to the existing ASP and HTML files that were on
> the server prior to the new tables being added?
>
> Any thoughts/suggestions would be greatly appreciated.
>
> Thanks.
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/08/2002, 1:27 AM |
|
Refer to
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
--
Alex
CodeCharge Developer
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:9207ABE02cseymourseywarecom@66.180.229.147...
> Hi All,
> I have created a site and published it to my hosting company server. I
> have had to make some changes to the database (Access 2000) to add some
> additional tables. Now when I try to enter data I get the following
error:
>
> Operation must use an updateable query. (Microsoft JET Database Engine)
>
> The database has the same name as the previous version.
>
> Do I need to do anything to the existing ASP and HTML files that were on
> the server prior to the new tables being added?
>
> Any thoughts/suggestions would be greatly appreciated.
>
> Thanks.
>
|
|
|
|
|
