I need to run a query from inside a diffrent Access database. any idea.
I know that i should just link to the table and make my own querys but the other database is old and a real mess, somthing i dont want to get involved in. any help please
"Old" may be the roadblock. If the db is not the same ver, this may not work, but for ver '95 & '97 you just define the db (Dim ... as database) and instantiate the query (set ...). I have never attempted this except with ver '95 & '97, so I do KNOW that it wouldn't work with the other versions, but Uncle Billy NEEDS to make money, so I suspect that he just let the '95 '97 thing slip through (after all it wasn't a real ugrade anyway).
The alternative would be to (perhaps) make a copy of the "old" ver and attempt to import objects from that into a 'new' ver. If you do it sloooooowly and carefully, you should be able to get the tables and queries to translate nicely. Some code/forms/report things won't do as well.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.