ADP Setting SourceObject to a Table from another user

  • Thread starter Thread starter Patrick Wolf
  • Start date Start date
P

Patrick Wolf

Hi,

I developed my project as the database owner.
We use integreated security.
When I log into Windows as another user, open access and try to work with
the project I find a problem in the following area.
Setting the SourceObject of a Subform used to be
frmSub.SourceObject = "TableX"
Now since all tables are called tableX(dbo)
frmSub.SourceObject = "Table1" gives an error not found
frmSub.SourceObject = "dbo.TableX" gives the error that this is against the
naming conventions
frmSub.SourceObject = "TableX(dbo)" gives no error but doesnt display the
table in the subform either.

Can anybody help? Thanks a lot
Patrick
 
Patrick

The table name is actually the 3rd node in the name. Try:
dbo..TableX

Joe
 
Hi Joe,

thanks for your answer but it still doesn't work.
The error is "The form name you entered doesn't follow ...... object naming
rules".

It should be Database.User.Object isnt't it?

Thanks Patrick
 
Patrick

I am sorry, but I misread your original question. The SourceObject property
in Access 2000 (which is what I use) is used to identify a form, not a data
source.

Joe
 
Joe,

thanks for your answer. That means setting SourceObject to a table works
only if one is the dbo but is not really the right thing to do anyhow.
I can live with that.

Thanks
Patrick
 
Back
Top