Hello,
I'm a lifelong access user and I am going to build the dream access desktop (if you could call it that). I'm hoping to get some advice on the ideal setup (both software and hardware) to support a single use reporting database with a lot of data.
I love access for it's flexibility and ease of use however i have to continuously compact my db and move files around just to produce a weekly report. This past week, the report was so complex that i had to run it in four chunks.
I thought i read somewhere that access 64 bit does not have a cap of 2 gigs but i'll believe it when i see it.
thank you!