Problem in MS Access data update

[vinwin06]

Hi All,



I have a database it contains data more than 4 million line items but while i try to run macro or any query the database reaches the maximum limit of 2 gb , then the particular query not functioning and then i need to compact and repair. After compact and repair also the same issue is continuing....

Kindly help me in solving this issue else tell me some other solution to eliminate this issue and resolve it.

Regards,

Vinoth S

[alansidman]

Put the tables in a separate db and link them to your current db. This might give you some breathing room.

Alan