Tech Off Post

Single Post Permalink

View Thread: Access Database
  • User profile image
    lensman

    Relationships have nothing to do with the sheer number of connections to a database. 

    I am familiar with the basics of database design.  I know when indexes are required, how to tune queries and such. If you are relying upon the "relationship" tool within access to optimize your database you are missing a lot of performance. 

    If you are going to be migrating your application into a pure SQL database with an Access front end then get completely out of Access (data wise) and forget the toys.