VB Forum / Database Access / May 2007

Please show me some codes.
TIA
Sam

Is there a way to backup and restore an SQL database with Vb.Net 2005
TIA

Hi Friends,
When we create new tables and add Columns to the table from VB using ADOX,
Can we assign Default Value for the NEW Columns?
Please suggest how and it will be great if I can get some code sample.

Is there a way in VB6 (or vb.net) to open a Microsoft SQL server database and
produce a list of which fields in each database is linked to another
database.  I used the diagram feature in SQL but it only shows releationships
not the specfic fields

I am trying to call all the cells and sheets from Excel in VB 6.0, But
unable to do so. Can you tell me the steps for this connection also can
you tell me do I need some other database like access or Sql in between
to connect

Hi, everybody,
   I am rusty with VB.    In the following code,
------------------------------------------------------
           Dim dbCmd1 As OleDbCommand = New OleDbCommand("UPDATE

First of all, I would like to say hello to you and thank you for all the help you always provide me with. Here is my situation,
I have a system made in Visual Basic 6.0 with SP6 that stores information in a database created in a SQL Server 2000 SP4. The problem arouses when I try ...

I have a recordset (multi records by 10 fields every one) ,
I want to save it to db access for once (not to used every record by
function insert)
help please.

I use DTPicker, listview and Microsoft Access.
I have start_date and end_date. I would like to query the range between
these fields. When I do a query, I found that it only show  one record in the
listview, The result from query suppose to have 2 records. I have set

I use Microsoft Access and DTPicker, listview, visual basic 6
I have 'Start_date' field and 'End_date' field, 'hari' field and
'peruntukan' field.
the start_date field, End_date field name are set as text in the table and

I use ADODB, Microsoft Access, Visual basic 6 and DTPicker.
When I chose the date by using DTPicker, I show and list me the date and the
activities in the listview. The date in the field 'Start_date' and 'End_date'
are always changing base on the the date chose at he DTpicker. The ...

Hi Masters :-)
Could anyone of you please translate the following into Visual Basic
2005 Code ?
I am new to this and tried every trick but failed to translate. Any

Not sure if relevant to ODBC but I have a strange problem with Access
2003/Word 2003.  I have a word file linked to a report.  The word file is in
a shared folder.  When I run it from one computer it works fine and when I
run it from another computer the font is huge.  Weird! I ...

One of our customer is using our vb6 application and it was working fine
before he installed quickbooks (that's the only change he made to his
computer before our application stopped working. We don't know if quickbook
corrupted mdac for sure).

Can anyone tell me if you've ever been able to use the seek method in
any form on a foxpro free table in vb.net? ADO, asp.net, odbc,
whatever.
No matter what I try, I always get "Current provider does not support