I am using DAO and my code:
'Do the truncate here
Dim dbs1 As DATABASE
Set dbs1 = CurrentDb
dbs1.Execute "Truncate Table " & TableName
Gives me this error:
Run-time error '3078':
The Microsoft Jet databse engine cannot find the input table or query 'Truncate...
Hi all, I have another question along these lines.
Now I need to write a Truncate Command in a VBA setting against a SQL Server table.
Code just doesn't seem to be coming to me.
TheKing
[pc3]
I hope someone here has moved up to Access 2003, I have installed Access 2003 and Linked Table manager wizard will come up but the box will be empty.
I have uninstalled and reinstalled on two different machines and still only get the black screen where my linked tables should be.
TheKing
[pc3]
Would any of you know of a WMI script/procedure that you can call to the Win32 class for formating unused disk space?
I know there is one for all the diskspace, but unused kinda through me.
TheKing
[pc3]
Hello all....
I wrote a program that uses about 400 different select statements with around 20 different Recordset names.
Set up this way
Client side processing
Public g_Database_Connection as String
G_Database_Connection = (here is the connection string out of the ini file.)
Now you set and...
I am still new to TCP controls but a while back I bought a TCP control from the Company Called Dart. Well come to find out that their service isn't what you would like it to be.
Here is my problem:
I connect to a server with my VB application using my TCP component and it connects fine, sends...
I need to shell out to a .jar (java) file.
I have tried: intStart_Summary = Shell("C:\Program Files\SMARTPss\HateCrime.jar", vbHide) ' Run Jar Executable
and I have tried: Shell ("C:\Program Files\SMARTPss\HateCrime.jar"), (vbNormalNoFocus)
There must be something I am...
I would like to do a check to see if there are any files in a specific folder.
Example: in the folder 'Upload' I am having people upload threw a web page txt files.
I will not know what the file name is for sure. Can I do a folder directory search and if a file is done uploading then I can...
I have made my first Application with using DirectShow in 8.1SDK. I am going to be making an install disk and was wondering if there were some files I should make sure get into my install disk? I can't test it here as the only machine here with a second video card (for use with a web camera)...
I had the same problem.
But my problem ended up being that I has Direct X 9 on my machine b4 putting on 8.1sdk
I had to put my hard drive into another machine as a slave. Then I took out everything that I could find that had to do with 8.1sdk.
then it booted on its own, then I uninstalled DX9...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.