I have used SSMA to migrate Access97 tables to sql server2005 and link them. After I have migrated the access97 front end containing forms has become much slower in executing queries. Can you suggest some tips to make it faster.. Any help is appreciated.
Hi, Thankyou for the offer of help, much appreciated. The db zipped is 1.34MB and I cannot attach to the forum. Do you have a workaround, i.e. another e-mail address that I can send to that will allow over 1MB? Many thanks