Find Jobs
Hire Freelancers

Access database in the cloud?

$30-250 USD

已关闭
已发布超过 9 年前

$30-250 USD

货到付款
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.
项目 ID: 6973315

关于此项目

7提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
7威客以平均价$120 USD来参与此工作竞价
用户头像
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
$75 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 normal website hosting site. It is easy to use with great feature.
$111 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Предложение еще не подано
$333 USD 在30天之内
0.0 (0条评论)
0.0
0.0
用户头像
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. I can assure you that if you work with me once, you will always work with me for these kind of projects. I want to assure you that your project will be delivered with highest quality and will get undivided attention. You can trust me with your project. I would suggest to do a Skype call to understand more about your requirement. If you want to go away from the Server where MS Access is running what about VBA application, do you want to migrate that too into Cloud. We are specialist Amazon Web services we can defiantly find a solution for this problem. We are team of IT professionals from company called Zehntech Technologies. Your job description attracted our attention because it is compatible with our freelancing interest and broader technical skills i.e. Java, Spring MVC, Data modeling, PHP , System design and testing. We hope to hear from you soon so we can start working on this project as soon as possible. Our Services • Enterprise Application design /development/enhancement/maintenance • Data modeling and database design • Java / Spring/Vaadin • SQL / PLSQL • UI/UX design and development • AngularJS / JQuery / Charting • PHP application Development • Amazon Web Services (AWS) Requirement analysis / Architecture Review / Deployment
$180 USD 在4天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 could check if this is possible with your app. Rewriting the application (with PHP or with any other language) has a much higher cost (even if it's better solution).
$250 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 (Linux, Apache, MySQL, PHP) solution. There are a number of widely used CCK (Content construction kits) that will allow you to develop applications. Drupal comes to mind but Drupal has a pretty steep learning curve. I would therefore suggest instead a combination of Joomla and Seblod. Seblod is a free CCK extension for Joomla. So the whole setup is free and can be hosted easily on cheap hosting servers and though it's php based it doesn't require any php coding, only configuration for most features. For low level customization a bit of php can help but you can learn that at a later point. I have a lot of experience with Seblod and Joomla and will be able to assist you while you learn. We can discuss the conditions. Seblod will allow you to develop forms but also customized searches and customized lists with calculation for your reporting. Do not hesitate to contact me if you have any questions. I'm also US based which could make communication easier. I ahve developed a numbe rof projects on freelancer.com I don't know why I appear as "New" I suggest you read my reviews. I look forward to hearing from you and help you develop your database. Regards. Xav.
$75 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Pembroke, United States
5.0
3
付款方式已验证
会员自7月 20, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。