i have built a database with much help from the guys on here. we used it in one premises with the idea that when it is complete or near to completion(new ideas always come) we would use it at our other premises. the databases are not connected in anyway and are run as completely seperate databases.
we already have a database at the 2nd site so we are adding the last 3yrs of records to it. there is a lot of records and after getting about 1/4 of the way through i have received a system resource exceeded error. i am only getting this on the 2nd database and never had it on the first. the first has been live for aroung 1yr.
i am wondering if it is due to the amount of records. the largest is the tblOrdersItems(child to tblOrders).
the actual size of the database including the front end is only around 14mb after repair/compact so the size shouldnt be a problem.
i have added my largest tables in the attachment. maybe they should be structured better. as you can tell im not sure. the problem occurs when i am adding new records through the various forms.
another thing to add is that it doesnt happen all the time. when it does happen i close down the database, re-open and it works fine for a while.
could it be my desktop, need more ram etc. im running access 2010 on vista business. the desktop has 2gb ram and 2.6 dual core. its an oldish machine but it has served us well.
just to mention, there is a table that is nearly as large(or will be) as the tblOrders. the tblReceipts will have nearly as many records in time. all orders will have a receipt unless cancelled.
any suggestions
we already have a database at the 2nd site so we are adding the last 3yrs of records to it. there is a lot of records and after getting about 1/4 of the way through i have received a system resource exceeded error. i am only getting this on the 2nd database and never had it on the first. the first has been live for aroung 1yr.
i am wondering if it is due to the amount of records. the largest is the tblOrdersItems(child to tblOrders).
the actual size of the database including the front end is only around 14mb after repair/compact so the size shouldnt be a problem.
i have added my largest tables in the attachment. maybe they should be structured better. as you can tell im not sure. the problem occurs when i am adding new records through the various forms.
another thing to add is that it doesnt happen all the time. when it does happen i close down the database, re-open and it works fine for a while.
could it be my desktop, need more ram etc. im running access 2010 on vista business. the desktop has 2gb ram and 2.6 dual core. its an oldish machine but it has served us well.
just to mention, there is a table that is nearly as large(or will be) as the tblOrders. the tblReceipts will have nearly as many records in time. all orders will have a receipt unless cancelled.
any suggestions