VB Forum / Database Access / July 2005

I have a legacy application which only has DAO references. I've set up an
export function that creates a new access database and export records to it.
This works fine but it appears that the latest version of Access you can use
is Jet 3 or Access 95 which is a bit old and would ...

Hello --
We have a recordset of financial information, containing groups of records
for financial reporting items such as Revenue, Cost of Goods, Expenses, Net
income, etc.

first of all, sorry for my bad english...
So...go on...
I've to load a recordset in an array with getrows.
My recordset is quite big and the getrows take few time to load the

I have an .xls file with 6 columns: Date, Time, ColA, ColB, ColC, ColD.
I access it in my VB6 program using ADO.
When any of the first 10 rows have values for ColA and ColB, everything is
fine.

I have an application which uses a Global Connection which i
initialized during the Application Load and used up across all th
forms This connection will be destroyed only during the exit of th
application(Even though not the best way to approach connections).

I created a report in access 97, I was wondering if there is statement I can
write in a VB6 to lunch this report instead of using Data Report in VB6.
Could someone share any ideas on this please?
Thanks.

first of all, sorry for my bad english...
So...go on...
I've to load a recordset in an array with getrows.
My recordset is quite big and the getrows take few time to load the

Can you help? I've got an application that uses Access 97 as it's backend.
This database is encrypted so that users can't view in access. However I'm
trying to build in an export function that will use a SQL query to get data
from the encrypted database, create a brand new DB and ...

I have an application in Access which relies heavily on Subforms. I have
downloaded VB 2005 Express with a view to replacing the front end and
keeping the Access database. I have never used VB before. Is there a way to
easily implement subforms?

I created a report in access 97, I was wondering if there is statement I
can write in a VB6 to lunch this report instead of using Data Report in VB6.
Could someone share any ideas on this please?
Thanks.

OK, I'm a newbie, so be nice!  
I've developed an application in Access 2000 that works fairly well, but I
don't like the application sitting on an Access background - it confuses the
non-technical users.

Hi, I have a number of data bound controls on a form populated from an
msaccess db using a data environment in vb. When I call the update method on
the recordset after changing a field value, the changes are not updated in
the database. If I call MoveNext, MovePrevious etc. then ...

Due to the "Filter method" limitations (can't apply filters to compare
dateparts -> I want to filter all the records of a month, can't use the
clausule "NOT LIKE", ...), I want to use a more complex method to filter
records. Does anybody knows how can I do it without reload all ...

Hello --
Recordset.GetRows worked for me, to get data from a table and put it into an
array (m x n).
Now I need to do the reverse ... put the values from an (30 rows x 5

Presently using mdac 2.5 (VB6 Pro SP 5)
1. When installing an app which references mdac 2.5 on a WinXP PC I'm
getting this error message.
       "This application has failed to start because MSDART32.dll was not