BCullenward
Registered User.
- Local time
- Today, 05:27
- Joined
- Jul 6, 2005
- Messages
- 28
I am working on decreasing the loading times and increasing the efficiency of an over-inflated Access database that is on its last legs. The backbone table is well over 500,000 records and around 142 fields on the SQL Server backend, and the task is to make a local table with a single record from that 500,000+ records that is currently being worked on.
The problem is there are 50 forms and subforms all relating to this table, and any change to where the data source is causes all sorts of problems. When changing Recordsources referencing the large table to the local, single record table several forms break. Pop-ups jump up asking for values for textboxes on the form that normally work. When I change the Recordsource back to the main table the pop-ups continue, however, if I open a fresh copy prior to making any changes at all, everything works as it should.
Is there a reason why Access would respond this way? Any advice on how to handle a huge task of modifying everything to go from a linked table to a local table with a single record?
Your assistance is appreciated.
The problem is there are 50 forms and subforms all relating to this table, and any change to where the data source is causes all sorts of problems. When changing Recordsources referencing the large table to the local, single record table several forms break. Pop-ups jump up asking for values for textboxes on the form that normally work. When I change the Recordsource back to the main table the pop-ups continue, however, if I open a fresh copy prior to making any changes at all, everything works as it should.
Is there a reason why Access would respond this way? Any advice on how to handle a huge task of modifying everything to go from a linked table to a local table with a single record?
Your assistance is appreciated.
Last edited:
