access SQL database through internet

Question

access SQL database through internet

Molly88

Grasshopper

Points: 17
More actions
October 12, 2006 at 5:35 pm

#367648

Hi,

I am a newbie to all of this, so apologies if I am asking 'sad' questions ...

I am currently working on an application - MS Access front-end with SQL Server 2000 database. The plan is to build a web-enabled application for field engineers to query/update the SQL database.

Would the Microsoft .NET Framework alongside the SQL 2000 server allow me to create an internet application ? Would this be my best option, or are there other options out there ?

Can anyone point me in the direction where I can obtain information on how to set this up and how to best approach this.

Many thanks

Regards

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Laura Mahurin SSC Enthusiast Points: 105 More actions · Answer 1

I went through a similar transition a couple years ago - moving an Access application to ASP (pre .NET) with SQL server as the backend. Luckily, the app was for an intranet - so I didn't have the added security concerns that you're likely to have. Opening a database to updates via the internet comes with a whole slew of security concerns.

For a starting point, I can point you to the resource that I found most helpful - a book titled "SQL Server 2000 Web Application Developer's Guide". It's biased toward ASP and Microsoft's Visual InterDev - which were standard development tools here at the time. I haven't searched yet for a comparable book for .NET, but would bet one exists.

As for your "best" option? I tend to base that on the tools I have available and the time constraints I'm under. There are many different tools and languages that will get you there - it just depends on the resources you have to put towards it and the life expectancy of the system.

Hope this helps at least a little...

Gift Peddie SSC Guru Points: 73570 More actions · Answer 2

It is actually very easy leave the Access frontend alone and create the Web frontend, if you are in .NET 1.1 it is more difficult but if you have not bought tools then you can just download the free Visual Web developer Express and use the free training Videos provided by Microsoft. You also have the option to use existing Starter Kits that are almost complete applications you can just add what you need. Try the links below for the free tutorials, Videos and Starter Kits, the second link is more free training from the Asp.net founder's blog. Get started and you will see it is not complicated. BTW you can also post questions at the forums, post again if you still have questions will be glad to answer them for you. Hope this helps.

http://www.asp.net/downloads/default.aspx?tabid=62

http://weblogs.asp.net/scottgu/search.aspx?q=++free+training+videos&p=1

Kind regards,
Gift Peddie

Molly88 Grasshopper Points: 17 More actions · Answer 3

Laura,

Thanks for your help. I have managed to order the book you mentioned. The book will be a good starting point for me.

Regards

Molly88 Grasshopper Points: 17 More actions · Answer 4

Gift, thanks for the links and your help. Much appreciated. I'll probably have some more questions, once I am starting to code...

Kind regards

access SQL database through internet

Cookies on SQLServerCentral