VB Forum / Database Access / December 2003

I am able to import a local csv file into Access using the code posted below
(thankyou,  Paul Clement).
Since the file originates on the internet, I would like to import it
directly to Access rather than save it to my computer and then import it.

Forgive me, I'm new at this ;)
We have VB.net standard and a single licence of MS Access 2002.
I've been asked to look at a requirement for an application using a VB
front-end that stores data in an Access back-end.  The application will

Hello --
I have a simple VB application that I want to monitor an FTP directory in
5-second intervals and copy any files found to an alternate location.
I'm using the FileSystemObject to and the GetFolder() function to read the

I am developing a Server application on VB 6, Using Access2000. The database
contains users.the users connect to the server application from a nother
client application via TCP/IP. What is the best way to handle Access
database tables and records on my server VB application (The ...

THE PROBLEM IS LENB() function -- number of bytes
Dim com As ADODB.Command
Dim param As ADODB.Parameter
Dim strIn As ADODB.Stream

I was wondering about field types.
What should be the field type for (example) "firstname" ?
Should I specify "text" with 20 characters?
Or

How can I know how many connections are to my MSDE database at this time?
How can I do this programatically with VB 6 & ADO?
Thanks.
--

I wrote a program that should gather call information and produce billing .
I found out that the total calls (records) can reach easily to 20000
records.
Loading and saving the info takes 200 seconds...

How to code in VB.NET to get database schema? Is there any clas library
for the same ?Like the one SQL DMO for VB6.0

I'm developing a client/server application written in VB6.  The application
uses multiple forms and ADO to primarily display information and allow the
user to select various radio buttons, checkboxes, etc., to turn on/off
specific database items.  Essentially, this application is a ...

I am using ADO.
I am adding a new record to a recordset using rs.addnew
I need to store the new ID (lets say I have a field "MeetingID".
However the ID field =ZERO after calling AddNew.

How can I build a sub-form (like the one in MS-ACCESS) in VB.net

Consider a combo box and a large number of other controls on a form.
The combo box is populated from Data Environment Command1 which is tied to an Access database with
an SQL statement "select record from table".
Running the program, the user chooses a record from the combo box.

I am trying to figure out some SQL queries.
Please help if you can
I have these fields:
CallID (auto number) ,SubscriberNumber (text) ,CallDuration (long)