VB Forum / Database Access / January 2004

Can anyone here tell me how I can create an Access database programatically
using ADO 2.7 (not adoX) ? I have searched the web but all I can find is how
I can do it using ADOX and I am using ADO 2.7.
Best regards

In VB6
How to check that a specific EXE is currently loaded?
(Should be compatible with Win9x/NT/2000/XP)
by example I should check for calc.exe present:

       I want to open a file dialog box (a 2000 database in Access 2002).  I
found the code in help.  It defined a variable:
   Dim fd As FileDialog
       I have all the regular references checkedin my project, but it says

I am using an Adodc control that is linked to an access database.  I am
using a MSHFlexgrid to display my SQL query results.  My question is how can
I retrieve a record by double clicking it in the flexgrid? how would I
start?

How do I open an ADO Connection to an Access Database via code (the paths are not static and will be read from an ini file - Don't worry about this I already have figured it out) anyway back to the question in hand, I want to open the connection when my application opens/loads ...

Hello
I just move my website to another provider and now i get this error - what
do i have to do?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

For some school project i need to grab online data (in xml style) and
throw it in an access database (trough vb.net). The reason is: an
online and an offline part (online: mysql & php, offline: access &
vb.net).

I'm trying to mark several pieces of text in a textbox.
I use selstart en sellength to find a certain word in a text
and get it highlighted like google does when I search for a word
the beckground gets yellow.

Some Win2K machines are reporting an error when doing an Execute to insert
several records into a database using DAO.  The database the records are
coming from is a textfile using the text driver.  The database being updated
is clearly not read-only since tables have just been ...

I have a recordset which I am printing. Some fields are empty and the
printer prints "NULL". I want it to print"" - nothing at all!
Help
Thanks

How can I set up user properties, i.e. add/delete user to/from a group, change password in System.mdw via ADO or VB6
Thanks in advance
KS

I am getting an error while trying to send string for uniqueidentifier while calling a stored procedure from ADO.
Here is the code I am using.
With cmd
   .ActiveConnection = cOLEConnectionString

I have an application in VB6 using an Access 2000 database. It works fine on
my XP development PC and my clients XP PC. When I install it on a WIN98 PC,
I can look at some of the forms OK however, when I click on one OK command
button to get me to the next form, I get a Run Time ...

I have some vb code that submits an insert to a sql database.  After that I want to move the file I was dealing with to an archive folder.  How might I get the file move to wait until the database operation is done
Thanks
           BiosSqlCommand.CommandText = strInser
           ...

Hi Group,
Anybody got any links where i could read up on how table relationships
within VB and ADO.NET. Preferably with Access
Many Thanks