Access2003 too slow.

[Frank Martin]

I have upgraded from Access2000 to Access2003
by creating a new empty database in
Access2003 and then importing all the objects
(via the wizard) from the old Access2000.

Was this the correct method? If not is
there a better method, and can other
adjustments or tweaks be made to improve the
performance?

An example of a slower part is the
programming of a pop-up zoom box from a text
field using the code "DoCmd.RunCommand
acCmdZoomBox" in the "on enter" property of
the text box. Although this pop-up begins
normally it takes about 10 seconds to
disappear when the "OK" button is pressed,
though this occurs only when Access is used
the first time for the day, and it behaves
OK thereafter.

Please help, Frank

 

[John Vinson]

I have upgraded from Access2000 to Access2003
by creating a new empty database in
Access2003 and then importing all the objects
(via the wizard) from the old Access2000.

Was this the correct method?

Well, it will work - but it's a bit like hand-carrying individual
boxes rather than using a handcart.

You can open an A2000 database in 2003. In fact, if you create a new
database in 2003, it defaults to using 2000 format. Just open it and
use it!

If not is
there a better method, and can other
adjustments or tweaks be made to improve the
performance?

Compact the database after you import; be sure your tables are
correctly indexed; TURN OFF name autocorrect and all of your
Subdatasheets in table properties.

An example of a slower part is the
programming of a pop-up zoom box from a text
field using the code "DoCmd.RunCommand
acCmdZoomBox" in the "on enter" property of
the text box. Although this pop-up begins
normally it takes about 10 seconds to
disappear when the "OK" button is pressed,
though this occurs only when Access is used
the first time for the day, and it behaves
OK thereafter.

Hrm. Not familiar with that phenomenon!

John W. Vinson[MVP]

 

[dbahooker]

if mdb is too slow then use a real database like SQL Server

 

[Terry Kreft]

From this and other posts I suspect you're just a troll, but there is the
possibilty that you're actually incompetent and prefer to blame the tool.

You really, with each and every post you make, show the true depths of your
ignorance.