I currently have a table in my database that was originally an excel spreadsheet and contained person data. This was fine originally and my database was built around it so it is the record course for a few forms/reports.
This table is now constantly out of data, the 'live' version of this table is held as a report in an external database (unite). I need to keep this table live and i do not have the option of calling it thru a pass thru query (from the unite database) as these queries cannot be record sources for forms/queries. Any ideas?