Recent content by kc27

Thank you for the help on this. I had to figure out how one of our Access databases was created. It contained nothing but linked tables, and the original creator of the db was no longer available to advise me on whether he created the linked tables with passwords saved.

I want to follow up on this thread: A little background. The Excel tool pulls data from an Access database. The Access database contains no native Access tables. it only has linked tables. The tables in the originating database had been modified (new names, or they were new tables altogether)...

I need to check with a database administrator. IQPROD had the TMI tables; PROD has the TDC tables, at least that is what I believe is the case. Once I find out I will post back here.

Not sure what you mean by what the system needs to see. My only modification to the VBA code in the tool was changing table names. So a table that was MRSPC_[highlight #FCE94F]TMI[/highlight]301DPTCLA_GCLA became MRSPC_[highlight #FCE94F]TCD[/highlight]301DPTCLA_GCLA. That was it. Prior to that...

Thanks - below is what appears in the intermediate window: ODBC;DSN=PROD;UID=CSSSXLSP;;MODE=SHARE;DBALIAS=PROD;TXNISOLATION=1; Interesting that the "Connect to DB2 database" dialogue box that I included in my first post shows a db alias of "IQPROD" and not "PROD" that resulted from the query.

Maybe I am missing a step that both of you assume that I would be doing. Here is what I did. 1. Open blank Excel document 2. Clicked on the Data tab 3. Get Data > From Other Sources > From Microsoft Query 4. Choose the table I want and choose "Return data to Microsoft Excel" 5. Table data is...

Hi Skip Thanks for your help on this. I put a query on a blank sheet and loaded a table I get an "object required" message when I run the code. The query object is already on the document and displaying the table data. Do I have to do something else to get the the code to recognize the...

If you look in the screen shot of the "Connect to DB2 database" dialogue box, there is a value pre-populated for Database Alias. What controls the database alias that is displayed? There are several other databases available in that drop-down menu. I do not see any references to IQPROD in the...

I did not create the tool. I do not understand the logic behind connecting to those two tables then closing. Might be needed for the criteria selection that occurs next. It did work properly until table names were changed.

I have a database username and password written into the VBA code of an Excel tool that is used to generate reports. The correct functionality of the form is that the user clicks a button and begins making criteria selections to generate a report. To generate the report, the Excel tool needs to...

I inherited maintenance of Excel tools that utilize Access databases. One of the Access databases contains nothing but links to tables in a SQL database. The SQL database administrator mentioned to me that the table names in the SQL database have changed. I am going into the Access database and...

Thanks for the answers. I was wondering if the code removes any leading zeros. It does not sound like it does. This is where the name is derived 'Windows API Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

I have an Excel form that uses the code below to get the logged on user's ID. What is this line of the code doing? Is it subtracting a character where it reads "-1"? Is it removing a character? Private Sub Workbook_Open() Dim lpBuff As String * 25 ret = GetUserName(lpBuff, 25)...

OK

Thank you combo. It was listed as an installed add-in. I deleted it and that solved the problem. I am not sure how I "installed" it. It was not intentionally installed by me, anyway. Thanks again.