Get data from 2nd Access DB

[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

 

[Stefan B Rusynko]

See the process at
http://support.microsoft.com/default.aspx?scid=kb;en-us;825498#XSLTH3142121122120121120120

Your DB must be either in your site or on your server (in a location you can create a DB connection to)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| 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
| --
| Jerry