Solved

cant link tables in access 2003 to my AS400 machine

Posted on 2008-06-19
4
415 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

786 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