Hey guys!
At first let me point out that I am not an Access expert so this may be a ridiculous question to some of you. Here is a thing ... we've got a software that is creating a mdb file with one table and 10 columns. Every day we have around 30.000 entries in the table. At the end of the week we have 7 different mdb files and usually we copy/paste them into one single file to do the base research. Everything is fine until the mdb's file size is 2GB. I understand that mdb files start behaving strange with files over 2GB of size. Therefore after a couple of months we have several 2GB mdb files. When doing a history research we have to open each and every file to check and search in that file. That can take a lot of time if you have 20 or more mdb files.
What I am asking is ... if there is a possibility to merge all the 2GB files into one or maybe more so that the research wouldn't take so much time. As I said ... I am not an expert with Access. I know my way around with the computers but this is a complete mystery to me so all of your answers are welcome.
Thank you.
BR
S.