Solved

cant link tables in access 2003 to my AS400 machine

Posted on 2008-06-19
4
414 Views
Last Modified: 2008-08-19
i cannot link tables in access 2003 to my AS400 machine, i used to be able to easily with access 97. but access 2003 just blocks everything.
I have tried changing sandbox Mode from 3 to 0 and even 1 but this doesn't seem to change anything
it stops with the usefull error message "Reserved error (-7756); there is no message" anyone have any clues?
could it be the ODBC driver not working with Access 2003?
0
Comment
Question by:Grazer2
  • 2
4 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 45 total points
ID: 21820601
My ODBC drivers have been dropped off during the migration to 2003 from 97 (there were versions 2000 and 2002 in between).

Can you create an new dsn and test the connection? You may have to find a new driver on the net for this.
0
 
LVL 16

Assisted Solution

by:theo kouwenhoven
theo kouwenhoven earned 40 total points
ID: 21873185
Why using access, if there is an AS/400 with DB2 that is several thousand times faster end it's relyable. Why using MS if you don't have to?

Regards:)
Murph



0
 

Accepted Solution

by:
Grazer2 earned 0 total points
ID: 21873503
DB2? don't have/use it, i am combining data tables from excel and other sources too.

i eventually managed to get it to accept connection and link tables, by:
updating office 2003 to office service pack2
installed the latest ODBC driver for the i series
set the sandboxmode to 0

this has also stopped it suggesting i upgrade to jet 4 version 8, but always asks about blocking unsafe commands!
ms although cumbersome provides the end users with pretty spreadsheets
0
 
LVL 16

Assisted Solution

by:theo kouwenhoven
theo kouwenhoven earned 40 total points
ID: 21873704
You allways can make pretty spreadsheets, with data retrieved directly from the AS/400 :)

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now