Access to slow after upsizing to sql 2000

F

Frank

Hi

I just upsized my access to sql 2000 and it is very slow.
Is there a reason when I open a form, report etc. access
is very slow?

Thanks
Frank
 
J

Joe Fallon

LOTS of reasons!
Architecture is one of them.
Did you re-architect your app to be SQL Server specific or did you assume it
would just work?

There are whole books on this subject.
Try Mary Chipman's.

Also check out Tony Toews' website for some tips.

http://www.granite.ab.ca/accsmstr.htm
 

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

Similar Threads

mde upsizing to SQL Server 3
Access and sql server 2008 3
Application.HyperLink vs controlname.HyperlinkAddress 4
Upsizing ACC 97 to SQL 2000 1
EMPTY TABLE AFTER UPSIZING TO SQL 4
Trouble upsizing Access to SQL 5
MS Access Query criteria Problem 2
SQL upsize 2 databases 2

Top