Nathaniel Harris
|
| Posted: 06/11/2002, 1:42 PM |
|
Hi,
Using CCS version: 1.0.6.0
Newbie here.
I have created an application using the "Application Builder", no
additional code added after all the pages are created.
I can update/add records to the database within CCS Live with no problem.
However, when I publish the site to the web and attempt to add or update a
record I get the following message.
Source: Record productCatalog / Insert Operation
Command Text: INSERT INTO [productCatalog]([categoryFull], [subCategory],
[itemName], [itemDesc], [itemMisc], [itemPrice], [itemPicture]) VALUES
('Testing Category', 'Testing SubCategory', 'Testing Name', ?, 'Testing
misc', 111, Null)
Error description: Operation must use an updateable query. (Microsoft JET
Database Engine)
INSERT INTO [productCatalog]([categoryFull], [subCategory], [itemName],
[itemDesc], [itemMisc], [itemPrice], [itemPicture]) VALUES ('Testing
Category', 'Testing SubCategory', 'Testing Name', ?, 'Testing misc', 111,
Null)
Can someone give me a clue as to why it works within CCS and not when I
publishe it to the internet (published using Frontpage 2002).
Thanks,
Nat
|
|
|
 |
Frank Rocco
|
| Posted: 06/11/2002, 1:50 PM |
|
Check Database/Tabe security on website.
HTH
Frank
|
|
|
|
Nathaniel Harris
|
| Posted: 06/11/2002, 2:35 PM |
|
Frank,
I really appreciate your quick response and willingness to help a new guy.
As additional information, I can add/update the table on my pc (running pws)
with no problem. It seems I only receive the error when I attempt to update
/ add a record after i publish the site to my hosting service.
I checked the permission on the folder (where the database is stored) and
did find that it was not set to run scripts or browse and I set there
permissions. I also copied the database from my pc to the website to ensure
that they are the same. This did not resolve my problem.
Other than this can you be more specific on what I need to check.
Thanks much,
Nat
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:ae5nr8$oqe$1@news.codecharge.com...
> Check Database/Tabe security on website.
>
> HTH
>
> Frank
>
>
|
|
|
|
Nathaniel Harris
|
| Posted: 06/11/2002, 4:11 PM |
|
Please disregard this post. I discovered that the problem was permission
related for the access database.
Thanks,
Nat
"Nathaniel Harris" <nharris@bellsouth.net> wrote in message
news:ae5qfm$u20$1@news.codecharge.com...
> Frank,
>
> I really appreciate your quick response and willingness to help a new guy.
>
> As additional information, I can add/update the table on my pc (running
pws)
> with no problem. It seems I only receive the error when I attempt to
update
> / add a record after i publish the site to my hosting service.
>
> I checked the permission on the folder (where the database is stored) and
> did find that it was not set to run scripts or browse and I set there
> permissions. I also copied the database from my pc to the website to
ensure
> that they are the same. This did not resolve my problem.
>
> Other than this can you be more specific on what I need to check.
>
> Thanks much,
> Nat
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:ae5nr8$oqe$1@news.codecharge.com...
> > Check Database/Tabe security on website.
> >
> > HTH
> >
> > Frank
> >
> >
>
>
|
|
|
|
|
