Solved

cant link tables in access 2003 to my AS400 machine

Posted on 2008-06-19
4
413 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
You allways can make pretty spreadsheets, with data retrieved directly from the AS/400 :)

0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

771 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

16 Experts available now in Live!

Get 1:1 Help Now