I'am using Access97 with Windows XP
When I use VBA code to get the full name of current
database it only gives me 8 characters long name
For example:
if My database name is "UCS (DESIGN) V-1.4.MDB" then
msgbox dir(currentdb.name) would only give me
"UCS(DESI.MDB"

does any one know why this is happening.  It was OK when I
was using Windows 98 but since I have changed my PC to
Windows XP, I can't get this to work.  I need this to find
the full path of Current Database and then then user it as
current directory.  

I'am unable to do this task because it returns totally
different file name of path.
could some one help please.