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.

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jed" <(E-Mail Removed)> wrote in message
news:5605B8FE-77F2-42BA-A42E-(E-Mail Removed)...
>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.
>

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" wrote:

> 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)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jed" <(E-Mail Removed)> wrote in message
> news:5605B8FE-77F2-42BA-A42E-(E-Mail Removed)...
> >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.
> >
>
>
>

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jed" <(E-Mail Removed)> wrote in message
news:8990CBF6-5B85-4CDC-B943-(E-Mail Removed)...
> 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" wrote:
>
>> 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)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Jed" <(E-Mail Removed)> wrote in message
>> news:5605B8FE-77F2-42BA-A42E-(E-Mail Removed)...
>> >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.
>> >
>>
>>
>>

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" wrote:

> 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)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jed" <(E-Mail Removed)> wrote in message
> news:8990CBF6-5B85-4CDC-B943-(E-Mail Removed)...
> > 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" wrote:
> >
> >> 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)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Jed" <(E-Mail Removed)> wrote in message
> >> news:5605B8FE-77F2-42BA-A42E-(E-Mail Removed)...
> >> >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.
> >> >
> >>
> >>
> >>
>
>
>

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jed" <(E-Mail Removed)> wrote in message
news:95B63CFA-04A3-4594-943B-(E-Mail Removed)...
>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" wrote:
>
>> 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)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Jed" <(E-Mail Removed)> wrote in message
>> news:8990CBF6-5B85-4CDC-B943-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >> 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)
>> >> http://www.ycoln-resources.com
>> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> ==============================================
>> >> To assist you in getting the best answers for FrontPage support see:
>> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >>
>> >> "Jed" <(E-Mail Removed)> wrote in message
>> >> news:5605B8FE-77F2-42BA-A42E-(E-Mail Removed)...
>> >> >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.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Thanks for your help.

"Thomas A. Rowe" wrote:

> 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)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jed" <(E-Mail Removed)> wrote in message
> news:95B63CFA-04A3-4594-943B-(E-Mail Removed)...
> >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" wrote:
> >
> >> 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)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Jed" <(E-Mail Removed)> wrote in message
> >> news:8990CBF6-5B85-4CDC-B943-(E-Mail Removed)...
> >> > 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" wrote:
> >> >
> >> >> 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)
> >> >> http://www.ycoln-resources.com
> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> >> ==============================================
> >> >> To assist you in getting the best answers for FrontPage support see:
> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >> >>
> >> >> "Jed" <(E-Mail Removed)> wrote in message
> >> >> news:5605B8FE-77F2-42BA-A42E-(E-Mail Removed)...
> >> >> >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.
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>