VB Forum / Database Access / March 2004

I am so glad this group is setup. I see some smart people floating
around here. Maybe you guys can help me!! My employer wants me to
design an application that is fully customizable. A database
application where you can add tables and other info on the fly. BUT,

This one I think should be easy when you now how but I couldn't get it
today.
I have to run a kind of double check routine.
1 database, 2 tables.  No linking or referential integrity or any of that.

I have an MS Access 97 Frontend which had linked tables to MS SQL Server
2000. I have a linked table with 1.4 million rows with index on primary key.
When I exclude this table from the application works fine but when I include
it in my query, I get a Runtime Error '3669'. Execution ...

I am searching for a tool for generating vb classe code from a given database.
Can anyon help me?
Thanks
TNL

I have developed a package using VB6 and DAO3.6.  On my development machine, everything runs fine, but when I build an installation disk and install the software on other computers, the software errors when trying to access data.  It does not fail on every data access, but only ...

Using Visual Basic 6.0, how to retrieve the schema/structure of a
table i.e. datatype, NULL is allowed or not, size of the data etc of
any column ??
Thanks

[Vb.net question] how to apply online update function into program (the
effect just like Norton system work live update)
The situation is below:
I want to develop a program that contains some product information (in the

Nobody I've asked this question has been able to answer me (dunno why...).
So here it goes: After calling recordset.AddNew, what is the position it
goes after that (neither EOF nor BOF), and which variable can I use to read
that position? There's a lot of things I want the user not ...

Let's say i have XML document of this type:
<?xml version="1.0" encoding="ISO-8859-1"?>
<CONTENT>
<VIDEO>

Greetings and thanks for your help
Whenever I create a new table in SQL-2000, using the VB6 command
CREATE TABLE [tabel_name_here], it makes me the owner. I prefer for the owner to be dbo.
I have found the change object ownerhsip command in MSDN, which is chObjOwner. However, I ...

We're currently using VB with an access Db through ADO to store
something like 30-40 tables for our application.
We need to use SQL Server 2000 for some customers. Is it a big deal to
create all our tables to SQL instead of Access? This needs to be

If Option3.Value = True Then
If IsNumeric(Text1.Text) Then Adodc1.Recordset.Filter = "id like '" &
Text1.Text & "%'"
Adodc1.Refresh

I'm getting an error stating that either EOF or BOF is true or the record
has been deleted when trying to get a true or false value from an Access
database.  The following is the code.
   strStatement80 = "Select * FROM misc_charges WHERE type = '" &

Using Visual Basic 6.0, how to retrieve the schema/structure of a
table i.e. datatype, NULL is allowed or not, size of the data etc of
any column ??
Thanks

Does anyone have any sample VB code, an app or class objects with methods etc for storing data on the client so that I can work with a SQL Server db using transactions. E.g. I want to create a Customer class with properties which relect the data in my customers table, instantiate ...