Database Results Wizard Error Message

[Jed]

I am working with an Access Database file that was created with SQL and when
I use the database results wizard in FP I am getting this error message when
the wizard tries to locate the record source(table) to reference.


Server error: Unable to retrieve the list of record sources from a database
using the connection string:

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/WebVote.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.

-------------------------------------------------------

Source: ADO

Number: -2146824584 (0x800a0e78)

I checked the # of the message, and it says "the operation requested is not
allowed if the object is closed". Does this mean that the Access file was
not created properly in SQL or what?

The file itself is not corrupt and I can open the file and the data is
intact. I access all kinds of other databases on my website without any
problems, but this is the only one that was created via SQL. Is there a
certain procedure or bit of coding that is different when dealing with SQL
created Access files? Any help would be greatly appreciated.

 

[Thomas A. Rowe]

Need to see your SQL statement, because it appears that you have either not open the database/table
or you have closed the database/table prior to running this query.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Jed]

The access file was given to me by our programmer, so I don't have the SQL
statement that was used to create the access file I am working with. I am
using a form to query this access file, but I can't even get the results
wizard to go past step 2 due to this error message. I am wondering if the
access file is looking for the SQL connection still and maybe that is the
problem. I'm just trying to troubleshoot all of my loose ends before I go
back to my programmer and say he needs to fix his file.

 

[Thomas A. Rowe]

No, not the SQL statement used to create the file, the SQL statement that you are using to query the
database when you get this error.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Jed]

I have been trying to connect to this Access file on the web server just like
I would any other access file with ASP pages. I am not actually writing a
SQL statement to query the file. After I create a new connection to the .mdb
file and hit next is when I encounter the error. The funny thing is I
exported that table to a new Access file that I created in Access and created
a connection like I always had and everything checked out fine. I can use
this work around, but it has been driving me crazy and I don't want to this
every time unless I have too. Thanks

 

[Thomas A. Rowe]

Then the issue is with the query that is creating the original Access database, make sure it is in
Access 2000 format.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Jed]

Thanks for your help.

Then the issue is with the query that is creating the original Access database, make sure it is in
Access 2000 format.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================