Record Source suddenly shows dbo as prefix

[Myrkr]

Hi.

I'm pretty good with Access, but not so much working with ADP. I have a SQL
Server 2005 back end linked to an Access 2003 adp. All's well, except as of
yesterday, the table list and the Queries in the ADP started showing (dbo)
behind each entry. This wasn't the case yesterday morning. When selecting a
record source, everything (tables, queries etc.) is listed under dbo.
(namehere). So I can no longer just type, say, the letter T to jump down the
list to tables starting with T. I have to scroll down - and it's seriously
adversely impacting my programming time. What a pain. I've tried
disconnecting and reconnecting, editing the Database Connection, rebooting,
refreshing, renaming - and it just won't go away.

Could someone please tell me how to get this back to the way it was? e.g.
without the (dbo) showing?

If it matters, I'm not using a connection string - just the Access 2003
Project auto-link or whatever it's called. It would be easier if I knew WHAT
changed - nothing I specifically did, which makes it much harder to
troubleshoot.

Any insight would be helpful.

M

 

[Tom van Stiphout]

It's more than likely not something that changed in Access, but rather
in SQL Server.
Try connecting to a different server. Then compare security settings.

-Tom.
Microsoft Access MVP

 

[Myrkr via AccessMonster.com]

Hi Tom.

Thanks for the fast response and great suggestion. I checked into that
aspect and lo and behold, one of our contracted DBAs changed the DBO of the
tables to a different login than we use in the front end.

So we tried 1) logging in as the (new) DBO and 2) changing the DBO back to
the original ID in the database. Both fixes work to eliminate the dbo
qualifier in the front end.

Summary; dbo appears if login and dbo name aren't the same.

Very good to know.

Your help is much appreciated.

M

It's more than likely not something that changed in Access, but rather
in SQL Server.
Try connecting to a different server. Then compare security settings.

-Tom.
Microsoft Access MVP

Hi.

[quoted text clipped - 20 lines]

M

 

[bhar]

Hi.

I'm pretty good with Access, but not so much working with ADP. I have a
SQL
Server 2005 back end linked to an Access 2003 adp. All's well, except as
of
yesterday, the table list and the Queries in the ADP started showing (dbo)
behind each entry. This wasn't the case yesterday morning. When
selecting a
record source, everything (tables, queries etc.) is listed under dbo.
(namehere). So I can no longer just type, say, the letter T to jump down
the
list to tables starting with T. I have to scroll down - and it's
seriously
adversely impacting my programming time. What a pain. I've tried
disconnecting and reconnecting, editing the Database Connection,
rebooting,
refreshing, renaming - and it just won't go away.

Could someone please tell me how to get this back to the way it was? e.g.
without the (dbo) showing?

If it matters, I'm not using a connection string - just the Access 2003
Project auto-link or whatever it's called. It would be easier if I knew
WHAT
changed - nothing I specifically did, which makes it much harder to
troubleshoot.

Any insight would be helpful.

M