FP Extentions and JET Database

[bruce]

Frontpage extension automatically tighten permission on your file system during installation.

You will need to import the database file using FrontPage client to the server. When you do that, FP will mark that directory with Change permission.

Hope this helps


[b]quote:Originally posted by homeacademy

I am having difficulty using Frontpage extentions and making database calls.

A little background:
I just installed Frontpage extentions on my discountASP.NET account in order to upload via VB.NET. The installation was successful, and I am able to upload through VB.Net.

I also host a Snitz forum and a couple of other classic ASP applications that make database calls. I had them working fine until I installed Frontpage. As soon as Frontpage Extentions were instlled, the applications will no longer run. I just get the following error:

[quote]MicrosoftJETDatabaseEngineerror'80004005'

Operationmustuseanupdateablequery.

/../inc_sitestat.asp,line141</CODE>
A similar "Operation must use an updatable query." message is given for all of my applications which make database calls. The ones that do not call a database run fine. In the example above, line 141 is:

[quote]setrs=my_conn.execute(InsertSql,adOpenStatic,adCmd Txt)</CODE>
Is there something I need to change to allow database calls while continuing to use Frontpage? Note that I am using an Access database. Thanks in advance for any help.
</blockquote id="quote"></font id="quote">

[homeacademy]

I am having difficulty using Frontpage extentions and making database calls.

A little background:
I just installed Frontpage extentions on my discountASP.NET account in order to upload via VB.NET. The installation was successful, and I am able to upload through VB.Net.

I also host a Snitz forum and a couple of other classic ASP applications that make database calls. I had them working fine until I installed Frontpage. As soon as Frontpage Extentions were instlled, the applications will no longer run. I just get the following error:

[quote]MicrosoftJETDatabaseEngineerror'80004005'

Operationmustuseanupdateablequery.

/../inc_sitestat.asp,line141</CODE>
A similar "Operation must use an updatable query." message is given for all of my applications which make database calls. The ones that do not call a database run fine. In the example above, line 141 is:

[quote]setrs=my_conn.execute(InsertSql,adOpenStatic,adCmd Txt)</CODE>
Is there something I need to change to allow database calls while continuing to use Frontpage? Note that I am using an Access database. Thanks in advance for any help.

[homeacademy]

Following your suggestion, I have everything working properly. Many thanks for the prompt replies. I appreciate the assistance.