sourceObject Property dbo

S

Stephan Gehrlein

The tables I select are completely different structures.
I use the form as an administrative tool to edit data in an access.ade if
you don't have the sql Server client tools.
So one table has only 2 columns, the other maybe 20 columns.

UF_Tabellen = Subform where the table is shown
cboTabelle= combobox where the table name is chosen from

the code
Me!UF_Tabellen.SourceObject = "Tabelle." & Me!cboTabelle
does work perfect as long as you are loged on as a sysadmin. Only the
necessary prefix "dbo." for non members of sysadmins makes it impossible to
use the code.

Thanks for any help
Stephan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sourceObject Property dbo 1
Project and SQL role/user dbo problem 0
Project and SQL role/user dbo problem 6
Auto populate 5
for each in a range 1
normalizing and creating fields or related tables 0
BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain 2
Connection string workaround 2

Top