finding records on a data access page

[Guest]

Hello:

This, I believe, is my last resort.

I have a database in 1 table only with an ID, NAME and LAST_NAME. There are
500.000 + records. Yes, it is huge.

I am trying to make a data access page so that my users can find a record
base on the ID only and to pull up the name and the last name, that is it! no
editing, or adding or deleting records.

I have been succesful into creating the data access page and adding the code

I have been using the code per MS in the following link:

http://office.microsoft.com/en-us/assistance/HA010345491033.aspx

The issue is that it works for certain numbers and other come up with an
error 301.

It does say in that link:

Note: When you create Visual Basic Scripting Edition (VBScript) blocks for
Microsoft Office Data Source Control (MSODSC) events, you must add a
parameter to the event name, as follows:

<SCRIPT LANGUAGE=vbscript FOR=MSODSC EVENT=Current(oEventInfo)>

However I do not know wehre to put the line of code since it's already using
a script and a script inside a script does not work either.

I have search the KB and also have searched the web without success, there
are other people with the same question in other fuorums as well and no
response.

If anybody has another way of doing it or know where this code should go I
am open for suggestions as I am fresh out of ideas.

Thank You

 

[S.Hoitinga]

you should place in the header of your html document.

Better

do not ever use access pages because you don't have control over the html
that is produced.
do not ever use frontpage, because frontpage produces html ot xml that you
won't understand.

use

dreamweaver and cold fusion

there are some really cool books around explaining how to contact a database
on a server with your ISP.

you'll have more control on what happens and you write your own code.

You're in control.
This will not happen if you microsoft access pages.

good luck

 

[Sylvain Lafontaine]

DAPs are a difficult topic.

For the question about the script, you may have many script section on a
page:

<script>...</script>
<script>...</script>
<script>...</script>
....

For your error 301, you don't post an exemple of your code, so it's hard to
give you some advice on it.

Finally, there is a newsgroup about them:
microsoft.public.access.dataccess.pages and here are some more articles that
you may find interesting:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/programdap.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

S. L.