Link tables in secure databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 2 secure datbases. Each has a seperate workgroup file.
In my database I am an administrator. In the other, I have persuaded the
owner to give me read access.
I have made sure the PID number and user name for me are the same in both
workgroup files.

II want to go into my database and link to a table in the other one. However
I cant do this as I dont have enough permissions. All I want to be able to do
is see the up-to-tate table from the other datbase, I dont want to change
anything in it.
Is it possible to do this? what am i doing wrong?
The other database administrator wont make me an administrator of their
database, which I guess would help.

Thanks to anyone who can help

cheers

Barbara
 
Here's a fragment of some code I use to read from other databases:

Dim oConnectX As ADODB.Connection
Dim rstX As ADODB.Recordset
Dim sNameX As String
Dim sWorkGroupX As String

sNameX = "<FullNameOfExternalMDB>"
sWorkGroupX = "<FullNameOfWorkGroupMDW>"

Set oConnectX = Nothing
Set oConnectX = New ADODB.Connection
With oConnectX
.ConnectionString = CurrentProject.Connection.ConnectionString
.Mode = adModeShareDenyNone
.Properties("Jet OLEDB:System database") = sWorkGroupX
.Properties("User ID") = CONstrUserID
.Properties("Password") = CONstrPassword
.Properties("Data Source") = sNameX
.Open
End With

Set rstX = New ADODB.Recordset
With rstX
.Open "tblAPC", oConnectX, adOpenStatic, adLockReadOnly, adCmdTable
' etc...
.Close
End With
 
Back
Top