GrandMasterTuck
In need of medication
- Local time
- Yesterday, 23:14
- Joined
- May 4, 2013
- Messages
- 129
I have an MS Access 2010 database that is split, with the tables back-end on a network share. In another folder of the network share (a folder that nobody but me has access to) lies a second database for a different set of data unrelated to the first one.
Is there a way that I can get a VIEW of the data in the SECOND database (in the protected folder) that users of the FIRST database can see? Keep in mind, these users do NOT have access to that protected folder. I just want them to be able to see the data but not touch it in any way, and moving it from where it is wouldn't be a very good idea for a multitude of reasons.
I was hoping there was some tricky way to create - in the FIRST database - a view of the data in the SECOND (protected) database, using some trick or another. I was even considering somehow making a 'copy' of the second database's table and dumping that data in the first database when a user executes some command or another, but I'll be darned if I can figure out how to do it.
You guys have any ideas? Thanks a million!
Is there a way that I can get a VIEW of the data in the SECOND database (in the protected folder) that users of the FIRST database can see? Keep in mind, these users do NOT have access to that protected folder. I just want them to be able to see the data but not touch it in any way, and moving it from where it is wouldn't be a very good idea for a multitude of reasons.
I was hoping there was some tricky way to create - in the FIRST database - a view of the data in the SECOND (protected) database, using some trick or another. I was even considering somehow making a 'copy' of the second database's table and dumping that data in the first database when a user executes some command or another, but I'll be darned if I can figure out how to do it.
You guys have any ideas? Thanks a million!