Which product doesn't like this query ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi;

I keep getting an error saying my table or object is locked.

I am trying to select into Excel from an Access query.

Ex:
Select * INTO [Excel 8.0;Database= ' " & holdflname & " '].[age_in_days]
from [age_in_days].

I used this Microsoft article for my synatx example :

"How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With
Visual Basic .NET"


Thanks for your insights,
 
I am trying to select into Excel from an Access query.
Click to expand...

The Ninth District Federal Court is the entity that doesn't like the
query, if I recall correctly.

Microsoft lost a lawsuit last Spring; as a result, they had to remove
the ability to update Excel spreadsheets from Access.

John W. Vinson[MVP]
 
Microsoft lost a lawsuit last Spring; as a result, they
chose to
remove the ability to update Excel spreadsheets from
Access.
Click to expand...

Like the Java decision (which ended support for one of
the Access developers editions), it was an economic or
strategic decision following on the legal decision.

(david)
 
Anyway :~), I have a question:

I had a similar experience to that reported here, which
I resolved by rolling back the patch, but I was assured
that the update was NOT the cause of my problem ("I've
been using Excel and Access since the patch, and I've
never had any problem, the patch only affects updates
from Access, not etc etc"). Since my development machine
has so many products installed, un-installed, re-installed,
patched, un-patched, re-patched, I was never able to say
for sure if I just had installation problems, or what the effect
of the patch was on DAO append and update queries.

Is there a consensus opinion on this now?

(david)
 
Back
Top