VB Forum / Database Access / June 2004

When I try to open an Access 2000 database using the following VB 6
script I get the error 7866 Microsoft Access can't open the database
because it is missing, or exclusively locked by another user.  I have
checked and the database is where the link says and was not being used

I want to read a .db file using vb.net
Any ideas how to set up the connection string, which adapter to
use, any working program ???
Any help would be very helpful!

Im running VB6 ( SP6) and SQL 2000.  I connect to the SQl server using a trusted connection and generate a recordset using a join query on two tables.  
What puzzles me is that i can do an recordset.update an it will update both of the joined tables with any changes.  I can see ...

I have an application 'out there' and now need to alter some tables in my
client's Access database.  I can easily add (create) tables, alter tables (add
and remove fields) and drop tables all in code.  However I would also like to
extend the length of an existing text field from 100 ...

Im currently working on a project that involves scanning an image and having it
appear as an image file.  Any suggestions on how to go about with this?? It
also has to work with any scanner out there. is it also possible to have a scan
command button that would control when the ...

After upgrading from 2000 to XP I get "Method 'Refresh' of object 'IAdodc' failed.  The runtime error is '-2147024769 (8007007f)'.  The refresh method is available, but fails.  Here is the code
  With Adodc
     .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist ...

When i make a datasource by directly making the new keys in the registry and
putting the values in those keys(all through VB Code), it creates the
datasource in the registry and that and i m also able to use that datasource
in the ADO commands thorugh VB but when i goto 'Control ...

I am using an autoresponder software designed with vb6 and I am using XP.  While using this software I continue to receive the above error.  I have reinstalled it, replaced the database, updated the following software: MDAC 2.8, Jet 4.0 SP 8, VB6 runtimes with SP6 and IE6.  The ...

I want to filter data displayed in datagrid but how? if use dataview i have to connect all other controlbox on form but i don't like it that way , i want use filter method or something of datagrid or select of dataset but examples in MSDN don't work ... please what is the best ...

I'm thinking of moving up to vb.net from vb5.
Here in the UK, we have .net standard at about 80 pounds.  If you want your
project to connect to a database however, you have to move to studio.net at
about 800 pounds!  I only want vb - don't need the other languages in

Greetings all,
I am using an Access Database to store question information for a
questionare application.  I am using VB.net as the front end, and
ADO.net to retrieve the information from the database.  My data is bring