By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

An intranet interface for Access

P: n/a
What is the best way to implement a front end for an access database via a
web browser on a private intranet?

This is totally new ground for me. I want to allow users to enter
information into a database and get reports via the normal browser
interface.

How secure is this? If the browser has access to the access application, do
the users then have rights to that directory that would allow them to reach
the database itself?

dixie
Nov 12 '05 #1
Share this Question
Share on Google+
14 Replies


P: n/a

"dixie" <di****@dogmail.com> wrote in message
news:WG***************@nnrp1.ozemail.com.au...
What is the best way to implement a front end for an access database via a
web browser on a private intranet?

This is totally new ground for me. I want to allow users to enter
information into a database and get reports via the normal browser
interface.

How secure is this? If the browser has access to the access application, do the users then have rights to that directory that would allow them to reach the database itself?

dixie


Perhaps look into ASP pages using VB code?

The user only sees the end result of the script (ie. HTML) and don't see
your code. A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response
Nov 12 '05 #2

P: n/a
Bradley,

<A simple way to do it is to embed a connect string to your database that your
code uses to access your database then use code to determine what the person can
see/access.>

Can you give us a simple example of how to do this?

Thanks!

Steve

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:Km******************@news-server.bigpond.net.au...

"dixie" <di****@dogmail.com> wrote in message
news:WG***************@nnrp1.ozemail.com.au...
What is the best way to implement a front end for an access database via a
web browser on a private intranet?

This is totally new ground for me. I want to allow users to enter
information into a database and get reports via the normal browser
interface.

How secure is this? If the browser has access to the access application,

do
the users then have rights to that directory that would allow them to

reach
the database itself?

dixie


Perhaps look into ASP pages using VB code?

The user only sees the end result of the script (ie. HTML) and don't see
your code. A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Nov 12 '05 #3

P: n/a
OK Bradley, bear with me here as I have no experience of this at all. I
presume there is a software program involved here - ASP.Net or something
like that. I presume that would need that software to develop the
application? Would the end user of the application also need the software
to run the intranet side of it, or is it only needed to develop it? The
answer to that would make a big difference to me.

dixie

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:Km******************@news-server.bigpond.net.au...

"dixie" <di****@dogmail.com> wrote in message
news:WG***************@nnrp1.ozemail.com.au...
What is the best way to implement a front end for an access database via a web browser on a private intranet?

This is totally new ground for me. I want to allow users to enter
information into a database and get reports via the normal browser
interface.

How secure is this? If the browser has access to the access
application, do
the users then have rights to that directory that would allow them to

reach
the database itself?

dixie


Perhaps look into ASP pages using VB code?

The user only sees the end result of the script (ie. HTML) and don't see
your code. A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Nov 12 '05 #4

P: n/a
You can write ASP/HTML using Notepad if you want, but a development program
will make it easier (esp for debugging) :)

You'd need IIS server (a cut-down version comes with WindowsXPPro) which
will process the ASP pages and serve HTML results to the client's browser.
All the client needs is a broswer (and access to the web server of course).

That's rather simplified but should give you the gist. I'm no expert here
having just build my first ASP pages a few months ago:)

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"dixie" <di****@dogmail.com> wrote in message
news:n9**************@nnrp1.ozemail.com.au...
OK Bradley, bear with me here as I have no experience of this at all. I
presume there is a software program involved here - ASP.Net or something
like that. I presume that would need that software to develop the
application? Would the end user of the application also need the software
to run the intranet side of it, or is it only needed to develop it? The
answer to that would make a big difference to me.

dixie

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:Km******************@news-server.bigpond.net.au...

"dixie" <di****@dogmail.com> wrote in message
news:WG***************@nnrp1.ozemail.com.au...
What is the best way to implement a front end for an access database
via
a web browser on a private intranet?

This is totally new ground for me. I want to allow users to enter
information into a database and get reports via the normal browser
interface.

How secure is this? If the browser has access to the access

application,
do
the users then have rights to that directory that would allow them to

reach
the database itself?

dixie


Perhaps look into ASP pages using VB code?

The user only sees the end result of the script (ie. HTML) and don't see
your code. A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response


Nov 12 '05 #5

P: n/a
Using .Net is great once you surpass the learning curve, but if your over 50
years of age, your chances of expiring may occur before you reach expert
level! Luckily, I started this at age 31... so I might make it if I try
really hard...

What you really need to look at is ADO (for asp) or ADO.NET (for asp.net).
These components can be used as a middle layer that would be "sandwiched"
between your data source (mdb, sql db, et.) and your presentation Html.
They are responsible for connecting to your database (adodb.connection -
provide your connection string here), invoking a query or table open
(adodb.command), and finally returning that data into an object variable
(adodb.recordset) (usually a recordset or dataset object) in which you can
loop through to render the appropriate html to the client.

It's important to remember that Asp pages can be completely dynamic. You
write html in those files... then when you get to a part where you want to
display data from Access you use the <% and %> tags to tell IIS that you are
putting vbscript code here. There are methods, properties, and access to a
slew of Asp related environment stuff.

In ASP.Net, I would recommend that you check out http://www.asp.net and
download "Web Matrix" from Microsoft. It's free, works very nice, and is
free (did I already say that?). I use VS 2003 and get along fine with it,
however after I discovered Web Matrix... I realized that life could have
been much simpler had I started with it instead.

Did I mention that you will have difficulty in this if you are not fairly
proficient in vb, vba, vbscript, C++, or some supported language? If you
decide to run with ASP -- look hard into building ActiveX dll's to "house"
the bulk of your VB code. They are way simpler to debug since you can run
them in VB6 and do full debugging. When you have it working good, you can
then make a setup package and install it on the server.

Lastly, there are tons of websites and books dedicated to these
technologies. I can't really say that I like any of them best, except for
"Programming Visual Basic .NET" by Francesco Balena - 1500 pages.

Here is a quick and dirty example of how to iterate data onto a page using
ASP...

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db6.mdb;Persist
Security Info=False"
or -- create a DSN and use...
cn.Open "myDSN"

-Begin Code---------------------------
<HTML>
<BODY>
<p>This is my html code... next will be column 0 from the table I select
from.</p>
<% 'test1.asp
dim cn
dim rs

set cn = Server.CreateObject("ADODB.Connection")

'cn.Open "DB6" 'in case we want to play with dsn props
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db6.mdb;Persist
Security Info=False"

Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 1
rs.Open "SELECT anything from whatever'", cn, 1, 1

response.write "<table>"
do until rs.eof
response.write "<tr><td>" & rs.fields(0) & "</td></tr>"
rs.movenext
loop
response.write "</table>"
%>

</BODY>
</HTML>
-End Code---------------------------
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

"dixie" <di****@dogmail.com> wrote in message
news:n9**************@nnrp1.ozemail.com.au...
OK Bradley, bear with me here as I have no experience of this at all. I
presume there is a software program involved here - ASP.Net or something
like that. I presume that would need that software to develop the
application? Would the end user of the application also need the software
to run the intranet side of it, or is it only needed to develop it? The
answer to that would make a big difference to me.

dixie

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:Km******************@news-server.bigpond.net.au...

"dixie" <di****@dogmail.com> wrote in message
news:WG***************@nnrp1.ozemail.com.au...
What is the best way to implement a front end for an access database
via
a web browser on a private intranet?

This is totally new ground for me. I want to allow users to enter
information into a database and get reports via the normal browser
interface.

How secure is this? If the browser has access to the access

application,
do
the users then have rights to that directory that would allow them to

reach
the database itself?

dixie


Perhaps look into ASP pages using VB code?

The user only sees the end result of the script (ie. HTML) and don't see
your code. A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response


Nov 12 '05 #6

P: n/a
I don't know Chuck... dixie hasn't exactly defined what the application is
yet. I know that if I were starting fresh, it would be with Web Matrix,
then on to VS. Asp is great, I love the speed, simplicity, and ActiveX
dll's... but my gosh, some of the things I have done lately I could have
never accomplished with Asp (at least before that magic number of 50). I
have discovered 3rd party components by Infragistics and Crystal that just
light the application on fire with functionality and fairly smart rendering
to specific browsers without my intervention.

Many Intranet applications are put to good use as a reporting tool. For
this, Crystal would be wonderfull as a web reporting tool. Again, the
technology takes some time to grasp... but once you do the first one they
get easier. Microsoft recently released a new reporting tool for Sql Server
that has my attention -- Sql Reporting Services. If you own Sql Server, you
can use it free. I haven't played with it yet, but I would sort of think
that you could link an MDB as an OLEDB source to Sql Server and report out
it. Features such as scheduled report generation and delivery via email, a
complete portal for Intranet or Internet use for access to reports with a
security system implemented, and some other things I can't recollect at this
hour. There is a great video of the launch at:
http://www.microsoft.com/sql/reporting/default.asp

