N
nova
Using a subroutine, I'm saving records from an outlook mail attachment into a
user-level secured database. In order to do this I have to get some
information from another database which is secured with another security
workgroup. I'm doing this by performing a function in the previous routine.
Since I'm not familiar using workspaces to access the workgroup files, I
would think that I have to create 2 different workspaces, one for each
separate database. However, when the subroutine calls the function, it says
'You do not have the necessary permissions...' (for the 2nd database). When I
run this function as standalone, it works fine. I use 2 different names for
each workspace. Anyone has an idea of what I'm doing wrong here? Is it
because I create the DBEngine.SystemDB twice ? Thanks a lot
for looking into this.
user-level secured database. In order to do this I have to get some
information from another database which is secured with another security
workgroup. I'm doing this by performing a function in the previous routine.
Since I'm not familiar using workspaces to access the workgroup files, I
would think that I have to create 2 different workspaces, one for each
separate database. However, when the subroutine calls the function, it says
'You do not have the necessary permissions...' (for the 2nd database). When I
run this function as standalone, it works fine. I use 2 different names for
each workspace. Anyone has an idea of what I'm doing wrong here? Is it
because I create the DBEngine.SystemDB twice ? Thanks a lot
for looking into this.