Andy_28 said:
Does anyone know how to link to Access Tabels that are located in secure
databases?
You cannot link to a table in a secured file unless you are currently running
under a workgroup that allowed you to log into Access as a user that has
permissions to those tables. That's why they call it "security".
Now, there are many times when you would be able to do this simply because the
person who set up the security did it incorrectly. That is fairly common in
Access unfortunately.
If you have access to an appropriate workgroup file and have proper credentials
then you can (in code) instantiate a new workspace that uses the secure
workgroup to open the secure file and access the tables programmatically from
inside a non-secure file. This would not allow you to create a link however.
