error VBA and Linked Tables because of split
Hi, I have done a database without changing any security
and user groups. It is all the default options and I am
working on a network with win 2000. I decided to split the
database since I am almost over but once it is splitted
there are errors when I run my form. It is the
VBA code
that looks that it does not have the proper access on the
splitted tables. It says "Running time error "3251" not
authorized operation for this type of object"
and my vba code is:
Dim fDataBase As dataBase
Dim fPostInstallTable As recordSet
Dim fPhotoLogo As recordSet
Dim fRecordSet As recordSet
Dim fQueryDefs As QueryDefs
Dim fQuery As QueryDef
Set fDataBase = DBEngine.Workspaces(0).Databases(0)
Set fPostInstallTable = fDataBase.OpenRecordset(name1)
Set fPhotoLogo = fDataBase.OpenRecordset("FaceLogo")
Set fQueryDefs = fDataBase.QueryDefs
Set fQuery = fQueryDefs(name2)
Debug.Print FFrom
If FFrom <> 0 Then
fQuery.Parameters(0) = FFrom
fQuery.Parameters(1) = TTo
End If
Set fRecordSet = fQuery.OpenRecordset
....
====>error is here=> fPhotoLogo.Index = "PrimaryKey"
can anyone help me?
thanx
Simon
.
