RE: Offline price load

Lloyd,

The ODBC definition may need the system name changed, sounds like you have a
new system.  Did they change the system name?  If yes, check the ODBC
defined for your MS Access linked tables, is that system name correct? If
not change it to the new system name.

If the system name didn't change, did you set-up the MAPICS environment
different (MM vs MT, AA, etc.)  Then the library may need to be checked,
(AMFLIB, vs. AMFLIBTm vs AMFLIBA)

Also, using the current version of client access ODBC may help as Teresa
suggests.

Best Regards, 
Ed Kandel
 

-----Original Message-----
From: Teresa Biby [mailto:TBiby@xxxxxxx] 
Sent: Thursday, September 23, 2004 9:03 AM
To: 'MAPICS ERP System Discussion'
Subject: RE: Offline price load

I tried this with the new 400 OS V5R3 and latest 5788 of Mapics and did not
have any trouble.  I linked the MBLKCPP and our own built price book file
and it worked.  I haven't had any ODBC issues since upgrading the OS.  Did
you upgrade the client access express version to 5.3 also?  I don't think
that is necessary but it may be worth a try.  

-----Original Message-----
From: LDegnon@xxxxxxxxx [mailto:LDegnon@xxxxxxxxx] 
Sent: Tuesday, September 21, 2004 12:00 PM
To: Mapics-l@xxxxxxxxxxxx
Subject: Offline price load

Does anyone out there have a stable method for populating the MAPICS 
off-line price files?  I used to use ODBC with Microsoft access to cut and 
paste-append the contents of an Excel spreadsheet into the off-line file. 
Now that I am on our new AS/400 with new O/S and Level 5788 of MAPICS, it 
no longer works.  In fact, I cannot even use ODBC to manually enter or 
modify a record...

Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx 
www.AmPro.com 
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.