Kapalı

Access database in the cloud?

Hello Freelancers. I'm looking for someone who can suggest a solution to a puzzle/problem, and help us get started in the right direction. Here are the details.

We are a small manufacturer's rep business. We currently have an highly developed, custom MS Access database application that is the heart of our business information, handling everything from orders to commissions to forecasting, advertising and promotions, and more. It's a split database with users accessing the front end by logging onto our server (Windows 2008 R2) via remote desktop/terminal services. The back end (Access tables) are also on our server.

We recently migrated to Office 365 for email, file storage and collaboration, etc.,, but users still have to log onto the server to get to our data, run reports, etc. We'd like to try to find a way to fully transition away from the server. The problem I'm facing is that trying to convert our existing database application over to a Microsoft "web app" would be a huge project that I'm not interested in. We'd have to try to replace all our VBA, for one thing, let alone re-creating 50 forms, over 300 queries and reports.... I'd like to find a way to keep our existing front end if at all possible, and migrate the tables somewhere "in the cloud" so I don't have to maintain the server in the office.

I recently tried making a hybrid system with Office 365, importing the data into a web app, and then linking our front end (on each user's local desktop) to the new SQL tables that were created. But those tables don't maintain referential integrity, so we started seeing duplication and errors right away, and also the performance was really slow. I think it was probably not the right solution.

I would prefer not to build a whole new application on a proprietary system like Caspio. Partly because of the work involved in starting from scratch, partly due to the monthly fees, and partly because if they go out of business, I'm out of luck.

Someone told me the best solution would be to put the data online using SQL tables and building a website to access it using PHP, but I don't know PHP at all and don't have time to learn. I like understanding the application myself and being able to make changes as needed, but I own the business and I should be spending most of my time selling, not programming. So I am looking for an easier solution if it's out there. I looked at Amazon web services, wondering if they might offer an environment or any tools that would work, but I don't even understand the different terminology I see there, so I don't know if there's a solution there or not.

So basically I'm looking for ideas on how to do this in a way that would minimize our development time, and keep expenses down. My problem is that I don't know enough about development, networks, SQL, etc. to even know if there's a good solution out there. I might just be paying for your advice.

Here's my proposal. If someone can suggest a solution that works for us and that I can implement all by myself, I'll pay $75 for the suggestion - so your great idea and brainpower won't have gone to waste. If it's a solution that requires your assistance (most likely) for us to make the transition, I'll pay your hourly rate.

Let me know what you think.

Beceriler: Veritabanı Geliştirme

Daha fazlasını gör: work in promotions, who was the website developed by, who are freelancers in business, what works can get freelancers, what to learn for website development, what is vba programming, what is scratch programming, what is database programming, what can you do in freelancers, website to learn programming, website terminology, website promotions freelancers, website learn programming, website for sql freelancers, website development fees, website development expenses, web programming learn online, web for learn php programming, web development on cloud, web development learn online

İşveren Hakkında:
( 3 değerlendirme ) Pembroke, United States

Proje NO: #6973315

Bu iş için 7 freelancer ortalamada $120 teklif veriyor

Carterscubicle

Feel free to chat with me. I have some ideas you may like or can base other ideas off of. 2 brains are better than 1 :D

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
hemantaknayak

As mentioned amazon would be a great idea but only issue with amazon is its security. If you don't need that security then it will be open to the public anyone can access that. In my opinion you could try mysql from n Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
AlexandrK1

Предложение еще не подано

$333 USD in 30 gün içinde
(0 Değerlendirme)
0.0
ZTFreelancers

Hi There I have been in this industry for 11 years and has good experience of array of Technologies. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. Daha Fazla

$180 USD in 4 gün içinde
(0 Değerlendirme)
0.0
fazeelatmazhar

Sir/Madam, Greetings. This is an IT person , an experienced MS Access database developer and an experienced designer . I have tremendous expertise in VBA programming , macros , SQL queries in Access .Previously , I Daha Fazla

$75 USD in 0 gün içinde
(0 Değerlendirme)
0.0
cvanti

I think that a low cost solution could be to create a SQL Server db in the cloud server and to modify the Access application to use the remote tables instead of the local ones. If you could provide me the access app I Daha Fazla

$250 USD in 3 gün içinde
(0 Değerlendirme)
0.0
nycxav

Hi, I have a lot of experience with developing web based applications and modelling databases. If you want a solution that will be working from any web server in the cloud I would indeed recommend the use of a LAMP ( Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
amirkhm

Dear stackholder I think the easiest and simplest solution for your problem is "Microsoft Share Point"... it's completely well fitted to your business, especially as your are not an expert programmer and work with M Daha Fazla

$75 USD in 0 gün içinde
(0 Değerlendirme)
0.0