Hi! I've set up a database which has linked spreadsheets as an initial data source (the dbase pulls in certain records only). It seems to work fine except once in a while I will receive a message "System Resources Exceeded" when I try to query the spreadsheet and/or view it through the table. Are there any suggestions?
Also, Access 'marks' records in Excel that it pulls (just updates a field to have "y" in it). Once Access does that, I can no longer view the table through excel -- if I try to open it in Excel, I get a Dr. Watson error consistently. If anyone could point me in the right direction on these 2 items, I would greatly appreciate it!! The structure of the dbase is pretty simple (and works), but these type of issues are perplexing and I would love to understand exactly what's going on. Thanks in advance for you advice!
Also, Access 'marks' records in Excel that it pulls (just updates a field to have "y" in it). Once Access does that, I can no longer view the table through excel -- if I try to open it in Excel, I get a Dr. Watson error consistently. If anyone could point me in the right direction on these 2 items, I would greatly appreciate it!! The structure of the dbase is pretty simple (and works), but these type of issues are perplexing and I would love to understand exactly what's going on. Thanks in advance for you advice!