I have an access 2003 split database which I have added an ODBC linked table into the design master. I know this won't replicate onto any replicas in the set. However I really need this table to appear on the replica databases so users can access the data whilst on site working offline.
I want to try and avoid copying the table every night as it currently has 1.5 million rows and is added to daily (it's an ORACLE database table with over 150 users).
Anyone have any work arounds for this?
edit: whenever I run any query against that table it prompts for a username and password so really needs network access to run.
I want to try and avoid copying the table every night as it currently has 1.5 million rows and is added to daily (it's an ORACLE database table with over 150 users).
Anyone have any work arounds for this?
edit: whenever I run any query against that table it prompts for a username and password so really needs network access to run.
Last edited:
