[AccessD] DIR Command Failing-but not everywhere...

Yes, it is most likely caused by a drive that has a letter on the PC, but no
media in it, such as a DVD or CD Rom drive.  

Steve 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of O'Connor,
Patricia (OTDA)
Sent: Tuesday, October 11, 2005 11:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] DIR Command Failing-but not everywhere...


Did you get an answer for this? A co-worker is getting the same error in a
VB program he created.

Thanks


******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at otda.state.ny.us
*(w) mailto:aa1160 at otda.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Greg Smith
> Sent: Monday, October 03, 2005 10:26 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] DIR Command Failing-but not everywhere...
> 
> Hi everyone!  Hope you all are having a GREAT day!
> 
> I've got a real puzzle here.  I'm using the Dir() command (Access 2003
> module) to find if a filename exists in a specific directory, or not.  
> The exact syntax is shown below.  The code is checking for a specific 
> file in two different directories (one exists at work, and one at the 
> customer's), and if it can't find that file in either location, the 
> application warns the user that it's not available right now and 
> closes automatically.
> 
> The code is:
> 
>     strFileName = Dir("c:\MyData\chkfile.ozx")
>     strFileNameBHC = Dir("G:\BHCRecorder\Scripts\chkfile.ozx")
>     If strFileName <> "chkfile.ozx" And strFileNameBHC <> 
> "chkfile.ozx" ...
> 
> This code works perfectly at work and at the customer's.  So, you may 
> ask, what's the big deal?  Well, I also work on this at home, and I 
> just (within the last 3 weeks) reformatted my home computer (winXP), 
> reinstalled everything (supposedly...), and service packed everything 
> up to date.
> 
> When I run this application at home, it fails on the Dir() command 
> where the directory doesn't exist.  Since I'm at home, for example, I 
> don't have a "G" drive and it fails on that one with the message "Bad 
> Filename or Number", and the error number is 52.
> 
> The application is identical in both places...that is, I take a copy 
> home and put it on my computer, relink all the tables to the BE and 
> everything else is the same.
> 
> Either I've not installed something correctly at home, or I've not 
> installed something I need to have.  Or both.  The references are all 
> the same and none are missing at either location.
> 
> Anyone else see this before?
> 
> TIA!!
> 
> Greg Smith
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com