Sorry about the age thing - I didn't know you were still a kid... (umm... at
heart anyway). That's a good quality for a programmer to have. Most people
eventually get fed up with change. Good for you sir!

It's been quiet and orderly in this newsgroup lately, hasn't it?
"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:t0********************************@4ax.com...
On Wed, 25 Feb 2004 16:52:52 GMT, "Jerry Boone"
<je****@antech.biz.killspam> wrote:
Using .Net is great once you surpass the learning curve, but if your over 50years of age, your chances of expiring may occur before you reach expert
level! Luckily, I started this at age 31... so I might make it if I try
really hard...


<Ptttthhhhh!> .NET isn't all *that* bad. It just requires a
different way of looking at things. On many levels, sadly (for the
learning curve). But age isn't a qualifier! I don't want to say at
what age I was when I did my first .Net app.... Or my latest, for
that matter!

Regardless of the learning curve however, let's be clear here... .Net
is *NOT* required for this application, nor is it any easier in .Net
(unless that's what you're used to). "Classic" ("regular", "old",
"straight", "normal", etc., etc., ad nauseum) will work just fine, and
it's a *lot* easier to set up and get working. Cheaper too, since the
only thing you need other then a IIS server is an HTML editor (or
NotePad).

Granted, however, I'd probably do this in .Net too if I had the
choice! .Net, once you're over the learning curve, is *that* much
nicer to use! It's just not _required_ for this application.
--
Explain Counter-clockwise To Someone With A Digital Watch

Nov 12 '05 #7

P: n/a
> I do't know any more then what was posted as well, so I based my
opinion on that. .Net is pretty neat, but in most cases it's not
_required_. And since that's an additional set up for the Network
Admin, I try not to force it's use unless it's required.
Right, but the framework is easy to load up... and part of Windows Server
2003 so it will get easier as admins adopt .net apps (win or web) on
servers. Asp is fast, asp.net is faster with it's full caching abilities.

I gave up on Crystal for web reporting quite a while ago. I can do
more, faster in HTML code and a freeware java scripting applet I found
on the net for whatever graphs are needed. I'm not big on graphs
however, nor are most of my customers, so it's not a big loss. Most
are more interested in getting the data, and getting it fast. HTML
and ASP are faster then HTML, ASP.NET & Crystal. That wasn't
something I had to spend a lot of time thinking about....
Yes, Crystal is nice, but slow... but more importantly (to me) it eats the
server alive and costs a fortune to license to a mass of concurrent users.
I keep it around because I don't have more than 2 or 3 people out of 180
users at one time that need a report so I get by with the version that comes
with .net. I purchased 8.5 and implemented a nice asp web reporting app a
couple years ago for a busy laboratory and it's still running and doing ok,
never misses. Out of all of reports, the end goal in every case is to get
it into a pdf for perfect printing and customer portability/storage.

I try not to use 3rd party controls. Period. Ever. Nothing against
them, I just don't use them unless I have no other choice. Well,
maybe I see it as something against *me*, since in most cases, it's
something I *should* have been able to do myself.
Hmm... not sure if I agree with that, I doubt I would ever blame myself for
not writing Windows, or IIS. I really like what I can do with the
Infragistics grids and graphs, they are amazing tools. I could spend years
coding that functionality, but I am definetly not going to... so $499 to the
customer and we are happy, happy campers. If you buy the subscription, you
can even get thier source code to modify! In case you haven't looked into
this, it does things like sorting without postbacks (very slick js)...
allows data modifcations and updates all over the populated grid that are
posted with a single batch postback. You can even size columns in the
browser without postback. You can even load hierachle data and tree branch
it, which occurs when it notices that you have a multilevel dataset with
relations. The list just goes and goes... not to even mention what the
graphing capabilities are... geez... and it's all fast if you do things
right, which is a learning thing as usual.

