This may sound crazy, I've gotten a few horrified looks when explaining it to others before, but here's the setup right now:
We have A a group of desktops dedicated to running reports all day, using a bunch of Access DBs (over 100) that currently reside on a file server (so the server holds the file, but the PCs do all the work). The desktops use the scheduler to activate the DBs and the DBs use an "autoexec" macro and VBA Modules to run the reports/processes in them (some have multiple reports & processes, some have just one). The desktops take roughly 6 hours to complete the processing each day.
The project I'm trying to write up is to move all of it to a single server, hopefully to save time and definitely to free up the desktops for use.
Here's what I'm trying to establish: What kind of server We can look into getting so that We could just move the DBs from the PCs to the server, schedule a run-time on the server, and it will run them like normal (but faster)? Any idea of the "specs" that would be enough? I wish I could be more specific, but I do software, not hardware, and every time I ask anyone from the IT Dept they respond with "1st of all, stop using Access!" and it goes downhill from there...