MS Access

[legnaimy]

Hi everyone

I design a page where users can submit information, (user name, e-mail,
comments, address), in a Microsoft Access Data Base located in my remote
server; and after get that information in my MS Access file located in my
computer...

This is my connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Inetpub\wwwroot\prueva\yourdatabase.mdb; "

This is the error everytime I upload my page: /prueva/TMP7vwlkdpskd.asp

Do you know what this error means???

Thanks

[BillB]

Looks like your trying to use a page that DW generated on your local machine
for preview purposes. Try using the page you created to do the upload.

Bill

[WayneMooresville]

I can't seem to update a "yes/no" field within an Access table. No matter what
value I assign it fails to update the table. What should I do? All other data
types seem to work.

Code below:
================================================== ==================
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery datasource="HDRUsers">
INSERT INTO Members (General)
VALUES (
<cfif IsDefined("FORM.General")>
Yes
<cfelse>
No
</cfif>
)
</cfquery>
<cflocation url="index.cfm">
</cfif>
================================================== ==================

[MikerRoo]

Use the attached query -- it has reserved words escaped.

"General" is a reserved word and should not be used as a column name.
Rename the column to something like "IsGeneral" -- use something that
describes the actual purpose of the column.



<CFQUERY datasource="HDRUsers">
INSERT INTO
Members
(
[General]
)
VALUES
(
<CFQUERYPARAM cfsqltype="CF_SQL_BIT" value=#IsDefined
("FORM.General")#>
)
</CFQUERY>