The above command returns something like:
C:\Documents and Settings\tim\My Documents\Access_Apps\Campaign\Data.mdb
I always have something like currentdb.name and the equivalent for
linked tables on my app splash form, which usually doubles as and "about
this application" form as well so that users can see what files are the
front and back end (and their size as well).
I only begand using WinXP Pro this past Fall. For win98, the above was
fine, but with the advent of personalized settings, I'm wondering would
it be more appropriate to return, for the above example, just:
My Documents\Access_Apps\Campaign\Data.mdb
because for most users, they will be doing stuff within their log in
name/directory under documents and settings. I suppose it would be
relatively easy to parse the result of CurrentDb.Name to get the revised
file location.
What do other developers do with WinXP?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
