I need access to data from QB, but I am in a multi-user, multi-site enviroment, so I do not want to use a linked table, I can do an ado connect, but I just need the contents of the customer and vendor table refreshed.  The transferdatabase command in access seems like the perfect answer.  Has any one got it it to work, i get hung with the source name. 

Thank you Mike

I am sorry I did not explain in the above post that I am using QODBC to connect to both Enterprise and QbPro.

thank you

To run the TransferDatabase action in Microsoft Visual Basic, use the TransferDatabase method of the DoCmd object.

This example links the QODBC database table Customer to the current database:

DoCmd.TransferDatabase acLink, "ODBC Database", _
    "ODBC;DSN=QuickBooks Data;LANGUAGE=us_english;" _
    & "DATABASE=pubs", acTable, "Customer", "dboCustomer"

You can use the TransferDatabase action to import or export data between the current Microsoft Access database (.mdb) or Microsoft Access project (.adp) and another database. The TransferDatabase action is similar to pointing to Get External Data or Export on the File menu of the Database window and clicking Import or Link Tables. You can use these commands to select a source of data, such as an Access database or another type of database, a spreadsheet, or a text file. If you select a database, one or more dialog boxes appear in which you select the type of object to import or export (for Access databases), the name of the object, and other options, depending on the database you are importing from or exporting or linking to. The arguments for the TransferDatabase action reflect the options in these dialog boxes.

For Access databases you can also link a table to the current Access database from another database. With a linked table, you have access to the table's data while the table itself remains in the other database.

DoCmd.TransferDatabase acLink, "ODBC Database", _
    "ODBC;DSN=QuickBooks Data;LANGUAGE=us_english;" _
    & "DATABASE=pubs", acTable, "Customer", "dboCustomer"

Where do I type this in Visual Basic? In my the VB code in my Access database somewhere? In VB Demo? Do I create a new table and then type in the code? Will this allow me to cascade update my access tables and enforce referential integrity if a record (such as a customer or item name) changes in Quickbooks? Thanks!