March 3, 2008 at 7:00 am
I was thinking of developing a fault tracking database (as a project to improve my SQL skills)to enable users to log issues with new system currently being implemented.
I was tempted to dive straight in with what I know best, namely Access. However this could be an opportunity to get to grips with some SQL!!
Question: If I developed using SQL would you recommend Access front end?
Question: How would I deploy to end user(s)?
Question: Would this allow for multiple simultaneous logins?
I would hope that on 'Submit' I would receive an email notification. Would this be a stored procedure? Unsure how to tie this all in to a front end?
Any Tips, Advice very much appreciated.
Many Thanks,
Phil.
Update: Could even do a web front end? Just a thought.........
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 3, 2008 at 12:38 pm
I would go web application. Mostly because there is a single deployment, and no workstation by workstation config issues to worry about.
If you have access to VS2005 standard or better - there's a lot "pre-built" that you can leverage and use (like a pre-built authentication mechanism, and therefore - multi-user scenario).
E-mails should happen from the back-end. Look into setting up Database Mail on your SQL Server instance.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 3, 2008 at 2:14 pm
Thanks Matt. I have downloaded CS3 on 30 day trial. I have a connection to SQL database backend, 3 tables (could even connect to adventure works).....that is where it ends! 🙂
Was looking at ASP.NET as I have IIS (do not have MYSQL for PHP)
Would like to create a login page..............will look at the world wide web thing for some tutorials.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply