Speed problems using Access 2003 to modify an Access 2000 DB

K

Kevin.Hine

Hello,
My split Access 2000 db is running fine, however, when i try to make any
modifications to the front end especially adding/changing forms using
Access 2003, it's painfully slow. Is anyone aware of a problem ? The back
end resides on a Windows 2003 server and the front end development version
is running Access 2003 on XP sp2. My PC is otherwise running fine.

Any help would be appreciated.
Regards
Kevin Hine
 
A

aaron.kempf

yes, screw MDB use MSDE with Access Data Projects

MDB rocks-- but when you need serious performance do Access Data
Projects-- MSDE is free with the Access license; so you might as well..
right?

btw, you need 10x more detail for us to help you

what kinda tables you linking to?

-Aaron
 
N

Norman Yuan

Is the front end sitting on your computer locally? Is the front end in
Access200 or 2003 format?
 
D

Dirk Goldgar

Hello,
My split Access 2000 db is running fine, however, when i try to make
any modifications to the front end especially adding/changing forms
using Access 2003, it's painfully slow. Is anyone aware of a problem
? The back end resides on a Windows 2003 server and the front end
development version is running Access 2003 on XP sp2. My PC is
otherwise running fine.

Any help would be appreciated.
Regards
Kevin Hine
Click to expand...

One thing to check is that the Name AutoCorrect option is turned off,
unless you think you really need it. Tools -> Options ..., General tab,
uncheck all the Name AutoCorrect boxes.
 
Top