Testing for db existence

[Guest]

I have database named Testing.mdb in a directory and want to determine if
"Copy of Testing.mdb" exists in the same directory.

Thank you.

 

[Ken Snell [MVP]]

Check out the Dir function in VBA Help. You can use it to determine if a
file exists in a specific directory.

 

[Chris Reveille]

try
If Len(Dir("C:\filename")) > 0 Then
'File aready exists

Chris