Sql Reporting Services... Sorry, I haven't seen that. I've been doing
Scheduled Reporting and Emailing information out of SQL Server for
quite a few years now however, so that won't be a "plus" for me. Hunt
around in the Knowledgebase (or around the net) and you'll find
samples how to do all that without the new "tool".
Been there and doing that. You should really check out that video and demo
clip sometime, it will have your attention about 1/2 way through (after the
marketing blah blah you know).
Anyways, this thread has now left the "arena" of Access, so if we want
to continue this discussion, we'll need to take it somewhere else.
I agree - where do you want to go today? :)
It was nice having a discussion on .Net without having the "holy
warriors" from both sides joining in though!


Hmmm... yes, a marching they will come...
Nov 12 '05 #8

P: n/a
Jerry Buffoone, have you figured it out yet? That you were had?

Sorry, butthead, you jist isnt as smart as you thot you wuz.

Nice little anecdote for the CDMA annals. [that's "anals" for Fenton]

take care, butthead.

In article <xu**********************@newssvr11.news.prodigy.c om>
"Jerry Boone" <je****@antech.biz.nospam> wrote:

I don't know Chuck... dixie hasn't exactly defined what the application is
yet. I know that if I were starting fresh, it would be with Web Matrix,
then on to VS. Asp is great, I love the speed, simplicity, and ActiveX
dll's... but my gosh, some of the things I have done lately I could have
never accomplished with Asp (at least before that magic number of 50). I
have discovered 3rd party components by Infragistics and Crystal that just
light the application on fire with functionality and fairly smart rendering
to specific browsers without my intervention.


Nov 12 '05 #9

P: n/a
starwars <no****@tatooine.homelinux.net> wrote:
Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.


Please ignore the above posting and others which are somewhat bizarre.

Note to persons new to this newsgroup. One person, with many identities, is being
rather disruptive. If you see a bizarre posting it's probably the work of this
disruptive person..

Check the headers of the posting. If you see the following the posting likely can be
ignored. Of course, there will likely be other headers to be added to this list.

Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.
or
X-Abuse-Report: ab***@teranews.com
or
Organization: Posted via Supernews, http://www.supernews.com
or
Organization: 100ProofNews.com - Unlimited Downloads - $8.95/Month

You can also change your NewsReader program settings to ignore off-topic posts. See
http://www.hyphenologist.co.uk/killfile/ for more information.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #10

P: n/a
Thanks - your very helpful.
"starwars" <no****@tatooine.homelinux.net> wrote in message
news:d1******************************@tatooine.hom elinux.net...
Jerry Buffoone, have you figured it out yet? That you were had?

Sorry, butthead, you jist isnt as smart as you thot you wuz.

Nice little anecdote for the CDMA annals. [that's "anals" for Fenton]

take care, butthead.

Nov 12 '05 #11

P: n/a
"Jerry Boone" <je****@antech.biz.nospam> wrote:
Thanks - your very helpful.


Please don't repeat any of the disgusting comments.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #12

P: n/a
Sure, use PHP. It's good and pretty fast, just different. It's just that
the server the poster exposes would be windows and would already have
everything ready to go. I haven't been reading the tabs lately, how is that
lawsuit for stolen "SCO Unix" code found in Linux going? Just saying that
there are a few bad apples in every tree, give it time and they always
become more apparent.
"lcs Mixmaster Remailer" <mi*@anon.lcs.mit.edu> wrote in message
news:20************************@nym.alias.net...

"Jerry Boone" <je****@antech.biz.killspam> wrote in message
news:Ep*****************@newssvr22.news.prodigy.co m...
Using .Net is great once you surpass the learning curve, but if your over
50
years of age, your chances of expiring may occur before you reach expert
level! Luckily, I started this at age 31... so I might make it if I try
really hard...

What you really need to look at is ADO (for asp) or ADO.NET (for

asp.net). These components can be used as a middle layer that would be "sandwiched" between your data source (mdb, sql db, et.) and your presentation Html.
They are responsible for connecting to your database (adodb.connection -
provide your connection string here), invoking a query or table open
(adodb.command), and finally returning that data into an object variable
(adodb.recordset) (usually a recordset or dataset object) in which you can loop through to render the appropriate html to the client.

[blah blah blah]

Hey, forget the kludge above and check into PHP. Why make life so
difficult?

--
Jeff Aldrich, R.N.

Nov 12 '05 #13

P: n/a
Well, generally if you are a PHP lover, you would naturally want to use
Apache on Linux, despite the alternatives.

And you are such a genius, hmm... just a sec... ahhh...yes... you have been
watching the movie Master of Disguise with Dana Carvey. You remind me of
"Pistacio", is he your idol? You must have almost every word memorized!
You live and hide your identity just about as well too... the comments about
bafoone and turtle's really give it away. There is nothing original in your
writing, did you know? By judging that, I put you smack dab at puberty!
Amazing, does your momma really know what you are doing with her computer?

It was no surpise that you "dissappeared" for a couple of weeks after
admitting defeat on the "Sympathy for Starwars :)" post -- . Was your ISP a
little hard on you? Would you really like to play again? You leave enough
evidence behind to uncover a microbe in the desert. What excuse did you
give momma when you lost your cable access? Do you know "who's your
daddy?", maybe I should show you again?

Lot's of laughs -- thanks starman... I'm really starting to enjoy myself
now! Keep up the good work, this is priceless!
<snip starman stuff for tony and others>
Nov 12 '05 #14

P: n/a
> You must have been tired when writing this. Even a bit below your
standards.

Hmm... your right in that it is below my standards. No matter how hard one
fights it, the animal instinct just has to "come out" once in a while.

Here's some examples... Our species has only advanced so much. In fact, you
are asking a lot from a species of animals who are entertained by watching
Ozzy Osborne's dogs having anal sex on MTV, or humans having sex with
animals. Really... I just barely remember as a kid seeing the next door
neighbors small dog humping a cat. If it were not for our ability to
communicate, more humans would be doing it and less law would be stopping
it. That's just an observation from the flight deck... "it's nature's way"
as the good old "Croc Hunter" would say.

With all of this activity that is exposed on public TV, web, and in front of
our very eyes by every species with a "pp"... you still hang on to your "pet
subject" in a group (dull as it may seem) that rejects you and most idea's
unless they are "technically feasible" and "on topic". He must have really
pissed you off... which is the only "somewhat" on topic part of your off
topic ranting.

This warning people about "the perv" just isn't a good battle cry. Have you
ever been in a bar and seen the bouncers throw the two with difference
outside? It is a good thing they do so others don't get hurt and the stage
doesn't get trashed. The only difference here is that you are yelling from
the door (thanks to your anony) and your nemi is still inside. You might be
able to make some noise... and some will hear you, but the band just covers
your voice by continuing to play. In time, I expect he will get tired of
you and do something about it... we all have a good idea where he would
start. That too is "nature's way".

Also, I am not interested in chasing you anymore. I found you once and I
know that if I tried I would succeed again. That's not saying that you
don't know what you are doing to some degree... it is saying that people in
general always slip somewhere... it's simply inevitable. Also, nice job
using those Italian foreign remailers - they are hardest to track since they
are out of most US jurisdiction. Just be careful since some are owned or
used by various mobsters and terrorists, which of course are the most
closely watched by the good old FBI and CIA. I'm sure everyone would be
very unhappy to see you pulled out of your house and your computer take for
evidence for a long time for something you didn't do. As I said before, the
tool you use has some heat -- if you can't deal with that heat then you
shouldn't use it. People post things about murdering babies and stuff with
the id you are using... who is to say that you didn't write that as well?!
You may very well be found by someone who is much more ready to pay you a
visit than anyone in this group. I know all about the reasons to use
remailers and the wacky excuses they use to pass them off as tools of
virtue... but really... why would you mail something without your ident on
it... duuuhhhh...

Lastly, you post to this group EVERY DAY as starwars. You mean to tell me
that between 2/13 and 2/27 you had access to your previous internet
connection? Come on starman - everyone knows better than that. One post on
2/21 wasn't made from your prior connection, you know... the one you were
banned from. Your persistence is your identity and somewhere it got lost
for about 14 days? Not to mention all the admissions you did on 2/13/04.
I'm really not gloating and I wasn't then, but you know you slipped and that
is that. Also, when you mock something really loud, it's obvious that you
were found. Kind of like your persistence with the subject you flog.

While things I may have said are lame (momma thing and such), you could
surely gesture the same with the "buffoone" and "barney fife" thing being
lame.

Anyway... enough ranting for the week, got a lot of work to do... try to be
good starman.
Nov 12 '05 #15

This discussion thread is closed

Replies have been disabled for this discussion.