Giggz
asked on
convert a custom made microsoft access database to web app
Hi all,
I don't know too much about databases, but someone created me a microsoft access database, which i'm guessing it has some custom coding, but not 100% sure, and not sure how to check for that.
I used to use this db for myself, now i hired 2 people in the company, and they work from home, and i want to give them access to the db, I've done it with myself to share it via a shared folder over the internet, but because sharing it like that would give them the access to delete it and/or do some other damage, i prefer to convert it into a web-app, so each user has their own login/pass with their permissions.
basic info about the db: it's a list of my clients and their information, which has a search option which searches all the data for anything. each customer's profile, has name, phone, address, email, account#, service type, and a notes section where we write notes on each call when the customer contacts us for any reason.
if there is a way to convert this to some kind of web-app, or a tool that does it, or even someone/company that does this type of thing for an affordable fee, i'm interested.
thank you
I don't know too much about databases, but someone created me a microsoft access database, which i'm guessing it has some custom coding, but not 100% sure, and not sure how to check for that.
I used to use this db for myself, now i hired 2 people in the company, and they work from home, and i want to give them access to the db, I've done it with myself to share it via a shared folder over the internet, but because sharing it like that would give them the access to delete it and/or do some other damage, i prefer to convert it into a web-app, so each user has their own login/pass with their permissions.
basic info about the db: it's a list of my clients and their information, which has a search option which searches all the data for anything. each customer's profile, has name, phone, address, email, account#, service type, and a notes section where we write notes on each call when the customer contacts us for any reason.
if there is a way to convert this to some kind of web-app, or a tool that does it, or even someone/company that does this type of thing for an affordable fee, i'm interested.
thank you
ASKER
Hi thanks for your response, I've done this actually, but the issue is that the 2 staff members are on slow Internet speeds, running rdp is going to bog them down to a crawl. This is why i think a webapp would solve this issue.
I have a Linux hosting server which i could use to host it, but converting it is the main issue.
I have a Linux hosting server which i could use to host it, but converting it is the main issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is not as simple as it sounds and I agree with Gustav, you will be writing something from scratch. Try a service like microsoft 365, google apps for work or even evernote.com if all you are needing is to share contacts and notes.
ASKER
thanks everyone for the suggestions so far.
> eqldata.com, won't help as it will be the same problem i'm having, actually maybe even worse because it's proprietary software.
> rdp, their internet speeds are 1-2mbps, i've used rdp for other work required, and it ran horribly slow. the other issue is that those employees have many other tasks, and most of these tasks are done on their own computer, having an rdp session open, and minimizing it to do other work, then going back to rdp session will be a pain. if their internet was fast enough, i would have created all their work on an rdp account per employee, that way they can do all the work on their account. but that will kill their time before they accomplish much work.
> office 365, honestly i never used it, i'm not sure how it will work with my database, and i have no idea what it costs.
> google apps, i thought about it, but that wouldn't work for my needs.
> evernote.com, doesn't have what i need, and it's over priced for business use, for what it offers.
i thought of another thing, one of our virtual machines is hosting sharepoint 2013, is it possible to move it so it's web-based on sharepoint? and how is it done?
i have dedicated servers in a datacenter, if there is an opensource solution which has my needs, i don't mind hosting one myself. otherwise something web-hosted.
i'm ok with having to rewrite the code if it won't cost an arm and 3 legs ;)
> eqldata.com, won't help as it will be the same problem i'm having, actually maybe even worse because it's proprietary software.
> rdp, their internet speeds are 1-2mbps, i've used rdp for other work required, and it ran horribly slow. the other issue is that those employees have many other tasks, and most of these tasks are done on their own computer, having an rdp session open, and minimizing it to do other work, then going back to rdp session will be a pain. if their internet was fast enough, i would have created all their work on an rdp account per employee, that way they can do all the work on their account. but that will kill their time before they accomplish much work.
> office 365, honestly i never used it, i'm not sure how it will work with my database, and i have no idea what it costs.
> google apps, i thought about it, but that wouldn't work for my needs.
> evernote.com, doesn't have what i need, and it's over priced for business use, for what it offers.
i thought of another thing, one of our virtual machines is hosting sharepoint 2013, is it possible to move it so it's web-based on sharepoint? and how is it done?
i have dedicated servers in a datacenter, if there is an opensource solution which has my needs, i don't mind hosting one myself. otherwise something web-hosted.
i'm ok with having to rewrite the code if it won't cost an arm and 3 legs ;)
As for your comments on RDP, I wonder if we speak about the same thing?
I can not at all recognize your experience. We have employees working at clients all day with a mix of an RDP session to our in-house terminal servers and local tasks like Outlook and Excel. They experience virtually no difference between operating the remote apps and the local apps. And that is via 1.5 Mbps lines each shared by about 3 employees.
/gustav
I can not at all recognize your experience. We have employees working at clients all day with a mix of an RDP session to our in-house terminal servers and local tasks like Outlook and Excel. They experience virtually no difference between operating the remote apps and the local apps. And that is via 1.5 Mbps lines each shared by about 3 employees.
/gustav
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it's not that evernote being expensive, but it's overpriced for what it offers. if it's a choice i would rather take office 365 before going for evernote.
but actually what will happen is that i found someone who will convert the db to web app for me for a small fee.
but thank you for the suggestions everyone.
but actually what will happen is that i found someone who will convert the db to web app for me for a small fee.
but thank you for the suggestions everyone.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for Giggz's comment #a40628456
for the following reason:
found an expert to do the work myself
Accepted answer: 0 points for Giggz's comment #a40628456
for the following reason:
found an expert to do the work myself
Your comment is not really a "solution" to this question. Hiring someone to do the work is great, but you asked about tools and methods to convert this to a web app, and several of the Experts provided you with valid suggestions.
ASKER
As i mentioned in my original post even if someone/company can do this for an affordable price, I'm interested. I found the "someone" outside experts exchange, this is the reason i selected my own solution as the answer.
None of the above recommendations are solutions that i would consider, that was the reason i went the route of hiring someone to complete the project.
Never the less, i do appreciate everyone's help and suggestions.
None of the above recommendations are solutions that i would consider, that was the reason i went the route of hiring someone to complete the project.
Never the less, i do appreciate everyone's help and suggestions.
EE doesn't allow you (or us) to solicit on the threads, so the Experts could not have written "I'll do it for you for xxx". That would get the question shut down immediately, so you can pretty much discount that option.
Fact remains, however, that you asked for opinions and suggestions, and that's what the Experts provided you. It's impossible to be more specific given the level of information we were provided.
My suggestion is to accept:
http:#a40623124
http:#a40624386
http:#a40624573
Fact remains, however, that you asked for opinions and suggestions, and that's what the Experts provided you. It's impossible to be more specific given the level of information we were provided.
My suggestion is to accept:
http:#a40623124
http:#a40624386
http:#a40624573
Any skilled network supporter can set this up literally in minuttes. You should not play with it yourself as a few settings in your router/firewall have to be done.
/gustav