Defining an alias?

[kalebson]

I have 2 databases that I am using linked tables to connect to. The problem is that the table names in both databases is the same. Hence I have named my linked tables as such:

dbo_iAgentPerformanceStat_PHX (added _PHX)
dbo_iAgentPerformanceStat_STP (added _STP)

What I am trying to do is eliminate ODBC logins by setting the ODBC connection string within the query. However when I add the connection string it says it cant find the table in that database...obviously because I had to rename it. Is there a way that I can define dbo_iAgentPerformanceStat_PHX as the true table name which on the server itself is:

iAgentPerformanceStat

I am not sure if there is a way to set an alias or something. Thank in advance.

 

[AlexCuse]

I believe you can save your login info for your ODBC database when setting up the linked table (click the 'Save Password' box when selecting the tables to link from list).

Then just rename your tables to whatever you want in Access' table menu, and use these names in your query.

Hope this helps,

Alex

It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.

 

[kalebson]

You know its odd I never saw that.. THx ill just re-link them.