Acc2000 ENVIRON function won't work with Acc97 converted databases

[jsteven]

The ENVIRON function returns dos set variable values. For example, in the debug screen, type ? environ("temp&quot and you get something like "c:\windows\temp". In Access2000, if I create a new database and do the environ function, it works. However, in Access2000, if I open a 97 database and convert it to 2000, and do the environ function, I get an error that the function can't be found.

 

[DougP]

I have not gotten any database made in Access '97 to work in Access '2000. Period... Nothing, Zilch, Nada.<br><br>If you create the database from Scratch in Access 2000 it works fine. If you Convert it from Access '97 its completely lost.<br><br>I think the people at Microsoft have a LOT of work to do. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[jsteven]

I got it to work by:<br>Create a new database in 2000.<br>Click File, Get External Data, Import.<br>Select the Access97 database, then click Import.<br>Select objects desired on each tab and import them.<br>