Access and Intranet Site

[marcusZ]

Could you please give me some guidance and/ or direct me to a tutorial about
moving an access swithboard to an intranet site.

 

[Larry Linson]

Could you please give me some guidance and/ or
direct me to a tutorial about moving an access
swithboard to an intranet site.

In Access 2000 - 2003, there was something called Data Access Pages. It was
never popular, primarily because it was best used on intranets -- not really
useful for Internet. That's the closest you might come to "moving an Access
Switchboard". But, you should be aware that although Access 2007 "supports"
existing DAPs, it no longer can create or maintain one. All other methods
of "moving" Access to an intranet or the Internet, as far as I know, require
that you re-implement it in a different language or tool.

Larry Linson
Microsoft Office Access MVP

 

[Albert D. Kallal]

Could you please give me some guidance and/ or direct me to a tutorial
about
moving an access swithboard to an intranet site.

The problem here is that MS access really doesn't work with the Internet.
Ms-acces is not an Internet based development tool. So there really no way
to move an access applcaion to an internet site because MS access simply has
nothing to do with web development. It is the wrong tool. You'll have to
adopt web development tools, perhaps something like asp.net.

Access is the wrong developemnt tool and MS access cannot be used for the
web at all.

You can certainly deploy access in such a way that many users in different
parts of the country can share the same data information. And, they can do
this "over" the internet. I explain some possible approaches with MS access
on how to accomplish this goal here:

http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

 

[Mark Andrews]

If you could live with just reporting being available from the Intranet you
could use our report server product to deliver your access reports over the
web. You still need to do all report criteria screens in your web
development tool but you can run existing Access reports that live on your
IIS web server. I would consider our product a low-end web reporting
product similar to active reports or Crystal reports. For high end look at
Business Objects, Actuate, Cognos, SQL Server Reporting services.

Otherwise I agree with all other posts, switch to asp.net or asp with
something like SQL Server as the database.

There are people who go down the web-based access route, but I wouldn't. It
will kinda work until you get some concurrency in the mix.

HTH,
Mark
RPT Software
http://www.rptsoftware.com