Search results

Well actually the error message i got was: 'Could not delete from specified tables'.

Hmm, afraid not... You see, trying to use an Inner Join kind of setup will NOT work in this situation, which was exactly my problem. The solution (thanks Niko) is to use the below nested SQL statement: DELETE * FROM Table1 WHERE A1 In (SELECT B1 FROM Table2)

Hi all. I kind of got stuck with this one. I'm trying to use a Delete query to delete some records from Table A. Let's say Table A has three fields: A1, A2 and A3 Then there's another table, Table B, with two fields: B1 and B2 Within one Delete Query, i need to delete all the records from...

Thank you.

Hi all. I'm trying to enhance the functionality of an MS Access application. I want to give the user the capability to import a MS Access or MS Excel table into the application *without* having to execute the Import Wizard herself. Q1: So i'm basically looking for the VBA statement that...

Yes, ADO and OLE references are checked. This must be a corruption of some DLL issue i guess. Would removing and reinstalling Access work? There are some MDAC patches that one can download from the MSDN website, but they don't work either.

No references are missing, i'm using Microsoft ActiveX Data Objects 2.1 Library for ADO.

MS Access 2002 (10.6501.6626) SP3

Hi all. I'm having a serious problem when i'm trying to use the CurrentProject.Connection property for some ADO manipulation. Here's the error message i'm getting: Run-time error '-2147220999 (800401f9)': Method 'Connection' of object '_CurrentProject' failed In the immediate window, i try...

In case anyone is interested, the correct syntax is: C:\Program Files\Winzip\Wzunzip -o "-@C:\Test_Data\99_WinZip_automation_tests\test_contents.txt" "C:\Test_Data\99_WinZip_automation_tests\test.zip" This will extract the names of the files contained in the Winzip archive...

Actually i found some excellent links to Ron De Bruin's (hope im not wrong with the name) code on this site, which helped a lot. I just couldn't get this specific functionality to work (wzunzip -v to extract the archive file names into a .txt file). I expect a reply from Winzip on this, if...

Hi all. I'm trying to automate WinZip from within MS Access. I'm using a registered version of WinZip 10.0 Pro. I ran into some trouble when i tried to extract the contents of the Zip archive to a text file. Here's the syntax i've been trying to use: C:\Program Files\Winzip\Wzunzip -v...