Find Jobs
Hire Freelancers

Access Database Help

$250-750 USD

Closed
Posted almost 6 years ago

$250-750 USD

Paid on delivery
We use an Access Database for a Customer Relationship Management system. Since my coworkers are in separate offices, we use Dropbox to synchronize our files. One flaw with Dropbox is that if more than one person enter an Access Database, it creates conflicted versions rather than allowing both people to make the edits. One solution that I have is to split the database where one database copies the tables from a separate master and then periodically updates the master database. This would allow Dropbox to periodically sync without creating conflicted versions. My firm also has SharePoint, so there might be other options. I'm looking for someone to devise and implement a solution that allows multiple users. There are also other improvements/issues that I'd like to have addressed as well.
Project ID: 16902958

About the project

34 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
34 freelancers are bidding on average $527 USD for this job
User Avatar
Hi, there. My name's Paris Pallas and I'm a very experienced and skilled Access developer. Having completed successfully over 220 projects in a 5-year period I'm very confident that I can help you with your project. Feel free to visit my portfolio on this platform and get an idea of my work quality standards and professionalism. I get that you're interested in having your database used simultaneously by multiple users. The safest and more robust way to do this is by splitting your database in Front-end and Back-end parts. You'll have your back-end in shared drive and front-parts delivered to your users that will have access to the shared drive This way all changes done by either user will update the central back-end database in real-time. This is something I've done several times in the past successfully. I'd like to talk with you further about the details. Please let me know when you're available. Paris
$500 USD in 7 days
5.0 (264 reviews)
7.8
7.8
User Avatar
Hi! This is not a good idea, to share Access database that way. Have you thought about implementing a free version of SQL Server which will server as backend database? Regards, Branislav Mihaljev
$555 USD in 10 days
5.0 (311 reviews)
7.9
7.9
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$277 USD in 10 days
4.8 (83 reviews)
7.4
7.4
User Avatar
Hello Sir, I am an expert in MSACCESS and would like to discuss this project with you. May I please request you to open chat and discuss my approach. Thanks Aanvik
$555 USD in 10 days
5.0 (47 reviews)
6.6
6.6
User Avatar
I am willing to adjust my bid with more details on your change and upgrade needs. The best solution in my opinion, is for your database to be linked to your the sharepoint. You can Google the solution of how. As to the changes and upgrades needed. I would love to assist you. My passion is building Custom Access Databases. I have built well over 300 custom databases in the past 19 years. I have taken all classes from beginner to expert 97 to 2013. I have screen shot samples and more reviews at I can send working samples on request. Some of the databases I have built include Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. What you get if you allow me to do your project. The Database to your vision. I will create the database and continue to change upon your input until it is what you in vision. I will offer lifetime support for the database; I will give all my contact information if chosen to complete your Project. I if there are any bugs or issues to the original Database I will fix free of charge. Thank you for your time.
$777 USD in 30 days
4.8 (42 reviews)
6.7
6.7
User Avatar
Hello, I can help with you in your project Access Database Help. I have more than 5 years of experience in Database Administration, Database Programming, Microsoft Access. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$500 USD in 6 days
4.9 (41 reviews)
6.4
6.4
User Avatar
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Access project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$555 USD in 10 days
4.7 (74 reviews)
6.5
6.5
User Avatar
SHOWCASE I have done a similar Access projects before with 5* ratings: https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ https://www.freelancer.com/projects/database-programming/Convert-data-Word-table-Access/ https://www.freelancer.com/projects/database-programming/data-base-search-options/ I can also produce a sketched prototype for this project and upload on YouTube. INTRODUCTION I am an experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple projects.
$377 USD in 15 days
4.8 (30 reviews)
6.3
6.3
User Avatar
Hi, I am a professional MS Access and SQL database developer with 5 years of corporate experience. I can solve your issue and provide you an excellent database to fulfill your requirements. As you mentioned about conflict issue. yes, you are right. you need to cteate a split database to enable multiple user process. So that the backend can be kept to your shared network drive and multiple front end will connect with the same backend. I will add auto relinking process to connect your backend automatically. Also I can create the SharePoint backend. If you want I can show you some of my completed projects live so that you can get a clear picture about my knowledge and experience after that you can decide to hire me or not.
$400 USD in 7 days
4.9 (40 reviews)
5.8
5.8
User Avatar
Hi, I think the best would create a simple ASP.NET MVC web application where user can login from different location and can work with the same data. Please share me MS-Access file and I will review I can replicate the functionality on ASP.NET or not. Thank you. Regards, Shiv
$750 USD in 15 days
5.0 (12 reviews)
5.6
5.6
User Avatar
Hi sir, I am interested in your project and offer my services. I have solid experience in projects like you and can help you out. Believe me I've worked on this issue before to share Access database between users and... If your coworkers on the same network then we can use database replication to avoid conflicts and if database is being accessed from other locations then best option is to put the main database on an online server and use ASP or PHP to create a web interface to be used by multiple users. Please feel free to contact for further discussion and you can see my freelancer project for reference. Looking Forward, nblsoft
$555 USD in 10 days
5.0 (12 reviews)
4.9
4.9
User Avatar
HI there Thanks for using our website freelancer com. I am a senior software developer with +10 years of experience using Microsoft technology. My main framework is .NET, which is standard for Microsoft desktop and web solutions. By using .NET framework objects we can use a library within that enables to syncronize databases, provided that your workstations hosting Microsoft Access have internet access, which seems they do after using Dropbox. So please get in touch for discussing further, I would need to know details on your database, number of tables, how they are related, and we can come up with a design, solution to implemente programmatically, and exact quote. Looking forward, best. Serge
$555 USD in 10 days
4.9 (4 reviews)
4.7
4.7
User Avatar
EXPERIENCED DEVELOPER... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quickly. Just notice that my SQL Level 3 badge makes me one of the TOP SQL freelancers around...
$555 USD in 10 days
5.0 (11 reviews)
4.5
4.5
User Avatar
Hi. I can help you with database! As for me, I'm a professional system admin with 10+ years of experience. My main specialization is LAMP stack of technologies (Linux, Apache, MySQL, PHP) but also I have experience with Python, Node.js and .NET stack of technologies too. I have a deep experience with different PHP Frameworks such as Zend Framework, Symfony, Laravel, Yii, CodeIgniter, CakePHP as well as different open source solutions e.g. Magento Ecommerce platform, WordPress, Drupal, etc. I was working as a senior system admin at hosting services provider where managed and configured more than 300 various Linux/Windows servers. I can help you too. Please, send me the list of your requirements!
$555 USD in 10 days
5.0 (5 reviews)
4.4
4.4
User Avatar
Hi, without knowing all of the details about the network and network connections I do believe that the sharepoint option will be the easier route to follow. You can do some upscaling of databases to MS Sharepoint and link the frontend directly to the data on sharepoint. The advantage of this is that the database will still function even without an internet connection. As soon as a connection becomes available, the data automatically syncs up again cutting out the whole process of sharing files via dropbox or any other sharing service. As mentioned, I don't know all of the details, but would really be interested in working this project with you. I have done similar jobs with access and sharepoint before, so I know they are doable and reliable. The database will be 'split' into a frontend and a backend. Basically taking the user interface and separating it from the data, ms access can actually do this by itself. Once the data has been split, the backend data gets loaded onto sharepoint, and linked back to the frontend. If the process is done correctly, then no other changes to structures etc would be required. (Highly dependant on the complexity of the database though) I have worked on marketing databases like this before. If you want to 'merge' the data again at a later stage, or migrate it to an even bigger platform like MySQL or SQL then the data is downloaded from the sharepoint site, merged or migrated to the new system and relinked. Let me know what you think.
$400 USD in 10 days
5.0 (1 review)
2.6
2.6
User Avatar
Hi, At first, please let me briefly introduce myself. I have bachelor's degree of Information Technology Engineering (Software Engineering concentration). I passed many skill exams and got skill certifications that show as badges in my bid. For more information and to read the good reviews I got for my previous work, please visit my profile. I have carefully read and understood your problem, I suggest building a brand new web-based system and moving your data over. I promise to go beyond your expectations by discussing every detail and suggesting enhancements and better solutions. Please note that the completion time in my bid is greater than the actual time that I need to complete your project. I put some extra time in order for both of us to discuss and/or test the product of various stages of development. This way you will have enough time before happily paying. I guarantee 100% satisfaction and offer a warranty for all of my clients to fix any bugs or solve any problems after the project is totally completed for two weeks. We can stay in touch through the freelancer chat feature throughout the day as I will be online most of the time while working. Additionally, I have the freelancer app on my mobile phone, so you can leave me messages too. Awaiting your response to start discussing more details of your project. Sincerely Yours, Tarek Y.
$500 USD in 15 days
5.0 (4 reviews)
2.7
2.7
User Avatar
Does your other locations always use internet? Then why dont we develop a new web-application in windows server using c# asp.net and MS-SQL? Please share a sample access database so I can estimate properly.
$250 USD in 7 days
5.0 (1 review)
2.2
2.2
User Avatar
Hello there .. I will make sure to deliver the project successfully ,.. i have a wide experience including but not limited to the required skills
$555 USD in 10 days
5.0 (1 review)
2.0
2.0
User Avatar
Hey, I am Microsoft certified developer and have 15+ years of experience working with Microsoft and Sandisk in US. I can develop, integrate, customize & migrate your SharePoint portal. I can complete your work with your deadline. I'd like to discuss more in real-time chatting. waiting for your precious reply.
$700 USD in 10 days
4.0 (1 review)
2.0
2.0
User Avatar
More than 25 years on the field of the development of software, and over the manager of databases. so, what could be difficult?
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cleveland, United States
5.0
46
Payment method verified
Member since Dec 6, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.