SQL Server Performance

SourceObject property with non dbo

Discussion in 'General Developer Questions' started by sektor, Sep 9, 2003.

  1. sektor New Member

    Hello,<br /><br />I am using an access 2000 project with sql srv 2000 as an<br />administrative tool to edit table data. I select the table names from<br />a combobox in an access form and use myform.SourceObject =<br />Table.dbo.mytable<br />StoredProcedure.dbo.sp_xxx etc. wich gives me the error<br />message "The form name you entered doesn't follow Microsoft Access<br />object-naming rules".<br />As a connected user of sysadmins role there is no prefix "dbo." added,<br />so that the form is fine. But connecting as a user who is not member<br />of sysadmins makes it impossible for me to use the form with<br />sourceObject property! (;-&lt<img src='/community/emoticons/emotion-5.gif' alt=';)' /><br /><br />Has anybody an idea how to generate a workaround to this microsoft<br />bug?<br /><br />thanks a lot in advance<br /><br />Stephan<br />
  2. satya Moderator

    How about privileges for the Access user on the SQL SP?

    Satya SKJ
  3. sektor New Member

    Privileges aren't the problem. I can use open, select, exec,... on all the database objects I want, only the SourceObject Property doesn't work and I use this property to determine the data source of my subform to the table I selected from a combobox in my form.<br />There would be a way to generate a form for each table I want to enter, but I have access to about 80 tables and don't want to generate a form for each (;-&lt<img src='/community/emoticons/emotion-5.gif' alt=';)' /><br />Anyways I would like to keep it dynamic, if there are any more tables added to the database I just put them in my system table and don't have to change anything in my access project or form.<br />All that stuff works perfect as long as a sysadmin member uses the form, because there is no prefix "dbo."<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />How about privileges for the Access user on the SQL SP?<br /><br />_________<br />Satya SKJ<br />Moderator<br />SQL-Server-Performance.Com<br /><br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Share This Page