|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 1st, 2005, 09:52 PM
|
|||
|
|||
Access 97 using a saved query in MS Query
Hello all,
I am hoping someone can shead some light here. I am using the ODBC Client Access driver to access some information from the iSeries. I have set up a query in MS Query and I am hoping I can use this as apart of my Access 97 database. Since the iSeries file has 637 fields, Access 97 can only handle 255 of them. Since I cannot see all the fields I need in Access, I used the MS Query tool to provide me to select the fields I need, with the help of the iSeries developer. Can I use my saved MS Query file in my Access database? If not, how do I work around it? Using VBA? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
| saved queries based on other saved queries vs. one big query in a form's module using DAO | Richard Hollenbeck | Running & Setting Up Queries | 5 | September 23rd, 2004 08:38 PM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Linear Mode
