If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Link tables from a secured db
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 |
#3
|
|||
|
|||
Link tables from a secured db
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 |
#4
|
|||
|
|||
Link tables from a secured db
"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 |
#5
|
|||
|
|||
Link tables from a secured db
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. |
Thread Tools | |
Display Modes | |
|
|