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
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?
I am wondering if there is a more efficient way to do this given the large number of records. (Also linked tables are not an option. )
Linked Table Manager, Select All Choose a Be (back end tables) 2007 Access db
Problem: each and every table asks for the user to re-select the Access 2007 Be path again, and again, and again.
However: Instead of Select All, check 3 to 8 tables at a time and it will update just the 3 to 8 all at once (as it normally should).
Earlier this week, it behaved properly dozens of times and updated all tables (select All) with a single click.
Not using ODBC, just directly linking Access 2007 to Access 2007.
Simply I want to get displayed students details on the form just entering his student number on the top of form.