I have a huge problem. I create a database in Access. The db is really big.
As far as I can remember Access have a limit (2gig) of data that can be stored. Is this correct?
If correct then I'm stuck. The data for register an asset, two different inspection and the planning for just one asset will take about 5mb, and there are over 9000 assets. The planning module for maintenance on these assets will also take up space.
This db is to be used over a long time to get information for future planning based on the inspections and trend of wear on the assets.
Is there a way to overcome this or is the a solution to convert to Java. My aim is also to have an App on a iPad where you can do inspections on site and enter the reading.
Is there an easy way out.
As far as I can remember Access have a limit (2gig) of data that can be stored. Is this correct?
If correct then I'm stuck. The data for register an asset, two different inspection and the planning for just one asset will take about 5mb, and there are over 9000 assets. The planning module for maintenance on these assets will also take up space.
This db is to be used over a long time to get information for future planning based on the inspections and trend of wear on the assets.
Is there a way to overcome this or is the a solution to convert to Java. My aim is also to have an App on a iPad where you can do inspections on site and enter the reading.
Is there an easy way out.