R
Rodney Kimber
I have an Access 2003 database that has many linked tables in it. I need to distribute this database on a PC that is using Access 97 so I went in and chose Convert Database -> To Access 97 File Format and specified a new filename
It took a while for the conversion and this worried me. I had a look at the file attributes of the original Access 2003 file and the new Access 97 file and the original was 3.5 megs and the Access97 file was 36megs. After doing some investigation I realised that the tables were no longer linked and in fact they were now local tables within the mdb file and all the data had also been moved across
Can anyone explain why this is happening? Is it possible to keep linked tables as linked table when converting an Access 2003 MDB file to an Access 97 MDB file? Is this a bug?
It took a while for the conversion and this worried me. I had a look at the file attributes of the original Access 2003 file and the new Access 97 file and the original was 3.5 megs and the Access97 file was 36megs. After doing some investigation I realised that the tables were no longer linked and in fact they were now local tables within the mdb file and all the data had also been moved across
Can anyone explain why this is happening? Is it possible to keep linked tables as linked table when converting an Access 2003 MDB file to an Access 97 MDB file? Is this a bug?