Getting data from a second MDB file

[Jerry Mc Cauley]

Hi,

I have a MS-Access 2002 data base where a opening form sets security.
Presently, the security is established by a function that determines userid
and the sets the security in
select case fgetuserid

This is NOT an effective way to do it I know ... but the original database
had only 2 or 3 users it was not a big deal. Now ... it has grown. I would
like to list the security in an MS-Access database (seperate file) that would
have the appropriate security on the file to maintain the security of the
data.

In this second MDB file, n:\HRData\personnel_SFO_security.mdb, there is a
single table TBL_Security with userid and see_s1 fields.

When the startup form opens in the 1st db, I would like to get the see_s1
info, stored in the 2nd db, where fgetuserid = TBL_Security.userid

H E L P.... I lost at this point.

Thanks

 

[Keith Wilby]

Hi,

I have a MS-Access 2002 data base where a opening form sets security.
Presently, the security is established by a function that determines
userid
and the sets the security in
select case fgetuserid

This is NOT an effective way to do it I know ... but the original database
had only 2 or 3 users it was not a big deal. Now ... it has grown. I
would
like to list the security in an MS-Access database (seperate file) that
would
have the appropriate security on the file to maintain the security of the
data.

In this second MDB file, n:\HRData\personnel_SFO_security.mdb, there is a
single table TBL_Security with userid and see_s1 fields.

When the startup form opens in the 1st db, I would like to get the see_s1
info, stored in the 2nd db, where fgetuserid = TBL_Security.userid

H E L P.... I lost at this point.

Thanks

You're making a huge maintenance headache for yourself in trying to devise
your own security and it will be nowhere near as good as the built-in
version. I would advise using the built-in user level security. Whilst
it's a steep learning curve, once the penny drops you'll be glad you took
the time (I am!).

Cautions: don't rely on the help, read the MS FAQ (link on my web site);
don't work on your only copy, you'll almost certainly lock yourself out at
some stage.

Regards,
Keith.
www.keithwilby.com