Was there a way to run a FileExists check from MS Access 2.0?

What utility was used in Access 2.0 to
check for the existence of a file on disk?

Nov 13 '05 #1

2256

No utility needed:
If Len(Dir(strFileName) > 0 then '==>> File exists

--
Hope this helps
Arno R
"MLH" <CR**@NorthState.net> schreef in bericht news:a6********************************@4ax.com...

What utility was used in Access 2.0 to
check for the existence of a file on disk?

Nov 13 '05 #2

Douglas J. Steele

You forgot a closing parenthesis:

If Len(Dir(strFileName)) > 0 then '==>> File exists

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Arno R" <ar****************@tiscali.nl> wrote in message
news:42**********************@dreader2.news.tiscal i.nl...
No utility needed:
If Len(Dir(strFileName) > 0 then '==>> File exists

--
Hope this helps
Arno R
"MLH" <CR**@NorthState.net> schreef in bericht
news:a6********************************@4ax.com...

What utility was used in Access 2.0 to
check for the existence of a file on disk?

Nov 13 '05 #3

MLH

Many thanks for your assistance.

Nov 13 '05 #4

Arno R

Indeed Doug, I stand corrected,
Arno R

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> schreef in bericht news:Mr********************@rogers.com...

You forgot a closing parenthesis:

If Len(Dir(strFileName)) > 0 then '==>> File exists

Nov 13 '05 #5

Similar topics

FSO FileExists Method

by: David P. Jessup | last post by:

I would like to know if I'm correct in the way I coded this: Function CheckFileExists(sFileName) If (fs.FileExists(sFileName)) Then CheckFileExists = True Else CheckFileExists = False End If...

ASP / Active Server Pages

FileExists FSO

by: Poppy | last post by:

If I do the following : ------------------------------------ set fsd=Server.CreateObject("Scripting.FileSystemObject") if fsd.fileexists("C:\inetpub\wwwroot\mysite\test.doc") = true then...

ASP / Active Server Pages

\\server\file.ext does not like objFSO.FileExists()

by: Bob | last post by:

When a file is local to the ASP application, I can use the following code to test if the file exists: Dim strFileName, blnFileExists, objFSO strFileName = Server.MapPath( "\MyFiles\test.doc" )...

ASP / Active Server Pages

annoying delay during refresh of aspx web page with ODBC Access query on IIS Windows 2003

by: Wolfgang Kaml | last post by:

Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...

ASP.NET

Security Settings of System.IO.FileExists, I should see files

by: Christian Blackburn | last post by:

Hi Gang, I am unable to get either system.io.fileexists() = true or Dir() <> "" to work in my ASP.net/VS 2003 web project. Can someone tell me or point me to some instructions on how to enable...

Visual Basic .NET

Check Box clearing

by: scprosportsman | last post by:

Please help guys, i am trying to set up a database here at work and im fairly new to access in terms of writing functions and queries and stuff. I have 2 different places on my design that will...

Microsoft Access / VBA

Check permissions on Folder

by: Fred W. | last post by:

When my application starts I need to check folder permissions to ensure they have "Full Control" before I let them proceed on. How can I check this permission. Thank you, Fred

C# / C Sharp

Check for "Write Access" on a file/folder in .NET

by: =?Utf-8?B?R2FuZXNoIE11dGh1dmVsdQ==?= | last post by:

Hello All, Our application write logs to a file in a folder. Before our application starts writing to that file, I want to check if the current user has write access to that file, for example,...

.NET Framework

Check all errors in code?

by: lovecreatesbea... | last post by:

Do you check all error conditions for all library calls in you code? Is it necessary to check all errors? Is it convenient to check all errors (or how to make code clean and readable with mass of...

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing