I've linked to my AS400 system through ODBC. I've got a few tables linked. Some of them will allow me to open them and/or do queries and some just give a little blink of hte hourglass and won't let me access them. They don't give errors or anything, just - nothing happens. I think it's possibly a memory problem due to a huge amount of records, but I don't know.
When I add the table to a query in design view, it shows the field names, etc. But when I try to run the query it doesn't do anything.
Any ideas?
When I add the table to a query in design view, it shows the field names, etc. But when I try to run the query it doesn't do anything.
Any ideas?