Linking to Access 2003 tables from Access 97 frontend

[spikingjc]

Hi All,

I'm converting an Access 97 application to Access 2003 (both frontend
and backend). I have one specialized computer which can only run
Windows 98. Therefore, I must keep the application running on that
machine in Access 97.

I cannot find any reference on whether I can link to the Access 2003
backend from an Access 97 frontend. Does anyone know whether this is
possible? If yes, how?

Thanks

JC

 

[Rick Brandt]

Hi All,

I'm converting an Access 97 application to Access 2003 (both frontend
and backend). I have one specialized computer which can only run
Windows 98. Therefore, I must keep the application running on that
machine in Access 97.

I cannot find any reference on whether I can link to the Access 2003
backend from an Access 97 frontend. Does anyone know whether this is
possible? If yes, how?

Thanks

JC

No. Just keep the back end in 97. Your new 2003 front end won't care.
Unless you wanted to use any of the new Jet 4 DataTypes in which case you
must upgrade the back end to at least 2000. You can run 2000 and perhaps
even 2002 on Windows 98 (2002 requires 98 second edition I believe). That
would solve the problem.

 

[Guest]

It's easy enough to remember as follows:

You can look BACKWARD to older versions, but NEVER FORWARD. Actually, that's
intuitively obvious. How would Access 97 know what format Access 2003 tables
would use?

Think about it....

 

[JC]

It's easy enough to remember as follows:

You can look BACKWARD to older versions, but NEVER FORWARD. Actually, that's
intuitively obvious. How would Access 97 know what format Access 2003 tables
would use?

Think about it....





- Show quoted text -

I understand natively you cannot read a 2003 format with 97 Access.
The point of this thread is to see if any one have found a way through
ODBC or other methods to read the data.

However, the suggestion from Rick to run Access 2002 or Access 2000 on
the Win98 machine will do the trick.

Thanks

JC