MSDE

[J.B. Santana]

MSDE has been installed in my server when running the
startup program of a 3rd party application. As
administrator of our network I have no problem to make a
link and to get from SQL the needed 3rd party tables in
order to design new queries, form, reports etc in my own
mdb file.
The problem is when another computer/user opens my shared
mdb file (with the links to MSDE), they get an error
message from SQL with an authentification failure.

The question is how can I share my mdb file (with the
linked tables residing in MSDE) with all my network users.

Thanks a lot for a prompt reply.

Regards

 

[BJ Freeman]

As administrator you have "sa" right to the msde.
I don't suggest you give those rights to your users.
You can create a UseriD on the MSDE that has owner rights.

here is a routine for connecting linked tables

Function fSetLinkPath(strTable As String) As String
Dim dbs As Database, stPath As String

Set dbs = CurrentDb()
On Error Resume Next
If dbs.TableDefs(strTable).Attributes = dbAttachedTable Then
dbs.TableDefs(strTable).Connect = "your dnsless connect string to the
msde"
dbs.TableDefs(strTable).RefreshLink
End If
fSetLinkPath = dbs.TableDefs(strTable).Connect
Set dbs = Nothing

End Function

the DNSLESS connect string has this structure
"Data Provider=SQLOLEDB;Persist Security Info=True;Data Source=IP address of
DB;User ID=MSDEUserIDyourcreated;Password=MSDEUserPSWD;Initial
Catalog=DBName"