Recent content by daniel.nicolae.stoica

I am starting to think that dsnless linking of foxpro tables from different folders is not possible and that the only solution is to create DSN for each path. Of course Access will have to be run as an administrator. As soon as I finish writing and checking the code for creating the DSN and...

Of course I concatenate; is an AfterUpdate event triggered by a combobox. The connect looks like db.TableDefs(rst!TableName).Connect = "ODBC;DRIVER={Microsoft FoxPro VFP Driver (*.dbf)};SourceDB=" & _ rst!drive & "\transmisii\" & Forms!frmah!cboDateReferinta.Column(2) & "\" &...

OLEDB drivers.

ODBC drivers.

With different user DSN I managed to link different tables... Well, a long time ago in a app that I wrote I create with vba a DSN. I don't remember if i had to run Access as Administrator...

In this case works normal. One solution is to put all my tables in one folder (witch i rather not, there are other people who are familiar with the actual structure). I still hope that someone brighter and with better skills then me will save me...

You mean with different DSN?

I don't think is a problem with the code with witch i make the link: first linked table is OK. I don't understand why when i try to link the second table (and when i specifically set the correct string to tdf.connect) takes the connection string from the first table...

Of course. Set db = CurrentDb Set tdf = db.CreateTableDef([second_table_name]) tdf.Connect = "ODBC;DRIVER={Microsoft FoxPro VFP Driver (*.dbf)};SourceDB=[different_path]" & _ ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;" tdf.SourceTableName =...

Hello! I have a problem when i try to connect two different Foxpro table which are located in different folders. The first link goes fine but when i try to link the second table although in the ConnectionString I specify the path correctly (witch is different from the first path) i get an error...