Big problem with Tables

[No Can Do]

hello,

I'm new with MS Access and I'm having a problem with it;
in company where I work, they got installed UNIX on server, they are programming with COBOL and they use FLEXGEN.
I was told to study RELATIVITY and MS Access and do some queries, but I found out that linking tables with ODBC is to slow, becasue databases on UNIX are huge and I couldn't change primary key, wich I found out was crucial for Access working so slowly, then I tried importing tables and I change primary keys as I needed to and then Access was working just fine. My problem is that I need to update those tables every night. In Access database that i created are 5 tables related, I was trying with macros, but i can't update tables.

Any suggestions?

 

[No Can Do]

I will try to be more clear;
in company where I work, they give me a task to do some queries in MS Access, so they could use and work with data that I would provide in MS Excel.

Problem with key is as follows; I used Relativity to get connections between UNIX and Windows. The program on UNIX is written in COBOL and RELATIVITY uses his primary keys in linked tables in MS Access, that's my problem, becasue in some tabels (TABLE1) I need two keys example year and number, the primary key written in COBOL is year and number together, I need them separated to make MS Access work more afficently, because I need to do relationship with another table (Table2), and that table is using primary key made of year, number and position, I had to make again two primary keys in this table (Table2), year and number separate, because year and number in Table1 and Table2 are the same, but the data is different.

When I used imported Tables, there was no problem with keys, becasue I could make them myself. I tested with imported tables and it worked OK. So I tried to update imported tables with macro, but instead writing in Table Example it made new Table1 Example1. I couldn't deleted Table1 Example, because it was related to another table (Table2).

What version of Ms Access are you using?
I'm using MS Access 2000

Is it posible to update imported tables or not?

I hope I was more clear this time

Thanks for your anwsers and suggestions

 

[ecniv]

So have one field combined as the matching key to the unix system and two fields together for the Access part of the system. Both should be the same for example:

UnixID Year Number -- rest of data fields
20041002 2004 1002
20030001 2003 0001

Then you should be able to link either way.. unix way prolly being read only.

As to saving data back to unix... I don't think they'd let you. Someone else would have to enter the data.


Vince

 

[No Can Do]

thank you for replay,

if I understood wright, than u said taht I don't need to change primary keys.

but my problem is;

Table1
UNIX ID Year Date
20041002 2004 1002
20031230 2003 1230

Table2
UNIXID Year Date Position
200410021 2004 1002 1
200312303 2003 1230 3

u see, UNIXID's in table1 and table2 are not the same and that's my problem, that's why I made my primary keys in Access

thanx for your answers

regards