ODBC coughing on logging into access table

[Ogart]

Greetings:

An excel sheet pulls data from Access using ODBC. If the access application is closed, no problems. If it's open, I get the following:

"The database has been placed in a state by user "Admin" on machine xxxx that prevents it from being opened or locked."

The access file is set for pessimistic locking. All I want to do is pull information. Do I have to un-pessimistic lock that bad-boy for ODBC to pull the table I want? Is there a work around?

Any help would most definately be appreciated. Thanks in advance!!!

-Chris

 

[ineuw]

Yes, Close the Access application.

Win2000P/Acc2000 - It's best to stay with products that work.

 

[Ogart]

Bummer.

Is there a trigger to "push" data to that excel file instead of the excel file "pulling" data when it opens?

 

[PHV]

Take a look at the DoCmd.TransferSpreadsheet method.
Alternatively you may consider OLE automation.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244