VB Forum / Database Access / February 2004

I had a problem in VB basic
I've got a file the data is in on line but cutted by tabutators.So the
data i want to have is between two tabs, how can i read the data out
and write them into a "dim"?

It seems as though this should be possible.  Does anyone know for sure and
if so, could you point out a reference/article
Thanks,
Jim

Just have a relatively simple questions I hope.  How do I run an Oracle
Stored Procedure with two input parameters using VB6.  The code below look
fine but at the end of this code when VB6 tries to run the RSK.OPEN command
I get an error, "Parameter type is not supported."  What I ...

Hi guy
Could anyone have a look at this procedure.  I want to establish a connection with an Oracle9i database and issue a SQL command when a user clicks a button on a simple form.  Am I missing anything, I've include the ADO in my project
Private Sub CommandButton1_Click(
Dim ...

I have an interesting question.  I have created a database application using
vb6.  This application uses sql server 2000 to store data in one database
that holds five tables.  I have learned how to create a setup file using
Setup Factory, but I am not sure how I can add the database ...

Is there any way to find out how many users are connected to Access 2000
(DAO) from VB6 program. I'd like to run DBEngine.CompactDatabase when the
last user closing VB application. If there is at least one more user I would
prefer even not to call CompactDatabase method.

I have following problem using a datagrid:
1° I fill a recordset with data from a sql server (workes fine)
  sql="select nr, naam, voornaam, kerkhof from dossiers where naam
like 'a%'"

I am writing a piece of software to prevent school children from accessing
programs and system bits you don't want them to get at.
How can I get MS word to open but only allow the user to access/open/save to
certain folders/directories?

I managed to extract data in an ACT v 3 database like this:
Dim db as Database  ' DAO
Set db = OpenDatabase("E:\Database\", 0, True, "DBase 5.0;")
Then I did:

I have a question about deleting files.
I have a removable disk that stores backed up copies if a database file that
are incremented according to the date.
I would like to count the number of .bak files on that drive and if the

I am using DAO. and a field was created and is incorrect in size, was
created at 20 char's and I need it to be 25 chars.
Dim tbfNewRecords as DAO.tabledef
Dim Size as Property

I have written an application that queries an MS Access database. It seems
to work fine when installs on a windows 2000 machine and XP machine but not
on a windows NT or Windows 98 machine. The program throws up an error newra
the end of the installation:

I have written an application that queries an MS Access database. It seems
to work fine when installs on a windows 2000 machine and XP machine but not
on a windows NT or Windows 98 machine. The program throws up an error newra
the end of the installation:

What should I do if I want MSSQL 2000 Server automatically store <null>
value into a DATETIME column instead of '1899.12.30', '1899.12.31' and  'AM
12:00:00'.
For Example, If I run the following

Hello.  I have Windows XP and I have SQL Server 2000 Developer edition installed, as well as Visual Basic 6 Pro.  I'm using VB6 to revise & maintain my employers large application,  which uses an Access database, and now they want me to change it to SQL, so I'm learning about SQL ...