VB Forum / Database Access / May 2006

I have written a database app (Jet engine) with VB 5.0.  I was
wondering if there was any way I could somehow compact and repair the
database on my own -- whenever I try to load the .MDB file into a
recent version of Access, it says that I cannot make any changes to

I've run into a problem when using Expressions in a DataColumn of a
DataTable which I'm updating back to the underlying databas. That is, I'm
loading data into a DataTable in which I've set some of the DataColumns to
calculate their contents using the Expression property.

I am rather new to visual basic and i am having trouble connecting to a SQL
Server 2000 DB. I have tried many suggestions but i am having no luck. This
makes me think i am not converting the code from the example to fit my
application correctly. Below is the code i am using to ...