i have access database that is 1.5 gb and I want to split it up somewhow.
I have read somebody say they split their database and create a blank one and then link from the blank one.
my problem is the database is primarily used to enter a serial number and have alot of different history data displayed back.
If I split it by years- then is there anyway to have user still enter serial number once to search. And not even know they are searching two databases?
thank you- or any other suggestions-