Trying to build a report in Frontpage

[Joslin]

Help me please!!! I'm trying to create a report in
Frontpage connected to a database I built in Access. I
tried doing the insert>database>report, but it won't let
me connect to the table I need to use. I can connect to
the four other tables I have in the database. Here is the
error messege I get:

Server error: Unable to retrieve schema information from
the record source 'Order' in a database using the
connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/CSC52001.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending
on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in
FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


Can anyone tell me what I'm doing wrong please?

 

[Kathleen Anderson [MVP - FP]]

This message: "Syntax error in FROM clause" normally means there's something
wrong with your query - can you post the SQL?

 

[Guest]

I wasn't using the custom query option. I selected record
source.

-----Original Message-----
This message: "Syntax error in FROM clause" normally means there's something
wrong with your query - can you post the SQL?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Help me please!!! I'm trying to create a report in
Frontpage connected to a database I built in Access. I
tried doing the insert>database>report, but it won't let
me connect to the table I need to use. I can connect to
the four other tables I have in the database. Here is the
error messege I get:

Server error: Unable to retrieve schema information from
the record source 'Order' in a database using the
connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/CSC52001.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending
on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in
FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


Can anyone tell me what I'm doing wrong please?

.

 

[Kathleen Anderson \(MVP - FrontPage\)]

Unless you selected a View from your Access Database as your record source,
you still have a query (SQL) in your page. What does it look like?


--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

I wasn't using the custom query option. I selected record
source.

-----Original Message-----
This message: "Syntax error in FROM clause" normally means there's
something wrong with your query - can you post the SQL?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Help me please!!! I'm trying to create a report in
Frontpage connected to a database I built in Access. I
tried doing the insert>database>report, but it won't let
me connect to the table I need to use. I can connect to
the four other tables I have in the database. Here is the
error messege I get:

Server error: Unable to retrieve schema information from
the record source 'Order' in a database using the
connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/CSC52001.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending
on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in
FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


Can anyone tell me what I'm doing wrong please?

.

 

[Guest]

Basically just SELECT * FROM Order

-----Original Message-----
Unless you selected a View from your Access Database as your record source,
you still have a query (SQL) in your page. What does it look like?


--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

I wasn't using the custom query option. I selected record
source.

-----Original Message-----
This message: "Syntax error in FROM clause" normally means there's
something wrong with your query - can you post the SQL?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Help me please!!! I'm trying to create a report in
Frontpage connected to a database I built in Access. I
tried doing the insert>database>report, but it won't let
me connect to the table I need to use. I can connect to
the four other tables I have in the database. Here is the
error messege I get:

Server error: Unable to retrieve schema information from
the record source 'Order' in a database using the
connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/CSC52001.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending
on how the driver is configured.
------------------------------------------------------ -
[Microsoft][ODBC Microsoft Access Driver] Syntax error in
FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


Can anyone tell me what I'm doing wrong please?


.

.