VB Forum / Database Access / October 2006

What would be the best scenario to achieve the following :
There is one master Access database which is local : DBlocal
There is one remote Access database at a web server : DBremote
There are a few tables within DBremote which need to be updated daily

I would like to take an existing XML file that I've read into a string and
then convert that to an ADO (not ADO.Net) DB record set that I can then
insert into a database table. To this end, I found out how to obtain the XML
schema for an existing ADO database table. I used the ...

Using VB.net 2005. In my xsd file, I set the Null value for a field called
Description to "X".However, when I fill the datatable from the access
database, if there is nothing in the Description field, it is still
System.DBNull.

Urgent !
i am using DTS package through my VC++ code and i am finding huge
memory leaks in that.
Checked in microsoft knowledge base and they say that if i set the

In essence this my project :
I have a .log file that I need to convert structuraly to make it
usefull in FileMaker.
- open the logfile

How do I connect to SQL Server 2005 from within VB? I am currently using the
collowing connection string:
"Driver={SQL
Server};Server=ServerName;Database=MyDBName;Uid=UserName;Pwd=MyPWD;"

Is there a big learning curve in moving from vba to vb.net ?  Are there  
any resources that anyone would recommend ?

I know how to select data from tables in my current data base and insert that
data into another table.  What is the correct syntax to select data from data
base A, table AA into database B, table BB.  I keep getting a syntax error or
invalid object error.  I am certain this is ...

I'm trying to rewrite a console application from VB6 to .Net 2005 that
moves users and computer about in active directory.  To start, its
grabs current users from our AS400 box and throws them into a table in
SQL.  It then queries SQL and Active Directory, compares, and

   I have VB6 and SQL 2000.  All our names are in capital letters. Is there
a syntax that will make the first letter in the fields capital and the
remaining lower case.
Thanks in advance.

Is there any significant reson why I should use one of these verions of code
over the other. Both are using JET 4.0 databases.
------------original code---------------------------------------
       sql = "DELETE * FROM QCOILS"

I have an app (VB6) which uses an MDB file. I open the DB and several
tables which then stay open all the time. The program executes various
DAO statements as well as SQL statements (db.execute("Some SQL
stuff"))

The connection string that I have been using to connect to SQL Server 2000
is like the following:
provider=sqloledb.1;Persist Security Info=False;Data Source=MyServer;Initial
Catalog=MyDatabase;User ID=MyUsername;Password=MyPassword;

When I build a new query the program will not let me save it -the save
button is not selectable.
Thanks in advance

It's worked perfectly in the past. When I have a 'Dim MyDb As Database'
statement in my program, it rejects it saying'User-defined type not Declared'
(I have checked that the 'VB' library where this resides is available, and it
works on new projects from scratch) PLease Help !!!! ...