| Author |
ADP project on SQL 2000 sp4
|
|
| exchangerookie1994 2006-03-05, 8:24 pm |
| We currently have a adp project linked with a Sql server 7 running NT4.
We need to replace old server with a win server 2003 with SQL 2000 sp4.
When viewing tables, stored procedures from ADP project all objects have
(dbo) after them. I then run into problems when trying to run saved reports -
the report is looking for the table name itself instead of tablename (dbo).
It would be a lot of work to fix all of the reports.
Thanks
| |
| Alex Cieszinski 2006-03-05, 8:24 pm |
| Maybe you should create a view to meet client tool demands:
CREATE VIEW [table1 (dbo)] AS SELECT * FROM table1
so reports will access table1 through the view with the name they wanted for
"exchangerookie1994" < exchangerookie1994@d
iscussions.microsoft.com> wrote in
message news:03F79A1A-56AF-4440-BE3B- 27C00AF3FB93@microso
ft.com...
> We currently have a adp project linked with a Sql server 7 running NT4.
> We need to replace old server with a win server 2003 with SQL 2000 sp4.
> When viewing tables, stored procedures from ADP project all objects have
> (dbo) after them. I then run into problems when trying to run saved
> reports -
> the report is looking for the table name itself instead of tablename
> (dbo).
> It would be a lot of work to fix all of the reports.
>
> Thanks
| |
| exchangerookie1994 2006-03-05, 8:24 pm |
| Is there a way to remove the (dbo) from everything. Do you know what causes
this. I tried the exact same thing on a SQL 2000 sp3 and eveything was fine -
no (dbo)
Should I run another instance of SQL 2000 with sp3 instead?
Thank you
"Alex Cieszinski" wrote:
> Maybe you should create a view to meet client tool demands:
> CREATE VIEW [table1 (dbo)] AS SELECT * FROM table1
>
> so reports will access table1 through the view with the name they wanted for
>
> "exchangerookie1994" < exchangerookie1994@d
iscussions.microsoft.com> wrote in
> message news:03F79A1A-56AF-4440-BE3B- 27C00AF3FB93@microso
ft.com...
>
>
>
>
| |
| Sue Hoegemeier 2006-03-05, 8:24 pm |
| It's related to the security context you are using in the
ADP and what permissions that login, user has in SQL Server.
And it's handled a bit differently with different version of
Access - but I don't remember what they changed with 2002
and above from Access 2000.
I know that in Access 2000, if you connect as a sysadmin,
you won't see the dbo appended. All others will see dbo. You
can't remove dbo from everything, you should be creating the
Access objects to use fully qualified names using
Owner.Object.
This is more of an Access issue so you would want to post in
an Access newsgroup. Try:
microsoft.public.access.adp.sqlserver
-Sue
On Fri, 3 Mar 2006 08:13:29 -0800, exchangerookie1994
< exchangerookie1994@d
iscussions.microsoft.com> wrote:
[color=darkred]
>Is there a way to remove the (dbo) from everything. Do you know what causes
>this. I tried the exact same thing on a SQL 2000 sp3 and eveything was fine -
>no (dbo)
>Should I run another instance of SQL 2000 with sp3 instead?
>
>Thank you
>
>"Alex Cieszinski" wrote:
>
|
|
|
|