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...
sure, but just a sample I would say since the sql file is 31kb large.
after opening it in NotePad I copied out a couple lines and pasted below:
DROP TABLE IF EXISTS Affidavit;
CREATE TABLE Affidavit(
PRIMARY KEY (AffidavitID),
AffidavitID BIGINT NOT NULL,
ORI VARCHAR(250)...
Thanks for all of that I will copy it out for sure.
But at this time I have the SQL file already, I was looking for the command that I use in SQL+ to make the database from the SQL file.
TheKing
[pc3]
I am new to Oracle 9i and I would like to creat a database in Oracle 9i from an Access.2000.mdb.
I found a program that converted the database into an SQL file.
I really don't know what to do with it at this point.
any ideas?
TheKing
[pc3]
Does anyone still have that Intel jpg converter library out there?
I have a program that will take a still picture capture from a sony web/conference camera but of course VB will capture and save it as a .bmp file. about 180KB
I need to then (command line) change it to a jpg hopfully around...
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.