VB Forum / Database Access / December 2004

this works in one project.... when i copy paste it to another project it
doesn't work.... instead i get 'user-defined type not defined' error message
Private Sub Form_Load()
    FrmKlijenti.Top = 7095

I want at runtime to create a new acces database en add fields to it. Here
is a piece of my code. By my knowledge everythigh goes right until I try to
append my tabledefinition to the database. I really don't understand what I
am doing wrong here. So can someone help me out ?

I have a database using DAO and a query. Now i'd like to show the results
in a "data control". I only have to display the query results (no editing at
all)
In my app. the user can select a database (all databases have the same

I'am new to database programming so please be patient.
I created a database with one table (two fields) and one query (both fields
from the table and sorted)
Now i'd like to run this query from my VB6 application with some input.

Hello - I have a project where I would like to FTP a file from and FTP
server, read the comma-delimited file and import the data into SQL Server
2000 from a VB6 application.
Today, we have a DTS package that must be written/scheduled on another

I have a rather large database (Lots of field in different Tables)
that I call in VB6.
It has 6 tabs on a form, each tab containing a different tables data
related by an ID.  E.g. Personal Details in Tab 1, Current Staus in

I'm considering 'rolling my own database' rather than using an off the
shelf package such as MS Access. I'm just looking at what pros and cons
there might be at doing such a thing.
Let me tell you about my app:

I get the precision error message when trying to execute a stored procedure.
The NT (with RDO) version af the application works - even when run on XP.
I'm porting the program to XP and changing db interface to ADO (2.6). The
prodedure parameters include money and large (16,3) ...

I am trying to access a database that was converted from SQL 6.5a to SQL
Server 2000, however after creating the connection in the Server explorer I
get an error when trying to open a table. The error is :
"ADO error: Line 1 Incorrect syntax near 'COLLATE'"

When I insert about 45000 records in access thru VB
Is there anyway to able to accept 100000 records or more
by changing a setting ???

I'm working on a very small multi-user database app for read-only purposes.
The database is a delimited txt-file.
I have connected a Data Control (VB6) to the txt-file and it all works but
only for a single user.

I'm developing a VB6 application
I've got an ADO Data Control and a Recordset Object pointing to the same
table, now I insert a new record on the ADO Data Control, but that new
record doesn't appears in the Recordset Object even if I call the Requery

I was always told to put a data object on a form, and refresh it in
the load event.  With multiple forms, do you repeat the process and
put a data object on each form - this would seem very confusing with
all those recordsets to take care of as changes are made with updates

I have a program that I developed using a data environment & everything was working fine but out of nowhere now when I click on properties for my DE I get an error message "missing microsoft data source locator". Of course I have no connection to my database when I run the ...