Link tables from Access 97 to Access XP

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch. However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

No. Your XP database can link to tables from A97, but not vice versa.


On Sun, 27 Nov 2005 20:35:02 -0800, "Swamy"
wrote:

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch. However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

**********************

remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Swamy wrote:

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch.

I can understand not wanting to touch them, but (and assuming you've
properly BACKED UP your old database) have you tried to update your
Access 97 version to Access XP? Did you run into trouble, or are you
just afraid you might?

However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

I expect that there is no way for Access 97 to read anything written in
a later format, at least not directly. (But later versions of Access
can read or write Access 97 files.)

For ease of use & maintenance, I suggest that you choose one version of
Access (probably XP) and convert your files (both Access 97 and Access
XP) to its native format.

-- Vincent Johns
Please feel free to quote anything I say here.

Thanks. Do you know how I can do this programmatically from an Access XP DB
to the A97 table?


"jacksonmacd" wrote:

No. Your XP database can link to tables from A97, but not vice versa.


On Sun, 27 Nov 2005 20:35:02 -0800, "Swamy"
wrote:

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch. However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

**********************

remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Swamy wrote:

Thanks. Do you know how I can do this programmatically from an Access XP DB
to the A97 table?


Although I'm not sure it's a good idea (see my other posting), you could
export from Access XP the contents of any of its Tables into (for
example) a tab-delimited text file, then switch to Access 97 and import
this text file into Access 97.

-- Vincent Johns
Please feel free to quote anything I say here.

No. The problem in the DB is in production. It is created on every computer
our product is installed so, we do not want to affect the existing production
db in anyway.

"Vincent Johns" wrote:

Swamy wrote:

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch.

I can understand not wanting to touch them, but (and assuming you've
properly BACKED UP your old database) have you tried to update your
Access 97 version to Access XP? Did you run into trouble, or are you
just afraid you might?

However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

I expect that there is no way for Access 97 to read anything written in
a later format, at least not directly. (But later versions of Access
can read or write Access 97 files.)

For ease of use & maintenance, I suggest that you choose one version of
Access (probably XP) and convert your files (both Access 97 and Access
XP) to its native format.

-- Vincent Johns
Please feel free to quote anything I say here.

In a one-off situation, its a simple matter of using File Get
External Data Link from the AXP database. If you want to do it
programmatically using VBA, I believe it is the DoCmd.TransferDatabase
method that you want to explore. Check out the Help file for the exact
syntax.



On Sun, 27 Nov 2005 21:07:02 -0800, "Swamy"
wrote:

Thanks. Do you know how I can do this programmatically from an Access XP DB
to the A97 table?


"jacksonmacd" wrote:

No. Your XP database can link to tables from A97, but not vice versa.


On Sun, 27 Nov 2005 20:35:02 -0800, "Swamy"
wrote:

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch. However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

**********************

remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security


**********************

remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Thanks

"jacksonmacd" wrote:

In a one-off situation, its a simple matter of using File Get
External Data Link from the AXP database. If you want to do it
programmatically using VBA, I believe it is the DoCmd.TransferDatabase
method that you want to explore. Check out the Help file for the exact
syntax.



On Sun, 27 Nov 2005 21:07:02 -0800, "Swamy"
wrote:

Thanks. Do you know how I can do this programmatically from an Access XP DB
to the A97 table?


"jacksonmacd" wrote:

No. Your XP database can link to tables from A97, but not vice versa.


On Sun, 27 Nov 2005 20:35:02 -0800, "Swamy"
wrote:

Hi,

I have a DB in production created using Access 97. There is lot of data in
the existing db which we would not like to touch. However, under certain
conditions we need to use the new data in the new DB. Is it possible to
update the Access 97 DB in production such that it can conditionally look
into Access XP DB to look for data. Again, this is not always only under
certain conditions that are sent as parameters from the client (created using
DAO).

Regards,
Swamy

**********************

remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security


**********************

remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security