Link tables from Access 97 to Access XP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.


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
Click to expand...

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Swamy said:
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.
Click to expand...

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
Click to expand...

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 <[email protected]>
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?
 
Swamy said:
Thanks. Do you know how I can do this programmatically from an Access XP DB
to the A97 table?
Click to expand...

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 <[email protected]>
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.
 
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.



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

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Thanks

jacksonmacd said:
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.





**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Click to expand...
 
Back
Top