5 1364
kelvin H via AccessMonster.com wrote: Is it good to use Data Access Page to access Database ? (and put it on the web ~?)
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?
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.
"lylefair" <ly******@yahoo.ca> wrote in
news:11**********************@g43g2000cwa.googlegr oups.com: 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.
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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: J. Marshall Latham |
last post by:
I have a simple page trying to enter three pieces of information into a
database using ODBC on a web site that has .NET Framework 1.0, so I have to
use this Microsoft.Data.Odbc.dll which has been...
|
by: Lefteris |
last post by:
Hi,
I am trying to write a simple application in javascript that
automatically fills the fields of a form in a page at another domain.
I display the foreign domain page on a frame and have the...
|
by: jimb |
last post by:
I need some advice on how to securely transfer data between two servers.
Here is the situation. We have two sql servers that hold student data.
I have full access to my sql server, but only write...
|
by: TheCoder |
last post by:
I am making a D-base with web conectivity for my class project. I have
everything working but the subit button sends the data to the correct
fields but afterwards it wants to reproduce new blank...
|
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no...
|
by: Andy_Khosravi |
last post by:
I'm in a bit of a pickle.
My employer, a health insurance firm, had me design a small database to
track benefit issues. The intended users were technical specialists and
some managers (about 90...
|
by: Matt |
last post by:
I have the following in a page and I am trying to update a record on
the next page but for some reason the form data is not carrying over.
Any ideas why?
<form name=nxtlupdate method=post...
|
by: stathis gotsis |
last post by:
Hello everyone,
I am tying to come up with an elegant way to process some input data that
come from a form. When the user hits the 'Submit' button, i want the form to
appear again with the...
|
by: pbd22 |
last post by:
hi.
could somebody tell me, when uploading a file, i know the form where
the upload component is must
have enctype=multipart/form-data but, is the same true for the form
with the server code to...
|
by: ADezii |
last post by:
There are essentially three techniques for publishing Access Data on the Web. The first technique is static, and does not allow for the dynamic addition or modification to the data, There is no...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
| |