Re: Database Results Wizard Error Message
From: Thomas A. Rowe (tarowe_at_mvps.org)
Date: 02/01/05
- Next message: Thomas A. Rowe: "Re: trouble with FPSE and sending form data via email"
- Previous message: Jed: "Re: Database Results Wizard Error Message"
- In reply to: Jed: "Re: Database Results Wizard Error Message"
- Next in thread: Jed: "Re: Database Results Wizard Error Message"
- Reply: Jed: "Re: Database Results Wizard Error Message"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Feb 2005 16:20:55 -0500
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" <Jed@discussions.microsoft.com> wrote in message news:95B63CFA-04A3-4594-943B-1DD066DF7C9A@microsoft.com... >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" <Jed@discussions.microsoft.com> wrote in message >> news:8990CBF6-5B85-4CDC-B943-7BBA7C439436@microsoft.com... >> > 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" <Jed@discussions.microsoft.com> wrote in message >> >> news:5605B8FE-77F2-42BA-A42E-B158D42C02CA@microsoft.com... >> >> >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. >> >> > >> >> >> >> >> >> >> >> >>
- Next message: Thomas A. Rowe: "Re: trouble with FPSE and sending form data via email"
- Previous message: Jed: "Re: Database Results Wizard Error Message"
- In reply to: Jed: "Re: Database Results Wizard Error Message"
- Next in thread: Jed: "Re: Database Results Wizard Error Message"
- Reply: Jed: "Re: Database Results Wizard Error Message"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
