VB Forum / Database Access / July 2004

I have found difficulties in form a correct parameters in order to edit
and save 2 records in my database.
this is how i did:
private sub cmdSave_Click()

does anyone have any code samples/links or tutorials on how to grant
permissions to sql server database?
can you do this with the dmo object?

Hai Friends !
Can you just help, how can I count no. of fields in a vb recordset and store
it in a variable.
Kindly reply

I need to export a hierarchical recordset to xml to be later imported and
inserted as a new recordset in a different database.
Sounds easy.... hmmm... so here are my problems!!
1. I need to export the recordset as a 'package', that is data in related

I'm using VB6 and running Windows XP and have two questions.
1. I use a MDI-form and want to make a "flexible menu". There's a
menu-option "Web" which among others contains the option "Interesting
Links". This option contains a maximum of six selected links.

I am trying to write a small program to enumerate the fields in an
Access 97 database that was upgraded to 2002, using a Visual Basic 6
application.  The code compiles, but it fails to see the fields in any
table that does not have any data in it.  I have tried this using both

Can anyone help me please? This has been driving me nuts for ages.
I want to use vb 6.0 to control data in a database (an access
database). I've looked at tutorial all over the net but I don't want
to use a data grid or anything like that because I want to control the

Hi to all. Here's the current situation. I need to develop a database
from scratch, both for research purposes as well as commercial report
generation. The first thing I have to do right up front is obviously
to design the database. I've read several beginner books on the

I have a problem and I don't know how to handle it.
From VB6 I'am connecting to an Access database using ADO 2.6 or DAO.
I want to read <RecordSource> property from each report contained in
database and I don't want to have MSAccess installed on the computer.I

I tried to post this a few hours ago but I don't see it in the NG so I am
trying again.
I have a recordset (rs) in a VB6 application and I want to loop through all
the fields in each row and pick up the field name and the value for each

Hi.  This request might sound rather bizarre, and I suppose it is.  I'm
trying to setup a button on one of my forms that results in *exactly* the
same behaviour as if the user had clicked on the 'close' button of the form,
or pressed Ctrl-F4.  In Win32 API, i'd just do a SendMessage ...

Is there a way to get multiple inserts into the database, i have some issues
regarding ADO.updatebatch and I am looking for some way to work around. I
can use ADO.Update but it would be slow as it would do 1 records at a time.
I am using VB6+VFP7+OLEDB

I have two tables that share a common field, GivIndex. One table contains
names and other information. The second table contains dates, amounts,
categories, etc. These records combine to provide contribution records for
our church.

We have developed a vb application that interfaces to an Access database
using ADO. The application has been used around the uk for 3 years now
without issue. It is now going Europe wide and so far has been translated
into Spanish, Portuguese and even Greek without any issues. We ...

I'm trying to figure out how to update a master database with changed records from a source database; design of both databases is identical, records have a Date/Time field to serve as a timestamp. Databases are Access 97.
Using DAO, the source database will be opened as dbs, the ...