+ Reply to Thread
Results 1 to 1 of 1

Database code won't work on one machine

  1. #1
    Registered User
    Join Date
    03-02-2009
    Location
    Charleston, SC
    MS-Off Ver
    Excel 2002
    Posts
    1

    Database code won't work on one machine

    I wrote an Excel VBA program for an Excel spreadsheet that acts as the front end for a simple dBbase III database. The user fills in a table on one worksheet of the workbook in order to select the desired records, and the VBA program formats a query which is sent to the database. The returned records are displayed on a second tabbed worksheet. The Excel .xls file resides on a network drive and is accessed by a number of people using different computers on the company network. Of this group of computers, all running Excel 2002, there is ONE which throws the error:

    " is not a valid name. Make sure that it does not include invalid characters and that it is not too long.

    A fragment of the offending code (no spaces between dBase and III in the first line):

    Please Login or Register  to view this content.
    It is this last line that causes the error on only one of 5 different machines.

    The query$ is formed correctly. The VBA project references that are checked (including M. Excel 10.0 Obj Lib and DAO3.6 Obj Lib)are identical on all machines. I think DAO3.6 is functional because if unchecked there is another kind of error. The dbOpenDynaset value is identical on all machines.

    Does someone have an idea as to why this should fail to run on one specific machine, or any ideas about how to debug this? Wits End!
    Last edited by edt3; 03-02-2009 at 10:43 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1