Newbie Question - General SQL Database Question & Answer - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » General SQL Database Question & Answer » Newbie Question

Newbie Question

Options

Previous Topic · Next Topic

sturner333

Posted: Thursday, April 17, 2008 1:17:21 PM

Rank: Newbie

Joined: 4/17/2008
Posts: 1
Points: 3

Sorry for the lengthy question, but here goes:
I currently have an access database with a FE and BE that resides on each users laptop. Weekly they connect to the network and synch the BE the master on a network drive. There are numerous propblems with this as it has grown quite extensive.

We would like to have this be a server based database with the remote users either having access through the web or something else?

A few of the capabilities of the current database:
1. generate and print reports 2. update project forms. 3. enter time logs 4. enter notes

My question is:
What are my options for a remote FE? I am well versed in VB6 and Access. Would be willing to learn other languages (VB.net, my SQL, etc.) Would I be able to have the same functionality or would I have to have separate software for certain functions?

Scott Whigham

Posted: Friday, April 18, 2008 8:42:13 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Hi there -

Your options are limitless - it's a matter of preference really. Do you want a web based interface? They use ASP.NET, ASP, PHP, Cold Fusion, etc. If you want a standalone interface, then use VB6, VB.NET, C#, C++, Java, or even Access. The backend ("BE" Wink

should be SQL-based - like SQL Server or mySQL - so you need someone versed in writing SQL.

You could have one piece of software that would do everything or separate apps - that's another preference. I favor ASP.NET with the ReportViewer control for reporting for this project. I like a web-based interface as it is only one location to update the code and it is accessible by all the team members.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.