ODBC connection?

[wh00t]

Hi

I would like to set up an ODBC connection to an AS/400 to retrieve info, I know how to do this and have tested some links succesfully but...

if any data is changed in the Access db, the change is reflected on the AS/400 file. Is there any way that I can copy the data to a seperate table? as with the ODBC connection, the data is not stored in access, but on the AS/400.

any assistance would stop my headaches

 

[Freddy]

Try importing the database instead of linking. A copy of the table will reside within your access db and you change change or modify to your hearts content.

 

[Chris66]

If you create a logical file from the AS/400 you won't have to worry about the data going from access to your AS/400 file. The downside to this is you won't have real time data. Hope that helps. Otherwise it is possible to set your AS/400 up for a 1 way reading, how, though I do not know. My company has direct connectivity.

 

[wh00t]

Thanx for the replies

I'm gonna try an append query to copy to another table, I want to make this as simple as possible for the users. i.e. users dont have to do anything to get the data.

 

[chrisjrice]

I have recently developed an access reporting tool that uses ODBC to connect to the AS400 using link tables. You should be able to change your ODBC properties to Read Only(Select Statements Only). Are you using Client Access? You should be able to go into Data Sources (ODBC) which can be found on the control panel under Windows. If you then configure your current ODBC connection and click on the Other tab there are a list of Read/Write options. Just set the option to Read Only. If you then try to manipulate the Link table through Access it will display a violation error and stop you from updating the data on the AS400.

Hope this helps

Chris Rice

 

[wh00t]

the problem being keeping the data on the as/400

there will be a very large amount of data on the as/400, but that will need to be deleted from the as/400 but kept on the database, that is why I wanted the info transferred to a table, i also need the user to be able to make entries for each of the records transferred from the as/400.
Append query seems to do the job I want, and it's easier at the user end than using client access, as the way we have client access set up on the user pc's is very restrictive, and getting the db to do all the work will make it easier user side.