Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Acc2000 ENVIRON function won't work with Acc97 converted databases
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>- jsteven
- Post #3
- Forum: Microsoft: Access Other topics
-
Acc2000 ENVIRON function won't work with Acc97 converted databases
The ENVIRON function returns dos set variable values. For example, in the debug screen, type ? environ("temp") 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...- jsteven
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
How to call a query located in another database?
Thanks for your response. I have tried that, but I don't get the right numbers. Is there a way to call or execute a query that is in another database?- jsteven
- Post #3
- Forum: Microsoft: Access Other topics
-
How to call a query located in another database?
I have two databases. The first has the data and the query. The second needs the results of the query. I want to call the query from the second database. How do I call the query in the first database from the second database? Note: I tried copying the query to the second database and make links...- jsteven
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
