CHAOSinACT
Registered User.
- Local time
- Today, 23:31
- Joined
- Mar 18, 2009
- Messages
- 235
this is a complex situation, so bare with me here...
we have a project management database, split in 2 (tables live on serve, front end on users pc's). we've decided to link this to the company MYOB info. there are 4 myob company files, we need to tally them ALL. direct linking is slow and unnecessary (updates to data every 24 hours do) so we delete and RE-IMPORT needed table every 24 hours to some other access files on server and import them into main as well (this gives me the change to rename tables, otherwise all come in with same names).
the main financial page, well, clearly it takes a while to load. right now i'm using a bunch(read: A LOT) of pre-saved queries and DSUM statements, then i add the DSUM results in vba and project to form.
can i speed up this process? is DSUM particularly slow?
we have a project management database, split in 2 (tables live on serve, front end on users pc's). we've decided to link this to the company MYOB info. there are 4 myob company files, we need to tally them ALL. direct linking is slow and unnecessary (updates to data every 24 hours do) so we delete and RE-IMPORT needed table every 24 hours to some other access files on server and import them into main as well (this gives me the change to rename tables, otherwise all come in with same names).
the main financial page, well, clearly it takes a while to load. right now i'm using a bunch(read: A LOT) of pre-saved queries and DSUM statements, then i add the DSUM results in vba and project to form.
can i speed up this process? is DSUM particularly slow?