C
Christophe Niel
Hi all
(I'm sorry for already having posted this in microsoft.public.access)
I'm having the strangest thing with sql objects ownnership when i'm using
Access 2003.
A user is a member of a Domain Global Group in the AD.
This group is used in SQL enterprise manager to give the dbo role on a
database.
SQL Analyzer, Enterprise manager, no problem, my user has the dbo role, he
can access anything, delete everything, yay! great security!
So why, O why, can he not access the database as "DBO" when using a MS
ACCESS 2003 Project file ??
All the objects have " (dbo) " at the end on their name, everthing is read
only.
When I create object, the ownership is set to " mydomain\mylogin "
Except from the read-only problem, I wouldn't mind if I could use
"dbo.mytable" in the fonction I need, but the only one I'm really
interrested in is :
DoCmd.TransferSpreadsheet acImport, , "dbo.mytable" .....
and that doesn't work because it tries to create/find a table " bo_mytable"
(where does this underscore come from?, see my other post about the error
3078)
I can't use User authentication in SQL because there is way too many users,
so I use group authentication, maybe the problem is here.
Can anyone tell me why my user doesn't have the dbo role?
I found this in the technet :
Q253180 : http://support.microsoft.com/default.aspx?scid=kb;en-us;253180
ACC2000: Table Created by User in Db_owner Role Makes User the Owner
Which looks similar to my problem, But I'm using Access 2003 with sp1 (and
this was for office 2000)
(I'm sorry for already having posted this in microsoft.public.access)
I'm having the strangest thing with sql objects ownnership when i'm using
Access 2003.
A user is a member of a Domain Global Group in the AD.
This group is used in SQL enterprise manager to give the dbo role on a
database.
SQL Analyzer, Enterprise manager, no problem, my user has the dbo role, he
can access anything, delete everything, yay! great security!
So why, O why, can he not access the database as "DBO" when using a MS
ACCESS 2003 Project file ??
All the objects have " (dbo) " at the end on their name, everthing is read
only.
When I create object, the ownership is set to " mydomain\mylogin "
Except from the read-only problem, I wouldn't mind if I could use
"dbo.mytable" in the fonction I need, but the only one I'm really
interrested in is :
DoCmd.TransferSpreadsheet acImport, , "dbo.mytable" .....
and that doesn't work because it tries to create/find a table " bo_mytable"
(where does this underscore come from?, see my other post about the error
3078)
I can't use User authentication in SQL because there is way too many users,
so I use group authentication, maybe the problem is here.
Can anyone tell me why my user doesn't have the dbo role?
I found this in the technet :
Q253180 : http://support.microsoft.com/default.aspx?scid=kb;en-us;253180
ACC2000: Table Created by User in Db_owner Role Makes User the Owner
Which looks similar to my problem, But I'm using Access 2003 with sp1 (and
this was for office 2000)