Speed problems using Access 2003 to modify an Access 2000 DB

[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

 

[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

 

[Norman Yuan]

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

 

[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

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.