running batch files

[Guest]

i have a problem with a program running alot of batches. it is a payroll
program. the database is about 1.9 megs big and it is updated everyday. i
have had problems with acces before in another program when u run a batch it
takes for ever to run the batch sometimes up too 16 hours for one batch. i
only have this problem when the database get big. over 5000 records. there is
alot of information that has to be collected. is acces the best program for
this as a databse. or is the another program or design mode that is better. I
have heard that a SQL databse is better can someone help me with this
problem. I am truoble shooting this program from the outside right now. the
It dept. does not want anyone to see there programing. i wil soon have the
code to look at. but from just what i see is access not the correct databse
for this program

Thanks

 

[Pieter Wijnen]

5000 records is not big....
probably the coding and or tabledesign *sucks*
you should start of with reviewing the indexes on the tables
also rewrite any macros into VBA code, make sure data is fetched only once
(if possible)
I once rewrote a report that took 8 hrs to run (including table redesign) to
make it run in 30 secconds due to bad design

pieter

 

[Guest]

thxs peter it might help. but it is a big corporation. the It guys will not
want to hear this that there programing skills *SUCK*. is there a limit on
the amount of records?
once i see how they have written the program if that ever happens??? they
are real paronoid about an outsider geting into their stuff. but is a sql
databse better??