Slow Jet Data Access - migrate to SQL

M

May

You may need to review the codes that you write.
One very important thing is to ***INDEX*** the Join
Primary and Foriegn Key, and the fields that you use the
most to search. Indexing in a hugh database or too many
could really help and you may see the difference.

May
MCP in Access and SQL Server
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top