I just downloaded VB Express 2005 and I am trying to use it to make an application for my Access Database. The program is supposed to compare the version numbers in two tables, update the database if necessary (simple file copy off a network drive), and then open the database with Access. For now though, I am just trying to figure out how to read from the tables in the database.

I created a new project and added the datasource. If you're curious, the connection string is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Program Files\MVC Marketing\bin\prototype.mdb";Persist Security Info=True;User ID=mvcinfo;Jet OLEDB:System database="c:\program files\mvc marketing\bin\workgroup.mdw"

I set the DataSet Name to "MVC" and the source name as "MVC", so I'm guessing that's how I should refer to it in my code somewhere. I did a lot of work with VBA in Access, but I'm finding out that this is a little different...

I want to write code to read from the tables from MVC. The data source has two tables - _local and _settings. Each has a column called "version". How would I code...

x = "SELECET version FROM _local WHERE index=1" y = "SELECET version FROM _settings WHERE index=1" if X < Ythen Messagebox.show("The version you are usingis out ofdate - downloadingnew version.") ~do some stuff endif ~ open database ("c:\program files\microsoft office\office\msaccess.exe" "c:\program files\mvc marketing\bin\prototype.mdb" /wrkgrp "m:\mvc marketing\_prototype\bin\workgroup.mdw")

I've searched forums and the web for the past two days, and I'm not finding very much information on this. To anyone who can help, thanks a million in advance!

Nick