Very Slow Performance

P

Paul

I am currently constructing my database, which at present has around 40
tables and 20 forms, no reports or queries yet. But it seems to be taking an
age to do anything. I try and save it and it takes up to 30 seconds if not
longer and sometimes ends up not responding and closing Access. I work on it
at 3 dif locations where I work copy and paste to my usb storage chip and
take home where overwrite my old file with the new one and carry on working
and vice versa when I go to work. Its getting to a stage now that it
seriousley affects the efficiency of my work as i do some work and waste time
waiting for saves and the like. Opening the forms when browsing through the
navigation of the database isnt too bad. I do compact my database on regular
occasions!! Any Ideas....Also the developers toolkit seems to be as rare as
rocking horse sh*t, cant find cost or suppliers anywhere, and as a person who
does databse developing as a hobby rather than business no one seems to want
to supply it, so 1, where can I get it and 2, How much will it cost?

Your help would be appreciated.

Paul
 
S

Sylvain Lafontaine

If you are using Access 2000, then replace it with Access 2003 and use the
latest format (A2003) for the MDB files to have the best performance.
 
A

aaron.kempf

run the DB performance wizard
and dont run access across the network unless you really really must.

how many records do you have?

-Aaron
 
C

Craig Alexander Morrison

No queries!

When you talk about saving do you mean saving your forms, do you have Name
AutoCorrect on, if so switch off Track Name AutoCorrect on the Tools,
Options, General Tab. Make sure none of the tables have fields with lookups.

Split the application from the database: tables in database all other
objects (forms, reports, queries etc) in application. I am assuming you are
using a single MDB at present you should use two.

Upgrade from 2000 if that is what you have, 2003 SP1 is the current version.

You only NEED developer tools if you are distributing a runtime version of
your system, 2003 tools are in the Visual Tools product sorry don't know
cost, MSDN Universal Subscriprion includes this. Use the /runtime command
line switch to test your compiled application (MDE) in that mode.
 
C

Craig Alexander Morrison

Oh yeah, set subdatasheets to [none] in table properties for all tables.
 
P

Paul

Yes when saving forms, thats when it goes slow. You'll have to bear with me
as Im not a programmer but a Personal Trainer trying to create some bespoke
software for my team. What do I do to split the DB and how does that operate,
and yes I am only using 1 MDB at present.
Also many thanks for previous suggestions!!

Paul
 
Top