Closed

Microsoft Access tables and queries to SQL Server

I have an Access database with tables, queries, forms (with vba code sometimes) and reports.

This database now is sepparated by 2 access files. One with tables, and other with all rest, because we need to work some persons with this database.

But some tables are very big, and queries sometimes are slow to load. Now only one person work on database but we think that later, with more persons, will be difficult.

so we thought to put the tables and queries on a MS SQL Server.

We only will pay if finally all will work like now, without errors. So, we can't pay before work completed.

.

Skills: Database Programming, Microsoft Access, Microsoft SQL Server, SQL, Visual Basic

See more: ms access link to sql server without odbc, access frontend sql server backend, import data from access to sql server, connect access 2016 to sql server, query access database from sql server, link sql server to access, ms access odbc connection to sql server, connect to access database from sql server management studio, MICROSOFT SQL SERVER 2012 DATABASE ADMINISTRATION , ikm assessment microsoft sql server 2008 database administration, ikm microsoft sql server 2008 database administration, open sql server 2008 database access 2007 vba, convert access project net sql server, access vab query sql server, access update recordset sql server

About the Employer:
( 24 reviews ) El Vendrell, Spain

Project ID: #17007274

49 freelancers are bidding on average $508 for this job

fabest

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 ser More

$277 USD in 10 days
(81 Reviews)
7.3
lukaszoz

Hello, I'm a developer with over 5 years of experience and work as a regular .Net developer on daily basics. I work with technology like : 1) Access and whole office stack (Excel, Word, Outlook) in terms of V More

$250 USD in 10 days
(30 Reviews)
6.9
branislavm

Hi! Basically, someone needs to upsize the database from Access to SQL Server. It can be a simple thing to do, or very tricky, it all depends on the queries (queries itself, as form and report source). Sometimes sto More

$555 USD in 10 days
(217 Reviews)
7.0
schoudhary1553

Hi there..... Warm Greetings We came along with your request for Microsoft Access tables and queries to SQL Server and we reviewed your project description. We'd like to help you with confidence and satisfying re More

$600 USD in 7 days
(110 Reviews)
7.0
liangjongai

I am a full time developer and have high skills in mssql, access, and sql query so I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.

$555 USD in 10 days
(138 Reviews)
6.8
aanvikm

Hello Sir, I see the project posting and I can understand your concern. Its usually because we don't see the overall scope of the project and end up finding for a cheap and quick solution. Access does not support a la More

$833 USD in 10 days
(49 Reviews)
6.4
mpalgeo

Hi there. I have done projects like that in the past with great success. I will move all the tables to the SQL db and convert the existing queries to views. I will also make and an assessment for performance tunning. More

$500 USD in 20 days
(73 Reviews)
6.2
workerbee1974

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 can send working samples on request. Som More

$722 USD in 10 days
(31 Reviews)
6.2
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

$400 USD in 14 days
(96 Reviews)
6.1
$500 USD in 7 days
(28 Reviews)
5.8
havit

I am interested in moving your back-end file to MS-SQL and update necessary on your front-end MS-Access file. I have done it before this kind of project. Please share the database for review. Thank you.

$750 USD in 10 days
(9 Reviews)
5.5
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you with More

$400 USD in 5 days
(63 Reviews)
5.6
zu02

Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'm programmer/mathematician since 197 More

$750 USD in 10 days
(50 Reviews)
6.2
robnicholson

Hello, I have worked with Access for over 10 years. I have done many Access to SQL Server migrations (backend SQL frontend Access) so I have a good grip on changing Access objects and modifying VBA. If you have any que More

$350 USD in 5 days
(21 Reviews)
5.5
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$555 USD in 10 days
(29 Reviews)
5.1
slimbyte

Hi there, I have great experience with MSAccess connecting to MS SQL Server, and of course migrating your access database to MS SQL. I agree that the pay should be made once your app works as expected. If yo More

$750 USD in 14 days
(24 Reviews)
5.2
lavizsolutions

Hi, tables and sql queries i can move but what about front end? Please check my below work.. 1. Case Management system. [login to view URL] you can create activity, can vi More

$555 USD in 10 days
(3 Reviews)
5.0
Agiletechstudio

Hi, there i read your initial requirements and i have some question regarding to your access and sql [login to view URL] can we discuss it on chat ?

$250 USD in 10 days
(13 Reviews)
4.5
SergioAlfaroV

Hola! Soy un Ingeniero Informático, con un Máster en Administración y múltiples certificaciones Microsoft, siendo la más reciente el MCSA SQL Server 2014, con más de 10 años de experiencia en SQL Server, diseño y const More

$600 USD in 10 days
(8 Reviews)
4.4
RameshMarand

Hello, I have read the project description and I understood that you have access database with 2 files having tables,queries and you need to convert it to Ms Sql server. We can help you with this project but can More

$744 USD in 5 days
(3 Reviews)
4.2