Parenthese appears in Access 2000 (dbo)

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

if your login is not the owner the (dbo) will come up. if the login is the owner the (dbo) will not!

* Noel

David.Poole SSC Guru Points: 76000 More actions · Answer 2

I have an MS Access database that is blank apart from standard utility functions that I always use.

One of the routines loops through the tabledefs collection and removes any dbo_ prefixes from linked table names.

You can call the linked table anything you want in Ms Access, it doesn't affect the name of the underlying source table.

doukoud SSC Veteran Points: 252 More actions · Answer 3

Thanks but my problem is that dbo appear in suffixes with parentheses.

I tried to remake it on my pc and delete my login in sql server, but i still have tables named like this : "Customers (dbo)".

Let me know your code to go through tabledefs, plesae

David.Poole SSC Guru Points: 76000 More actions · Answer 4

This is assuming you have a reference to Microsoft Data Access Objects.

Public Sub sbRename()

Dim db As DAO.Database

Dim tb As DAO.TableDef

Set db = CurrentDb()

For Each tb In db.TableDefs

If Left(tb.Name, 4) = "dbo_" Then

tb.Name = (Mid(tb.Name, 5))

End If

Set db = Nothing

End Sub

In my case the tables are always prefixed with dbo_.

In your case you would simply use

If instr(1,tb.name,"(dbo)",vbTextCompare) then

tb.name = left(tb.name,instr(1,tb.name,"(dbo)",vbTextCompare)-1)

End If

This is assuming your SQL Server tables/Views follow best practice and only contain alphanumerics.

doukoud SSC Veteran Points: 252 More actions · Answer 5

SSC Veteran

Points: 252

March 5, 2004 at 2:33 am

Thanks for your help all.