Choose Between Access or VB.NET/SQL Server

[ThomasLafferty]

I have been tasked to develop a database which will allow absolute novices to MS Windows and its associated programs to track trucks in and out of a terminal. I am certain that I can do this fairly competently in Access. Here's my dilemma:

I work from a terminal in Tacoma and the data may need to be accessible from a terminal in Anchorage, Alaska or perhaps Fairbanks, Alaska. IS management seems to be insistent that I shy away from development in Access and try to do this in VB.Net, and I know nothing about VB.Net. It seems to me that I could develop it in Access, then import/export/connect to it in VB.Net, but I am not sure how to go about this or what issues I will need to consider.

The direction I am being encouraged to consider is accessing the data via a web page. The users who will be doing primary input are not company employees but guards with very minimal skills, so the interface needs to be very simple.

What would you suggest? Should I start in Access anyway and find a way to make this happen in VB.NET? Some other route? Do you need more info to help me process this?

Thanks! Tom

Born once die twice; born twice die once.

 

[jbenson001]

Stay away from Access.. It seems they want a web application which makes sense since it will be accesed from all over the globe it seems. You can create the web app using Visual Studio., You can program it in VB.NET, C#.NET or J#.net. It just depends on what you know and are comforatable with. Since you know Access, I say VB.NET would be the easiest for you to pick up.

As for the end user, they don't care what is is using, you have to created it so that they can use it easily no matter what you use to develop it.

Jim

 

[BrianB]

Or better yet, get management to spring for a consultant who knows how to do this easily, then use your interaction with him/her as a learning opportunity.



Brian Begy
BugSentry - Automatic error reporting

http://www.bugsentry.com