Access to SQL Accounting system

I am a concrete contractor with over 200 Employees, I purchased a complete accounting system in 2002. I am a pretty good programmer in Access, very little vba. I will keep my access front end applications and re-link the data after it is migrated to sql. I already migrated other tables to sql, not in the accounting system, and they work fine. My main problem in trying to migrate the accounting tables myself is in properly establishing the relationships. The system consists of about 400 tables although most are temporary support tables that are then cleared during the posting process. I am including a screen shot of the relationships that can be expanded later.

Taidot: Microsoft Access, Microsoft SQL Server, SQL

Näytä lisää: how to change address in sql, sql accounting for gst, accounting sql, sql software, import data access sql, import data access sql script, conversion access sql, migrate access sql server, converting access sql server database, access sql report, access sql project, access sql filtern, biztalk access sql project, problem access sql update, access sql server convert vbnet, vbnet access sql datagrid, database access sql freelancer, consultant vancouver access sql, count access sql server, freelancer microsoft access sql

Tietoa työnantajasta:
( 0 arvostelua ) Atwater, United States

Projektin tunnus: #18191513

49 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi! Most of the programmers do not set relationships the way it is in Access, but it does not hurt to have them. So, as I understand, you have an Access backend (database) with Access frontend (user interface) an Lisää

$4444 USD 30 päivässä
(220 arvostelua)

Hi I have been working with MSSQL for over 18 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have Lisää

$3000 USD 30 päivässä
(76 arvostelua)

Hi, I have 11 years experience in development and worked on many Access and SQL Server-based applications. Migrated many access databases into SQL Server. Involve in designing databases, Indexing Strategies, tabl Lisää

$4444 USD 30 päivässä
(46 arvostelua)

Hi I was hesitating to make a bid for your project- too many bids, you'r new here etc. But as my experience shows, working with client who knows Ms Access ("a pretty good programmer in Access"") much more easy to Lisää

$4444 USD 30 päivässä
(44 arvostelua)

Hi, my name is Rodrigo, I have experience in SQL and VBA. Quick question though, have you considered a full migration to .NET as an option for this project? I think it is robust enough so you could develop this in .NET Lisää

$3888 USD 30 päivässä
(29 arvostelua)

Hi, I'm an expert Access / database / VBA programmer with *20 years* of programming experience in enterprises, and with domain knowledge in accounting. (I'm an MBA / University of Wales, UK). My offer is to: 1) Lisää

$3000 USD 21 päivässä
(52 arvostelua)

Hi there, I am interested in the project. I have over 12 years expertise in both access and SQL server, and I am sure I can deliver you the exact solution you are looking for. Please contact me through messenger for mo Lisää

$3888 USD 20 päivässä
(29 arvostelua)

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Lisää

$4000 USD 30 päivässä
(15 arvostelua)

Hi, my name is Mark. I have 20+ years of expertise with MS Access, VBA and SQL Server and will be happy to work on your project. I've designed, developed and maintained many Access applications using SQL Server. My Lisää

$3500 USD 21 päivässä
(11 arvostelua)

I have all the necessary experience to be the best fit for your project. I have plenty of experience as you will see below in both access and .NET SQL server solutions. I am also familiar with interfacing with accounti Lisää

$3000 USD 14 päivässä
(15 arvostelua)

I am ready to check and fix the establishing the relationships in tables. Highly experienced in VBA. I checked attached. I am able to create/Improve online database so that multiple users can access into db and keep tr Lisää

$5000 USD 40 päivässä
(7 arvostelua)

With my 9+ years of Software Development experience like to work on your project,Please consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF,Android Application,iOS Application, Visual Basic, Excel Lisää

$4000 USD 90 päivässä
(39 arvostelua)

hi, i have good skills in sql. i would like to migrate your tables to sql server. get in touch to discuss more.

$3000 USD 60 päivässä
(59 arvostelua)

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, Lisää

$4000 USD 30 päivässä
(14 arvostelua)

Hi, I think, you are thinking it all wrong. If you migrate to SQL, that means the access front end will not long be in working state and neither can it be linked. The right way is 1. Create equivalent SQL data Lisää

$4444 USD 30 päivässä
(3 arvostelua)

Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce Lisää

$3000 USD 30 päivässä
(29 arvostelua)

Hi, I can work with you to migrate and maintain the accounting system. I have over 9 years of SQL Server development experience. Let me know when I can start?

$3000 USD 30 päivässä
(26 arvostelua)

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert Lisää

$3333 USD 15 päivässä
(31 arvostelua)

Hi, I am a professional MS Access and SQL database developer with 7 years of corporate experience. I can give you best support on this project. I created and managing access databases which have SQL server, MySQL, sh Lisää

$3000 USD 10 päivässä
(16 arvostelua)

Hi there - I'm Aly, I've seen your post and I'm interested. I've had much experience in Microsoft SQL Server including appropriately creating and managing tables and the relations between them. 400 tables is quite a n Lisää

$3000 USD 30 päivässä
(10 arvostelua)