Link tables 2002 to 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy - 23 Nov 2004 07:59 GMT

done a databese in 2002 and now need to use yhe program in 97
the problem is more than 1 user is using the database, and the file system
of Access 97 is Fat32, witch doesn't work with accesss 2002 file system.
that means, i can't link tables 97 to 2002. only converting
At this point i open at any ideia.
Is it possible to convert and import the tables to 97, every time that you
open the 97 project.??
thank u..

Reply to this Message

Rick Brandt - 23 Nov 2004 15:00 GMT

> done a databese in 2002 and now need to use yhe program in 97
> the problem is more than 1 user is using the database, and the file system
[quoted text clipped - 3 lines]
> Is it possible to convert and import the tables to 97, every time that you
> open the 97 project.??

While it is true that Access 97 cannot link to tables in newer versions it has
nothing to do with Fat32 or anything else about the file system. It is just
that the newer versions have a different internal structure very similar to the
way you can't open a Word file created in Word 2003 with Word version 4.

If you want to have mixed front ends linking to a common back end file then the
back end file has to be in the oldest version of the front ends you plan to use.
Newer front ends will have no problem linking to the older file's tables.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message