Transfer Access database to Intranet

[Guest]

Hi there -
I have standalone Access 2000 database (currently on a shared network) that
my bosses would like to run, be editable & dynamic on the Intranet.
I'm wondering what 3 programming languages can be used to do this, (ASP.NET?
SQL Server? etc) and which one is the best.
I have to recommend something to the bosses by tomorrow, and having 3
options is the best way to go.
I've tried to look for the transfer process, but I'm running out of time.
I'd appreciate any advice you can give me.
Thank you!
Tara

 

[David C. Holley]

You not 'transfering' per se. Its simply a matter of putting the *.mdb
file under the wwwroot folder of the server on which it will run. I'm
assuming that you'll be using IIS (Internet Information Server). From
there, to make the data available via a Internet, you'll need to build
the various pages to add/delete/view the data. I have not used ASP.NET,
only ASP and have not had any issues with it that I was not able to over
come. SQLServer is a database product also by Microsoft. It is
essentially the big daddy to Access when it comes to scalablity and data
managment (to put it succinctly). If you are not already family with
HTML, I would go to your bosses and advise them that you need additional
time to research things. The final decision is simple, but if you've
never done anything with webpages you're going to have a VERY STEEP
learning curve.