I have an Access 2003 database that each day creates links to four other databases, several tabbles in each, updates data and then closes the links. However, I am crashing often and it will not let me open the module with the code for the procedure. Someone told me that the space Access 2003 uses to process is not enough, and I received an Online Crash Analsyis from Microsoft that indicated I some patch was needed. Problem is that I work for a large corporation and all updates are centralized and they will not do it just for me.
So, which is better? A macro that calls a series of queries or a procedure that calls a series of queries. What I have right now is everything in modules, Dims, SLQ statements, do commands, linking, deleting objects, etc. I did it this way beause there are several users who like to "play" and I have had queries changed. I cannot input passwords since using code to create links assumes no passwords and I do not know how to get around this.
Also, I was thinking of use DTS that processes outside of Access. I really am looking for some opinions as this whole process is due soon and I am stymied as to which direction. I do not know enought about DTS, but if this is the best solution, I can sure learn it fast.
Any suggestions would be helpful.