ADP Setting SourceObject to a Table from another user

[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

 

[J. M. De Moor]

Patrick

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

Joe

 

[Patrick Wolf]

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

 

[J. M. De Moor]

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

 

[Patrick Wolf]

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

 

[üÚÅÎËÉÎ óÅÒÇÅÊ]

ËÒÕÔÏ

Patrick

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

Joe