Linking with IBM AS400(iSeries) Tables
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Dim stConnect As String
If Len(stUsername) = 0 Then
stConnect = "Description=SQLDSNName" & vbCr & "SERVER=MySQLServer" & vbCr & "DATABASE=MyDB" & vbCr & "Trusted_Connection=Yes"
stConnect = "Description=SQLDSNName" & vbCr & "SERVER=MySQLServer" & vbCr & "DATABASE=MyDB" & stDatabase & vbCr
DBEngine.RegisterDatabase "SQLDSNName", "SQL Server", True, stConnect
Which works perfectly, however there are other tables in the Application that also pull from a live AS400 table.
I tried editing the code above for the AS400 table but unfortunatly i've had no joy so I wonder if anyone knows of any code similar to above that would automatically create a ODBC DSN for a AS400 table?
I would prefer not to use a DSNless conenction
Transfer Type: Import
Database Type: ODBC Database
Database Name: ODBC;DSN=mvxr10;TABLE=DATA09
Object Type: Table
Structure Only: No
Now I have the table with the data I have added relationships so other tables can get data from this table, however in the AS400 this data can be updated, is there away of updating the table data using a macro without having to delete the table.
If I re-run the above Macro it just creates a new table which is no good.
I'm trying to all this in order to avoid installing DB2 Connect software on each machine and configuring it on each machine that would need to use this database. I would rather that server that has MSSQL talks to Mainframe instead each individual computer.
The linking between the databases are getting deleted and tables are being deleted even subform linking are being removed.
What can I do to resolve this issue? We have hidden the Database Windows, but still no success.
For this database I have consists of five tables, all with the same parameters on the primary key. Four of the five tables are used for data entry in various forms while the fifth haspreloaded data on what relates to the previously mentioned tables.
So far I have no trouble linking the four tables used for data entry together. I'm using a one-to-one relationship between the primary keys. The issue is with the fifth table linking to anyone of the four tables used for data entry.
I'm having no luck with designing and running a query that matches up correctly.
I've gotten almost everything done except for linking the applicants name to the report in my query.
I'm pulling data from 6 tables which are linked by applID. My problem is none of these tables that contain applID have the applicants name. The table that DOES have the applicants name is not organized by applID; its organized by borrowerID within my Borrower table, which does not contain any applID.
I have one other table who's purpose is to put an applID to a borrowerID.
I need some help in somehow linking those two within my query.
First is that the spreadsheets have many tabs and within each tab are “tables” that contain the data. Thus, I believe that I need to designate named ranges for where to get data. And I believe the idea of linking to Access is out of the question considering the issue of multiple “tables’ within tabs in the spreadsheet.
(And I really don’t want to think about linking and then unlinking tables via code.
Maybe I just stated two problems, the idea of named ranges and the seeming unavailability of linking the tables to access.
Second, some of the “tables” in Excel have the field names vertically in a row with the data to the right. I have never tried to append data that was not in the traditional layout of field names spread horizontally in a row with the data below it. Is there a way to deal with that in the append query?