I have access loaded on our network and thought I might put the static lookup tables in one database and the transaction tables in another.
This doesn't appear to work. Is this possible? Is there a special way to link? Is it probably a network thing? or am I out of luck.
any information would be appreciated.