Ticket tracking SQL database web access

We are a technical services provider and use a SQL database which we access through an Access program for ticket and inventory tracking.  Everything in this system is working great, but we're looking to make an addition.  We'd like to add a client portal on our website to allow customer to log in to view their tickets, submit new tickets, etc.  Can anyone recommend something open source we can try on our website that we could use with our existing database?
LVL 2
OAC TechnologyProfessional NerdsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Because your existing system is custom, ...there won't be any "off the shelf" solutions to "bolt on" a customer web portal.

Ultimately you do not want to maintain two separate systems for his (one Access based and one web based.)

To keep this short, ...your best bet would be t redesign this app form the ground up as a true web based app, ...then it can be used by your staff (internally) and by your clients (externally)

Maintaining two systems may become a nightmare because of the differing technologies, and how they treat things like; Scalability, Concurrency, Security, ...etc
...an this is all before you consider things like making compatible (non-conflicting) design changes in each system.
Finally MS Access would not be a good choice for the back end of a web database...

Another consideration is migrating your entire ticket system to one of the many off the shelf offerings...
For example, my company is currently using this, with good satisfaction:
http://www.hesk.com/

Hope this helps.

JeffCoachman
0
PatHartmanCommented:
It really depends on exactly what you need the outside users to do.  Viewing shouldn't present a problem.  Adding/changing may because you would have to duplicate the existing edit rules from your current app.

This is actually a reasonable place to attempt to use a hybrid Access app.  You would need to convert from SQL Server to Azure but that shouldn't present a problem.  You will also need Office 365 (A2013) as well as the latest version of SharePoint.  All existing users would continue as they are now. You would add new Access web forms that would be published via SharePoint for use by your clients.  These web forms would link directly to the same Azure database that your existing app uses.  Keep in mind that Access web apps are not ready for prime time but this requirement sounds like it falls within their capability.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.