Hi, I suspect a security issue is preventing a script from running in
an Access 2003 form, but have not found any acknowledgement of this
possibility in the Access group, so I thought I'd try asking here.
Since we made some security changes (e.g. deleting the administrator
account under which the file was originally created) an Access Script
like the one below always fails. The security level on the .mdb file
is set to low. No error messages appear other than my own MsgBox.
Does Application.FileSearch requires any knd of security credentials?
The reason I ask is because I recently found out that InfoPath in
Office 2003 does not allow VB Scripts to be run without some security
in place.
SourceDir = "G:\test\"
With Application.FileSearch
.NewSearch
.LookIn = SourceDir
.SearchSubFolders = False
.Filename = ".txt" ' also tried "*.txt"
If .Execute() > 0 Then ' doesn't go past here even
though files exist in G:\test
MsgBox "Success ??"
Else
MsgBox "Execute() - failed"
End If
End With