Connecting my form to a database

[Lisa]

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

I have used the feature to connect FrontPage forms to a
MSAccess database several times, but with the form I am
currently working on, whenever I try to either create a
new database or connect to an existing one (that I
created manually), I get the error message below.

Can someone help me???
Thanks,
Lisa

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=_private/Registration04-05.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] The Microsoft
Jet database engine cannot find the input table or
query 'Registration04'. Make sure it exists and that its
name is spelled correctly.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005

 

[+FarmerPickles]

SOunds like it can't find the table in the DB.. not the DB itself maybe??

 

[Guest]

So any suggestions???
It shows up in the dialog box (db and table) but it won't
connect to it...
LC

-----Original Message-----
SOunds like it can't find the table in the DB.. not the DB itself maybe??

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

I have used the feature to connect FrontPage forms to a
MSAccess database several times, but with the form I am
currently working on, whenever I try to either create a
new database or connect to an existing one (that I
created manually), I get the error message below.

Can someone help me???
Thanks,
Lisa

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=_private/Registration04-05.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] The Microsoft
Jet database engine cannot find the input table or
query 'Registration04'. Make sure it exists and that its
name is spelled correctly.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005

.

 

[Kathleen Anderson [MVP - FP]]

If you created the database externally and imported it into your web, FP
should have offered to store it in a folder called fpdb - you should have
said "yes".