Hey everyone...so I have a huge, growing single source Excel database where new jobs are added. Every time I try to link or add the table to MS Access, it starts crashing. Sometimes I can get the table to save but when I try to do a Dlookup or pull data from that Table into a form, MS Access Locks up. Therefore, I am wondering if I can pull only a few columns from the Excel Database since I only use 5% of the total data.
For example, Project vs Project Manager. In the Access Form, I want the user to type in the "Job Number"(or drop down list of active "Job Numbers" via the Excel Database). Then the form should automatically display Project Manager, Customer Name, etc.
Secondary option:
My assumption is I need to link the Excel, then query the linked table. Is there a better way? In the Form, could I query and Dlookup directly to the excel network link?
thank you!