Hi, I could use some help. I have several databases with one table in each database that holds over 3-4 million records. I still enjoy the ability of using access for my forms. queries etc, but having multiple databases due to one large table in each is causing a headache. I have to constantly relink that one table every time a new month goes by. Does anyone have suggestions on something that can hold a lot of records for one given table? I tried SQLDB, however when I tried to append the next month's table it is slow as heck.
Also, I have a table called "maindata" which has over 3-4 million records which is the monthly records I need to query on. However, I have the same table name for each separate DB due to the 2 gig limit. Is there a way to link these databases by the same table name so I can run my frontend query to capture all of these months instead of performing separate queries in each database?
Thanks