access03/frontpage03

[alexa]

without sharepoint or .asp on server, how can I make a 'name' search with mdb
on a webpage?

 

[Ronx]

Access databases will only run on Windows operating systems. Web
Servers running on Windows normally have ASP built in (Apache for
Windows is a possible exception).
If you cannot use .asp or asp.net, then you must use Perl/cgi or PHP
to interrogate the database - and .mdb (Access) databases must be on
Windows server.

 

[alexa]

ok. I'm operating on a windows server, that DOES allow asp. I just don't know
how to make a search function with mdb so that visitors can search for others
by 'name' and get a return of everyone with that name displayed for them. can
you explain? really appreciate the help...
alexa

 

[Ronx]

The easiest way:

Open a web in FrontPage
Use File->Import to bring the database into the web, allow FP to move
it to the fpdb folder.
Open a page.
Insert->Database->Results
and follow the wizard.
Instructions are in the Help files - search for Database Results
Wizard.

 

[alexa]

I'll try. just bought access book. kinda surprised nothing came with the
software. I've got the db in fpdb but when the wizard showed up, I was unable
to completel for some reason. and....does the db file have to end in mdb or
asp or does the webpage have to change to asp or can it remain html and the
db mdb? sorry. really confused with this program. thx for so much direction.

 

[Ronx]

The database must end in .mdb extension - do not change it from the
way Access left it. The page must be .asp.
What errors arise when you try to complete the wizard?

 

[alexa]

ARRGGGGHHHHH!!!!!
ok. I've imported the database, again. it said it should go to fpdb, I was
thrilled.
now, no matter how I open things, the 'database' is no available as an
option. ie: go to insert, database, ....nope. database is faded. I've opened
the directory html page, I've opened a brand new page, I've tried with just
fpdb to insert. nope.
and...you say it has to be a page .asp. do I create a page named that or
will it become that due to the database (in the event I ever get the thing
into the page)
youknow, I'm a good cook. my husband is really interesting. why don't you
just amble over, have dinner, drinks and FIX MY WEBPAGE!!!!! sorry. had
to vent.
thx
ac

 

[alexa]

updated on note of earlier today.
oddly, if I work on the site in my computer, as opposed to the server side,
I get the wizard dialogue. hmmmm..... the server supports asp, mdb and does
not have sharepoint, so I figure I should be fine. also, when I finally DID
get to meet mr wizard, I didn't know which option about my database to
select. info? offer for dinner still on. beautiful country out here...

 

[Ronx]

To use the Insert->Database function you must have a web open, and a
page open to insert the Database Results into. When you save the page
you may be reminded to change the extension to .asp.

In the Wizard, choose ASP, then choose an existing database
connection. The "existing database connection" is the default unless
that connection does not exist[1].

On the next pages of the wizard you choose the table in the database,
and build the search query. The wizard will also build a search form
for you, if you wish.

Record Source is the table to be queried.
On the third page choose More Options button to set up criteria for
the search.
The remaining pages of the wizard deal with results layout, and are
fairly self explananatory.

[1] If there is no Database Connection to choose from, close the
Wizard, then use Tools->Site Settings - Database Tab, and check that a
database connection is listed, and use Verify to establish the
connection. If there is none listed, use the Add button to create a
new connection, and browse to your database. Then go back to the
Wizard.

 

[alexa]

ok. I'm actually making progress. I've imported, it's in fpdb, I've used the
wizard to create a search form and incorporate the mdb. I've decided which
fields to include. then, I get a page that loads, saying Database Results
Wizard Error
The operation failed. If this continues, please contact your server
administrator.
my server is windows based, asp included. I don't know if it's on my side or
theirs. they don't offer assistance with coding. I swear, this just
shouldn't be so hard. my page is page.asp, for testing. if you wanna look, it
eara.org/page.asp.
I'm soooooo over my head.
ac

To use the Insert->Database function you must have a web open, and a
page open to insert the Database Results into. When you save the page
you may be reminded to change the extension to .asp.

In the Wizard, choose ASP, then choose an existing database
connection. The "existing database connection" is the default unless
that connection does not exist[1].

On the next pages of the wizard you choose the table in the database,
and build the search query. The wizard will also build a search form
for you, if you wish.

Record Source is the table to be queried.
On the third page choose More Options button to set up criteria for
the search.
The remaining pages of the wizard deal with results layout, and are
fairly self explananatory.

[1] If there is no Database Connection to choose from, close the
Wizard, then use Tools->Site Settings - Database Tab, and check that a
database connection is listed, and use Verify to establish the
connection. If there is none listed, use the Add button to create a
new connection, and browse to your database. Then go back to the
Wizard.
--
Ron Symonds
Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

updated on note of earlier today.
oddly, if I work on the site in my computer, as opposed to the
server side,
I get the wizard dialogue. hmmmm..... the server supports asp, mdb
and does
not have sharepoint, so I figure I should be fine. also, when I
finally DID
get to meet mr wizard, I didn't know which option about my database
to
select. info? offer for dinner still on. beautiful country out
here...