Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

cant link tables in access 2003 to my AS400 machine

Posted on 2008-06-19
4
Medium Priority
?
422 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What we learned in Webroot's webinar on multi-vector protection.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

618 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