?
Solved

cant link tables in access 2003 to my AS400 machine

Posted on 2008-06-19
4
Medium Priority
?
421 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 180 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 160 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 160 total points
ID: 21873704
You allways can make pretty spreadsheets, with data retrieved directly from the AS/400 :)

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

764 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