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

Default local file location - folder redirection slowness 0
Cell data entering slow! 0
Word 2016 opening sooo slow 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Access and sql server 2008 3
Application.HyperLink vs controlname.HyperlinkAddress 4
mde upsizing to SQL Server 3
Query Parameters error of the Upsized database 0

Top