Tables & Functions display as DBO

  • Thread starter Thread starter Rudi Groenewald
  • Start date Start date
R

Rudi Groenewald

Hey people,

I've got a database which I am using sql server 2000 with Ms access 2002
(ADP)

Me as the developer (SQL Server sysadmin)

When I create or view the tables & functions in access then it shows as
their original name eg: Tbl_employees

But when another user views the tables & functions it adds the abb dbo for
eg: Tbl_employees (dbo)

Obviously when I create my forms, listboxes etc based on a query or table, I
create it on my name and it creates from the original name. Let's say, I've
got a listbox which is based in the function "Qry_Listbox_employee"

Now when my client users use the application the listbox can't find the
source, cause that listbox shows in their application as
"Qry_Listbox_employee (dbo)"

How can I make my clients tables / functions (server objects) view without
the "dbo" at the end?


Thanks alot in advance
 
Don't worry people..... I figured it out,

Just add .dbo in front of your source...
 
Back
Top