Convert your ADP file to ACCDB
Our experts are here to help
Access ADP is no longer supported in Access, you will need to instead create a brand new Access file and import your Forms, Reports, Code and Queries.
See some great tips below on how to convert Access Data Projects to Regular Access, but if you rather we took care of this for you, just reach out to us at (773) 696 0593 or use our contact form for a great quote!
Here are some tips for converting Access Data Projects to Regular Access:
- Take a look at our getting started guide if you are new to optimizing Access with SQL Server.
- Create views when two or more tables are being used as form or report records sources, don´t let Access do the joins for you. If you want to use the views for editing data you will need to create an index and/or table triggers to handle delete, update, and inserts. This tip will allow you to speed up your database more than anything else you can do, aside from using stored procedures.
- Create local copies of tables that seldom change, for example: the list of 50 states.
- Don´t convert single table queries over to pass-through queries, it´s not going to be worth the time or the hassle.
- Consider converting multi-table queries over to pass-through or views.
- Optimize your form design and only load records you need. Do you really need users to see every order from the beginning of time when the form loads? Load only what you need.
- Do trick your users into thinking your app is faster than it was before. For example, in one of my apps, I was loading every customer record on a customer search form. I updated the code to not display any records until criteria were used for searching; the result? Users thought the search form loaded faster.
- Learn how to use stored procedures for complicated tasks and data manipulation best suited for the server.
- Consider using temporary tables to store SQL data.