If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: MS Access 2010 - VBA

Recently, my user received an upgrade to Windows 7 and MS Office 2010. The MS Access application was previously executed using Win XP and MS Access 2003. For MS Access 2003 the user would receive only one prompt to her databasde credentials (user ID and password). With MS Access 2010, this is now occurring three times (once for the CurrentDb.TableDefs(sDatabase).RefreshLink statement and twice for the sMinimumDate = Trim("" & DMin("[ADJPOST]", "[IBNR_ADJTRAN_TEST]")) statement). The IBNR_ADJTRAN_TEST table is a linked table residing in DB2. I cannot find enough documentation on MS Access 2010 to assist me in resolving the problem. Any assistance would be appereciated. The code segment is below.

Yes, I had also converted the MS access database to 2010 format without any success. Tried refreshing the link (no difference) and also tried to create a new link (with a different name) to the same table. There seems to be something funky between the interface of ODBC and Access. When I tried to create a linked table using the Machine Data Source, the name appears clearly in the window that appears. Clicking on the MDS and supplying the user ID password the results in an error "[IBM] [CLI Driver] The database alias or database name " " could not be found. SQLSTATE=42705 (#-1013). Note that in the error the name is blank. When the DB2 command line processor (CLP) is used to view the environment all appears well (names and aliases). The ODBC administrative tools also displays the environment data without any problem.