Inline.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
FrontPage Resources:
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
if i understand this correctly, when i use frontpage 2003 database
interface
wizard to create a database, the wizard creates the database with 2
fields,
name and key that are reserved in access
KA: Yes
and this is why the wizard cannot
finish the connection process.
KA: Well, I'm not sure that is the reason why - I just tried it and it
worked for me. I even created a new search page and used the "name" field
as
the search field and it worked.
if this is true, then why doesn't fp2003 know
these words are reserved and not use them when creating the database
connection.
KA: That's an excellent question. I did notice that the wizard gives you
the
opportunity to modify the field names.
when i clicked the link provided, igot a http 404 error.
That happens occasionally when you are using the web interface to access
these newsgroups - try this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
:
Name and key are both reserved words in Access 2002 and in later
versions
of
Access
tp://support.microsoft.com/default.aspx?scid=kb;en-us;286335 -
you need to change them to something else.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
FrontPage Resources:
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
on my pc at home. i have a website created in fp2003 that i want to
add
a
database to. after adding the database, i would want to publish it
to
live
website at my hosting company.
:
Are you doing this on your PC or on your live site?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources:
http://www.spiderwebwoman.com/xweb/
FrontPage Resources:
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
this is the procedure i followed:
file -> new -> database interface wizard
add to current site -> OK
ASP is selected -> Create a new microsoft access database within
your
website ->NEXT
enter a name for your database connection -> Database1 -> NEXT
this brings up a window with 4 fields, key, name, address,
choice ->
NEXT
some processing happens and a screen appears that says :
Press enter or Click NEXT to continue, I click NEXT
i immediately get the following error:
--------------------------------------------------------------------------------------------------------------------
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/database1.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 cannot finish the database connection wizard process. the
window
closes
i hope this helps
thanks
:
See
http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-800a0e78-errors.html
What is your strSQL calling for
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| hi all,
| using the fp2003 database wizard, i am trying to create a new
database
| connection. i reach a point where i get the following error
and i
need
to
| know what i am doing wrong or what i need to do to correct
this.
the
error is
| :
|
| 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/delivery.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)
|
| any help greatly appreciated
|
|