Hello,

I am more of an Access/VB/SQL Server user, so please let me know if I need to provide anymore info:

I am attempting to link a DB2 table into an Access database. I can do it using a DSN, but I cannot get it to work without. There may be 1000 users across the country using the Access database, so I really don't want to go through the trouble of establishing a DSN on so many desktops.

When I attempt to run this code:

Set tbl1 = CurrentDb.CreateTableDef("UDBLA003_SOR_LOGIN")
tbl1.SourceTableName = "UDBLA003.SOR_LOGIN"
tbl1.Connect = "ODBC;driver={IBM DB2 ODBC
DRIVER};Database=SOR;hostname=axsc2lpar06;port=500 03;
Protocol=TCPIP;uid=******;pwd=******"
CurrentDb.TableDefs.Append tbl1

I get Reserved Error (-7778); There is no message for this error.

Does this mean I am actually connecting? Is there something else I should add? Am I way off?

Thanks in advance!

Pinback

I should also mention I am using Access97.

Thanks!

Maybe there is a good place I can go to find this info? Any ideas?

Have you tried to upgrade Access 97 to the highest patch level?
I had this problem too a number of years ago. I remeber that applying a number of patches solved the problem.

Kind regards
Wim

Thanks Wim,

Unfortunately, I think I am running the most recent version (SR-2).

Thanks again,

Pinback