VBA - Linking Problem

[mikemm]

Hi,

I am trying to link oracle tables through VBA. Using the following code:

Dim db As DATABASE
Dim tdf As TableDef
Dim strConnect As String
Dim strTable As String
strTable = "TableName"
Set db = CurrentDb()
Set tdf = db.CreateTableDef(strTable)
tdf.SourceTableName = strTable
strConnect = "ODBC;DSN=<dsnname>;SERVER=<server>;PWD=<pwd>;UID= <uid>"
tdf.Connect = strConnect
db.TableDefs.Append tdf
db.Close
End Sub

I get the following error : "There are several tables with that name. Please specify owner in the format 'owner.table'. (Error 3298)".

I have tried specifying <uid>.tablename.....but it doesnt work....

Any suggestions..

[Denburt]

Where I currently work they name the Oracle tables Something.Something and MS Access converts this to Something_Something so if i look at the linked table I see one thing but if I highlight the link and hover over it with the mouse I can see in the tips area that lights up and shows the complete connection and that shows the table name as it should (Something.Something).

Do you think this could be the issue? I am sure you will find quite a few issues when trying to tie into and work with Oracle, although I have had much success.

[mikemm]

gave the source table name as <uid>.<tablename> and it worked...thanks.

[Denburt]

Awesome glad i could help. :)