Conversion from Jet to SQL

[Bunky]

I have a question on the conversion from the normal Jet engine Access to SQL.
Our DBA is defining all of our current production tables to SQL and all of
the table names are beginning with 'dbo_'. I was wondering if we can assign
an alias to the table so we do not have to change all the queries to the new
table name. Or if there is a better/different way to accomplish the
conversion, I would love to hear that as well.

Thanks for all your assistance.

 

[Baz]

Just rename the tables in the Access front-end. The links will still work.

 

[Scott McDaniel]

I have a question on the conversion from the normal Jet engine Access to SQL.
Our DBA is defining all of our current production tables to SQL and all of
the table names are beginning with 'dbo_'. I was wondering if we can assign
an alias to the table so we do not have to change all the queries to the new
table name. Or if there is a better/different way to accomplish the
conversion, I would love to hear that as well.

You can just rename the tables after they're linked ... just delete the "dbo_" part ...

Thanks for all your assistance.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[John W. Vinson]

I have a question on the conversion from the normal Jet engine Access to SQL.
Our DBA is defining all of our current production tables to SQL and all of
the table names are beginning with 'dbo_'. I was wondering if we can assign
an alias to the table so we do not have to change all the queries to the new
table name. Or if there is a better/different way to accomplish the
conversion, I would love to hear that as well.

Thanks for all your assistance.

I've had to do this often enough that I threw together a very simple limited
sub to do it:

Public Sub renamedbo()
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = CurrentDb
For Each tdf In db.TableDefs
If Left(tdf.Name, 4) = "dbo_" Then
tdf.Name = Mid(tdf.Name, 5)
End If
Next tdf
End Sub


John W. Vinson [MVP]