Link tables from a secured db

Hi
I have a secured database on a customer site, called SAM. Now the
customer has bought a document management system (DMS). It has an unsecured
Access back end. They want to link this to my system - via linked tables. If
the DMS PC sets it default workgroup to SAM, they logon and they can link
the tables. However, the DMS frontend still can't read the linked tables
because of the security.

Now if the DMS was a secure system, I would add a user,with the same PID as
already setup in the DMS, to SAM. However, I can't do that here as I don't
know the PID of the default use of DMS. Any ideas for a way around this? I
don't want to remove the security on my own system, of course!

Thanks
Diarmuid

You CAN create a new user in your system, and use a known PID.

I been told that essentially then the PID you used to create the workgroup
file then DOES NOT matter. In other words, if you grant permissions to that
user...that user can come from a another workgroup...and as long as the PID
of the USER is the same..it will work...

So, the PID's of the worksgroups don't have to match...but they do for the
users.....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn

Yes, but I don't know the PID of the default user! The Document Management
System is unsecured, so I assume its using system.mdw. But how would I know
the PID of the Admin in system.mdw?
Thanks
Diarmuid

"Albert D. Kallal" wrote in message
...
You CAN create a new user in your system, and use a known PID.

I been told that essentially then the PID you used to create the workgroup
file then DOES NOT matter. In other words, if you grant permissions to
that
user...that user can come from a another workgroup...and as long as the
PID
of the USER is the same..it will work...

So, the PID's of the worksgroups don't have to match...but they do for the
users.....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn

"Diarmuid" wrote in message
...

Yes, but I don't know the PID of the default user! The Document Management
System is unsecured

The default id is always admin, and whatever the pid is...it is always the
same!

Well, if the document system is un-secured, then you can log into the
document system with ANY id...and it should work?

The fact is that if there NO security?

Why not just then log on into your workgroup as some user, and THEN open
this un-secured DMS system/file? If as you say, the DMS system is
un-secured, then you can use YOUR workgroup. Why use the default workgroup
file here?

Just use your workgroup file for the DMS system...since it is
un-secured...it should not matter?

I might be missing something here?

As far as I know....the default user of "admin" does NOT have a pid. (and,
if it does...they are likely are ALL THE SAME). Remember, all workgroups
must have a admin user. You do NOT want to give the default admin user
access to YOUR system..as then you effect will be un-doing security. (the
whole idea when you setup security was to remove permissions from the
default user called admin).

So, the default user of that DMS system is "admin", I am guessing that the
pid is the same as the Pid of the admin user IN YOUR workgroup file. It is
possible that admin takes on the PID of the workgroup when you created it.
(that is possible..but I don't know).

But, really, it don't think it matters....as you can use YOUR workgroup file
to logon to the DMS system. You could even create a user without a password
in your workgroup file for everyone to use. You then provide a shortcut that
specifies the user when launching the DMS system. That way, users of the dms
system would NOT get a logon prompt. On the other hand...a logon prompt for
users might be ok with you also (this is your choice).



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn

Hello Diarmuid,

I was reviewing this thread. Do you have any more concerns on Albert's reply? If there is any unclear, please feel free to post here and we will
follow up.

Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.