Convert MS Access queries to MS SQL views
Budget: $8 – $15 USD
Hi, I have a complex MS Access system with a lot of queries in forms, subforms, dropdowns etc. The system started as a pure MS Access-system, but then I have migrated the database-part to a MS SQL Server.
I need someone to do the job of going through each form and report and migrate the form/report recordsource to a view on the MS SQL server.
Indexing of views connected from MS SQL to MS Access is very important. You must therefore also add all connected views to a "reindex"-procedure in MS Access so it is easy to run after re-connecting all objects. If not the job of reconnecting will be very time consuming because you need to mark what fields make a unique record for that view to be editable.
The job is so that it is impossible to estimate exactly how many hours you will use, but we have estimated it to be between 70-110 hours work.
It is a bit routine job and if you need some learning I will provide, but of course then your rate should also be lower.
I need someone to do the job of going through each form and report and migrate the form/report recordsource to a view on the MS SQL server.
Indexing of views connected from MS SQL to MS Access is very important. You must therefore also add all connected views to a "reindex"-procedure in MS Access so it is easy to run after re-connecting all objects. If not the job of reconnecting will be very time consuming because you need to mark what fields make a unique record for that view to be editable.
The job is so that it is impossible to estimate exactly how many hours you will use, but we have estimated it to be between 70-110 hours work.
It is a bit routine job and if you need some learning I will provide, but of course then your rate should also be lower.