I do this with a lot of my SQL Server tables.
When the app is opened and the link is established it would use the security rights of the user group that person belongs to. You can then link the tables with no passwords required. (I assume you are only reading and not updating the Oracle data). Oracle Admin - assign this new group with Trusted rights to the Oracle tables you want to link to. The the network admin add your users to the group account. Or create a group account for the application on the network (Network Admin would need to do this if you don't have authority). Have your Oracle DBA assign this group as Trusted to the Oracle tables.
#LINK TABLES IN IDATABASE WINDOWS#
If you have a Windows User group your users belong to like Acct_Dept, then Hello Denburt: I apologize if I am oversimplifying matters, but can't Local and Linked Tables be used in Relationships such as those typically used in Queries where Relationships are defined on strictly Local Tables? It's impossible to know just looking at the definitions, but could the following Relationships be created? Lets say the table structure is as follows: So I am looking for ideas on how I can link the three tables together in an sql statement so I can iterate through it as a single recordset? I also have linked tables to two different Oracle databases and I do not want the passwords stored in the link, yet for automation purposes I don't want to type it in either. I currently have a MS Access database with data stored in this database in local tables. Much of this I can't control so making changes to the structures isn't an option. I am looking for some ideas, comments, suggestions or even questions.Ĭurrently I am using VBA to create temp tables then work from there however I would like to see if this can be done without the temp tables.