Data Access Page?

Is it good to use Data Access Page to access Database ? (and put it on the
web ~?)


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1

re: Data Access Page?

kelvin H via AccessMonster.com wrote:[color=blue]
> Is it good to use Data Access Page to access Database ? (and put it on the
> web ~?)[/color]

It's not as good as Marinated Artichoke Hearts and Sleeman's Pale Ale
on a summer afternoon.

How good would you like it to be?

re: Data Access Page?

kelvin H via AccessMonster.com wrote:[color=blue]
> Is it good to use Data Access Page to access Database ? (and put it on the
> web ~?)
>
>[/color]
No don't use them.

See my web page for more info.

http://members.cox.net/tulsaalstons/...20Internet.htm

Bob

re: Data Access Page?

Have you ever had a co-worker ask you for a web interface to a table? I
have. I opened Access (ADP connected to a web enabled MS-SQL server),
had the wizard create a DAP for the table, saved it and uploaded the
file, all in less than two minutes. I sent him the IP address to the
file and the password. In less than three minutes from asking he was
working on the DAP. He was more than a little impressed, but he said
that he wanted to be able to work on it in Europe during the next week.
And I said, "You can!"

DAPs aren't wonderful always, but sometimes they are PDG.

Of course, I could have just done the thing as an ADP form, but the DAP
htm living on my server has, IMO, more flexibility and is more secure.
No Database windows here! And he can use it from any computer that has
MS-Office and IE.

re: Data Access Page?

"lylefair" <lylefair@yahoo.ca> wrote in
news:1128356607.460011.324300@g43g2000cwa.googlegr oups.com:
[color=blue]
> Of course, I could have just done the thing as an ADP form, but
> the DAP htm living on my server has, IMO, more flexibility and is
> more secure. No Database windows here! And he can use it from any
> computer that has MS-Office and IE.[/color]

What are the firewall issues there? Are you letting people through
to this page through an external web server, or requiring connection
via VPN and using an internal web server?

That's not specifically a DAP issue, but DAPs make it easy to expose
your database to attacks from outside your network if you deploy it
wrong.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

re: Data Access Page?

I put the htm/DAP file on a web site. It is available on the internet.

The ms-sql db is internet enabled. Connecting to it through the DAP
requires a Password.

That being said, I don't feel very safe at all knowing that the path to
the ms-sql server, the database name, and the user id are all available
to anyone who looks at the html source.

That is why I put the htm/DAP file in a web folder which requires a
User ID/ Password.

I do not use DAPs for anything serious. I use them for quick, simple,
data editing solutions for the trivial.