Hvala [tabi] na pokušaju... ali... i te kako je to vezano u SP2 za Office 2003. Pitanje sam "davno" postavio, a i ja sam se malo više pozabavio s tim problemom i evo što pronađoh:
SYMPTOMS
In Microsoft Office Access 2003 or in Microsoft Access 2002, you cannot change, add, or delete data in tables that are linked to a Microsoft Excel workbook.
Additionally, you may experience this behavior when any one of the following conditions is true:• You build a query to retrieve data from tables that are linked to an Excel workbook.
• You build a form that accesses data from tables that are linked to an Excel workbook.
• You use DAO or ADO to update tables programmatically that are linked to an Excel workbook.
You receive the following message when you perform a query to update records in a linked Excel workbook:
Operation must use an updateable query
You receive the following message when you use DAO to programmatically update tables that are linked to an Excel workbook:
Runtime Error '3027' Cannot update. Database or object is read-only.
When you try to update the linked data in ADO, the message is the same, but the error number may be similar to the following:
-2147217911 (80040e09)
Kao uzrok stavljau da je:
CAUSE
This expected behavior occurs when either of the following conditions is true: • You have installed Microsoft Office 2003 Service Pack 2 (SP2) or any Access 2003 updates that were released after Office 2003 SP2.
For more information about Microsoft Office 2003 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
887616 (
http://support.microsoft.com/kb/887616/) Description of Office 2003 Service Pack 2
• You have installed the update for Access 2002 (KB904018) that is dated October 18, 2005.
For more information about the update for Access 2002 (KB904018), click the following article number to view the article in the Microsoft Knowledge Base:
904018 (
http://support.microsoft.com/kb/904018/) Description of the update for Access 2002: October 18, 2005
ako nekog interesira kompletno Microsoftovo pojašnjenje problema neka pogleda na
http://support.microsoft.com/kb/904953/ (ne stavih link :-)))
s tim da zaključujem da nema (ne znam!!) rješenje, osim naravno ne instaliranje SP2 za Office 2003, odnosno zakrpe KB901018 za Xp office ukoliko KORISTITE LINKANE excel tablice koje popunjavate iz accessa, odnosno ono što oni nude kao rješenje: improt tablice u acces pa kasnije export ... što mi baš i nije neko rješenje....
i to je to...
Pozdrav ekipi
ZagorecForEver
Muke po Accessu i update qveriju
Re: Muke po Accessu i update qveriju
Re: Muke po Accessu i update qveriju
Re: Muke po Accessu i update qveriju
