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

Accessing a DB from Corporate Intranet

P: n/a
Sorry for the obvious question ... where can I obtain reasonable info on how
to enable an Access 2003 DB to be available for read access from a corp
internet. I need to be able to provide selection access as well using
queries. No write update
May 22 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
James DuPonte wrote:
Sorry for the obvious question ... where can I obtain reasonable info on how
to enable an Access 2003 DB to be available for read access from a corp
internet. I need to be able to provide selection access as well using
queries. No write update

YOu should look into the built in capability for building Data Access
Pages. All users will need to be able to access the database through
the LAN for this to work. Probably your most straightforward option.

Forms can be converted to DAPS although they are limited in the amount
of sophistication.

Good luck!

Bob
May 22 '06 #2

P: n/a
Forget Data Access Pages! They are highly inefficient. I would use an
ASP/ASP.NET front-end to your access backend. Data access pages are
limited and require IE to work.

If you have no knowledge of ASP, you can use Dreamweaver to develop the
pages although the ASP code generated by Dreamweaver is weak. At least
it will get you started.

May 22 '06 #3

P: n/a
Don't overlook Visual Studio Express. ASP.NET, especially with Version 2.0
of the framework and 2005 of Visual Studio, is ...almost... as easy as
putting together Access forms. (It's far more powerful, of course, just not
as easy to put together.)
May 22 '06 #4

P: n/a
Did I mention that the Express versions are free? Remember MSDE -- free SQL
Server 2000? Well, SQL Server Express is free 2005. More important (for
your situation) Visual Web Developer 2005 Express Edition is free Visual
Studio. Lightweight, but not a bad start.

May 22 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.