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.

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

"Bunky" <(E-Mail Removed)> wrote in message
news:58D80FCC-0587-41E1-AFA7-(E-Mail Removed)...
>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.

On Tue, 8 Jan 2008 08:05:01 -0800, Bunky <(E-Mail Removed)> wrote:

>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

On Tue, 8 Jan 2008 08:05:01 -0800, Bunky <(E-Mail Removed)>
wrote:

>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]