asked on

Error 3423

Hi,

We have our source tables (Access 97) in our server. And the front end stored on each of the Terminals (Access 97).
We get Error 3423 when we try to link them via ODBC in Access. Can this be done, we dont just want to attach the tables.

Im afraid ODBC is something I know very little about, this is a huge gap in my knowledge.

Any pointers would be great.

threeps99

ASKER CERTIFIED SOLUTION

smilitaru

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

threeps99

ASKER

Ok,
is there a nice workaround? What do other ppl do?

smilitaru

For an workaround, try with classic linked tables but try to don't use functionalities that not exist in a ODBC Source. I don't know what this functionalities are, but is better if you design an application knowing what format for data have. If you want to upgrade an application you must verify your coding.
I don't know what means ppl.

threeps99

ASKER

Sorry smilataru, ppl = people!

So basically I cant do that eh? With linked tables, the performance is really slow. I was hoping ODBC would help solve that.

smilitaru

If you do this for speed reasons I can give you a decided answer. Through ODBC will go any time slower than linking direct tables. I thought to other reasons for using Access ODBC inm Access but if you use it just for speed the answer is clear. If you want to find what says other people reject the answer and wait for others answers. If you don't receive any better answer write me a comment and I repost my answer for you.

threeps99

ASKER

Ok smitarau,

It seems I cant get what I want... : ( :( :(