Can I create 2 different workspaces

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: nova (nova_at_discussions.microsoft.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 01:55:02 -0800

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? Thanks a lot
for looking into this.

Relevant Pages

  • How to create different workspaces
    ... user-level secured database. ... Since I'm not familiar using workspaces to access the workgroup files, ... However, when the subroutine calls the function, it says ...
    (microsoft.public.access.security)
  • [Info-ingres] RE: OpenAPI Weirdness
    ... I've written a C program which has a subroutine full of API stuff. ... subroutine controls connecting to three databases in sequence to do ... From the final database connection it reads in a lot ...
    (comp.databases.ingres)
  • Re: light weight, stand alone data solution
    ... database in". ... solution would be to create a subroutine that provided the necessary abstractions. ... I did database programming from 1984 through 1997, ... technology got too expensive to use (SQL, ...
    (microsoft.public.vc.mfc)
  • Re: Access module does not continue past the Filter Method
    ... If you get this problem in any database at all, ... the subroutine went back to not working again. ... Public Sub Apply_Tech_Filter ... Debug.Print "Past the Filter" ...
    (microsoft.public.access.modulesdaovba)
  • RE: Using q() to define a query
    ... which will basicaly turn the subroutine into a constant that can be ... instead if inserting the data into the SQL with sprinf. ... and more efficient (allows the database to cache execution plans). ... stored procedures would work even ...
    (perl.dbi.users)