Since I am very new to SQL and database, I thought this might be the place to start. I have a friend who owns a cleaning business. He uses a program called Executive Toolkit to manage this business. He asked me if it was possible to set his program up on a web server and have he and his employees login to this program and enter data, from the web. I have no clue. So, here I am.

Thank you.

First you need a host that will provide you with these kind of services. Might want to try hostsearch.com or webhostingtalk.com

It sounds like his solution may not be web based. Could he not have employees dialing in to his server directly, and executing the programme that way?

A program called "Citrix" could also perform the function, and that can be configured to operate via a web browser - check out http://www.citrix.com/ for more details.

The alternative is to build your own "version" of his system, using asp/mssql , php/mysql , coldfusion or whatever - that would make things 100% web based, but may not be the best solution here.

H

Let's start with not what you have to work with, but what exactly is he doing now, and what does he want to do, in much detail. (not "he wants to make it web bsed" but something like "he wants to manage products and orders").

It's possible to write a quick ActiveX control I believe that may be able to interface with your program. I'll contact big_al and ask him if it's possible, hopefully he'll post here.

hi,

Quite an interesting question you have there.

I don't think writting an ActiveX COntrol would be worth it, I would be close to impossible to know how it is storing the information.

HOWEVER, If the program had an export feature, say it can export it's data in to a Comma Delimited file, Excel file etc etc It would be possible to create a service that exports that data and then uploads it to your webserver. Still pretty complicated and I can't imagine that it will be straight forward, but still possible

Hope this has been of some help, I'll think about it a little more once I am totaly awake

Thanks everyone for the positive responses. Upon further examination of this program. It seems that the main portion of this program uses MS Access. Quite a few of the larger files, including the "Demo" file has an extension ".mdb". I think this might be fairly easy to migrate into "web form" than I first thought. Anyone know of any simple solution?

Yeah, ASP will do nicely. It will be able to make a web front end, for the Access backend.

yep, its possible.

If you can't do it yourself, I would go to www.elance.com and have people bid on that job. There are tons of starving web developers out there who would love to take this on

No, if you can't do it yourself, I'll help you learn to do it or help you do it myself, free of charge. No need to spend money for not a lot of programming.

The Access will work nicely. Just post back with as MUCH information you can get, details, everything...this way I can design / program better.

You'll have to carefully consider data integrity with the asp solution. If the progam is being run on some local pc (ie at the office), how will it interact with changes over a web based version? The best solution may be to port the whole thing to being web based (if his connection is not too pricey).