Results 1 to 4 of 4
  1. #1
    Djack is offline Novice
    Windows XP Access 97
    Join Date
    Sep 2011
    Posts
    2

    Access 97 windows xp conflict????


    I have moved an epos database from and old windows 98 machine to a newer (slightly) windows xp machine. (only upgraded to xp because another package which communicates with cash registers is DOS based) The database runs ok apart from one problem. A piece of code refers to a file with the following -
    "*00000.csv" but this keeps coming up with a run-time error 5. If I change the wildcard to the exact file name it runs perfect, if I delete the .csv part it runs perfectly. Runs ok on the windows 98 machine, just a problem on the windows xp machine. The File name changes every day hence the * wildcard. Any ideas what can be causing the conflict?????

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What is the rest of the code? Are you using LIKE or DIR()?

  3. #3
    Djack is offline Novice
    Windows XP Access 97
    Join Date
    Sep 2011
    Posts
    2
    The section of code is as follows-


    strSalesdldPath = "c:\Bleep\Salesdld.csv"
    FileSearch.NewSearch
    FileSearch.LookIn = "C:\Bleep"
    FileSearch.FileName = "*00000.csv"
    FileSearch.FileType = msoFileTypeAllFiles
    If FileSearch.Execute(msoSortByLastModified, msoSortOrderAscending) > 0 Then
    intNoofFiles = FileSearch.FoundFiles.Count
    strMostRecentOrigFile = FileSearch.FoundFiles(intNoofFiles)
    FileCopy strMostRecentOrigFile, strSalesdldPath
    End If

    Sorry I didn't write the code I'm only the one that has to update the computer and I only have limited knowledge on it.

    When it hits the error i run the debug and it highlights
    FileSearch.FileName = "*00000.csv"

    When the line is changed to "2500000.csv" or "*00000"- it finds the file and runs successfully.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like an issue with the FileSearch library of which I and unfamiliar.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Write conflict - Access 2003
    By mafrank101 in forum Access
    Replies: 7
    Last Post: 10-10-2012, 07:44 PM
  2. Replies: 12
    Last Post: 02-09-2012, 02:27 PM
  3. Replies: 13
    Last Post: 07-18-2011, 10:05 AM
  4. Replies: 3
    Last Post: 07-15-2010, 05:53 PM
  5. Write Conflict Errors with SQL-Access DB
    By trb5016 in forum Access
    Replies: 5
    Last Post: 01-14-2010, 02:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums