sanctified
asked on
.MDA File Verification for Access 2.0
I would like a function to check the user's .MDA file uopn entry of my database on a network server. I want them to use an MDA file located on the server to enter the file. I tried this:
function IsItTheCorrectMDA()
if syscmd(SYSCMD_INIFILE)<>"K :\Temp\uni que.mda" then
msgbox "Sorry you entererd using the wrong MDA.Application terminates.."
docmd quit
end if
end function
but it doesn't work. Even when I use the correct MDA file I get the message that I am not using the correct one. Any ideas?
function IsItTheCorrectMDA()
if syscmd(SYSCMD_INIFILE)<>"K
msgbox "Sorry you entererd using the wrong MDA.Application terminates.."
docmd quit
end if
end function
but it doesn't work. Even when I use the correct MDA file I get the message that I am not using the correct one. Any ideas?
ASKER
ST,
Almost, it doesn't quite work. I can use any MDA that I want to and it will still say "LDB was found, you're running correct MDA" Try again...
Almost, it doesn't quite work. I can use any MDA that I want to and it will still say "LDB was found, you're running correct MDA" Try again...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
E for effort!!
However, you can use the coding like this:
If Dir("K:\Temp\unique.LDB") = "" Then
msgbox "You're running wrong MDA"
else
msgbox "LDB was found, you're running correct MDA"
end if