Access 2007 migration to sql server
Posted on 2011-04-28
I have a split database(front end/back end), i just upsized it sql server.
everything is working fine, but it seems to be slower, when it tries to open forms it takes a while to load the data, i thought it was going to be faster.
do i have to do anything to improve the performance?
do i have to recreate all the relationships in sql, are the relationships migrated directly?
I am doing a test and runing everything from a windows 7 professional 32 bit workstation.
please elt me know