Access and ERP9

Hi,
I've installed EnterpriseOne 8.9. I'm using Microsoft Access 2000 to access, through ODBC, UDB DB2 8.1. If I link a table and open it I'll see all record filled with "#deleted". Instead if I import this table in Access I see all record correctly. Is it a problem of unicode format on UDB database? If yes, how can I show correctly information linking a table on UDB? Is there another easy tool (not Micorsoft Access) to access information on UDB (UDB tools are not so friendly).
Thanks Gigi

EnterpriseOne8.9, UDB DB2 8.1

For EnterpriseOne 8.9, didn't JDE replace Access with desktop version of SQL server?

From reading Best Practices website in KG, I thought that Access could no longer be used with EnterpriseOne 8.9.

Yes, of course, but I'm searching a friendly tool for consultant to access database server (UDB) to submit query. I don't believe that consultant wil use UDB client.
Gigi

Try searching the WEB for MySQL - a small free standalone program. Very friendly. Should work with DB2...

Regards,
Alexander Pastuhov
Pastuhov Consulting Pty. Ltd.
E-Mail: [email protected]
Mobile: 0414 453 433
WWW: http://www.pastuhov.com.au/index.htm
CNC Consulting and Software Tools for OneWorld®
Check out our Special Offers at:
http://www.pastuhov.com.au/special_offers.htm

Mind my asking, Alex, how do you connect DB2 to MySQL?
Thanks,

Oups, my mistake - WinSQL and it's the other way around: you use this WinSQL to connect to DB2.

Regards,
Alexander Pastuhov
Pastuhov Consulting Pty. Ltd.
E-Mail: [email protected]
Mobile: 0414 453 433
WWW: http://www.pastuhov.com.au/index.htm
CNC Consulting and Software Tools for OneWorld®
Check out our Special Offers at:
http://www.pastuhov.com.au/special_offers.htm

Many Thanks Alex
Gigi

Thank you, Alex; you're (always) right (again), or the other way around