• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

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
0
Giggz
Asked:
Giggz
  • 5
  • 3
  • 3
  • +1
3 Solutions
 
Gustav BrockCIOCommented:
Judging from your scenario and your experience, it would be far easier and faster and cheaper to let the new users connect via the Remote Desktop Client to one or two computers (or a terminal server) in your office.

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
0
 
GiggzManagerAuthor Commented:
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.
0
 
Gustav BrockCIOCommented:
Hmm, in my experience just about any modern internet connection is usable for an RDP connection - at least if you adjust it to use lowest resources possible. Of course, a 56K modem line may prove too slow but who runs these nowadays?

Unfortunately, converting is not the word for moving a desktop application to the web; it's a complete rebuild from scratch.

An alternative, often mentioned by Jim Dettman, is the EQL service:

    http://eqldata.com/

I haven't used it myself so I can just your attention to it. It may suffer at low bandwidth as well.

/gustav
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.
0
 
GiggzManagerAuthor Commented:
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 ;)
0
 
Gustav BrockCIOCommented:
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
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Sharepoint integration is not the ticket for this, at least in my opinion. If your at-home employees would have troubles with an RDP connection, they'd hate having to muck around with SP.

Unfortunately, if you can't do RDP or eqldata, then you'll need to rewrite it as a true web app. Access 2013 introduced the concept of web apps, but they are still in the infancy stage. From what you've written, your app might (and i stress "might") be a candidate for a web app, but that would have to be determined by a full review. For the most part, an Access Web App can perform basic CRUD operations (Create, Read, Update and Delete). If you have anything that is based entirely in VBA, and that could NOT be moved to macros, then you would lose that functionality - web apps don't support VBA in any way.

You could perhaps try a "hybrid" app, with your data hosted on a server, and the users connecting to that from their home machines. I've used methods like this, and depending on the amount of data, you can often get a fairly decent to very good experience.
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
Evernote  may or may not be your ticket, but if you are not willing to spend $10/month for what I think you said are 3 users, you may be out of luck because most of these services are per user per month at about that price.

Contacts, notes, documents etc are all things google apps or office 365 will do https://support.office.com/client/Create-and-use-shared-contacts-618cab29-3c2d-4047-8a5b-ee3ef01e55c7.

You can also use Highrise https://highrisehq.com  or salesforce http://www.salesforce.com but you will find their pricing even higher.  

If you try this on your own and you are very familiar with a serverside language, hosting & security and front end programming you can pull of a simple contact and notes web app from scratch inside of a month. Using an admin template will help speed things up http://themeforest.net/category/site-templates/admin-templates but remember there is no server side coding in any of those.  You can also use front end apps from http://www.sencha.com, http://www.telerik.com/kendo-ui or http://wijmo.com/ and even http://jqueryui.com/.   Jqueryui is free.  Kendo-ui has 80% of it's widgets open source but important ones like a grid are part of the paid.  But you can use http://www.datatables.net/ for your grid.

What typically happens is it seems "free" to start this on your own. But I can tell you from seeing others start projects like this and asking help on EE, they tend to go on for 6 months to a year and many times end up just abandoning it and figuring out buying something or somebody would have been easier.  

While it may cost $30 to $100 per month to use a lower end 3rd party system like google apps/office365 or a higher end like salesorce/highrise, when you figure in the value of your time to reinvent the wheel...these other projects become a lot less expensive.

I can concur on using rdp with 1.5Mbts or less that it works fine although I also agree it is not an ideal solution.  What you want to do is simple enough and I would seek out a 3rd party ready made app.

Good luck on your project.
0
 
GiggzManagerAuthor Commented:
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.
0
 
GiggzManagerAuthor Commented:
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
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
 
GiggzManagerAuthor Commented:
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.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 5
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now