Using the Desktop Engine

  • Thread starter Thread starter Curt Emich
  • Start date Start date
C

Curt Emich

I'm attempting to use MS Access with .NET but am not having much luck, so
I've decided maybe I should just use the SQL Server Desktop Engine. Is
there any way to import my tables from Access into the Desktop Engine?
 
Yep, get developer edition which includes Client Tools and just use EM to do
it. Access might even (I don't use it but I suspect it does) have the
ability to Export to SQL Server. Developer is really cheap now and you get
all fhte client tools so it's well worth it. Many books have an eval
version and I haven't read the licenese, but you may want to use one of
those if it's Kosher.

Another approach is to use one dataadapter to fill the dataset from the
access DB, then use another one to update to SQL Server. To do this, turn
the AcceptChangesDuringFill of the Access dataadapter for false when you do
the fill. This is the poor man's DataJunction.

HTH,

Bill
 
Just make sure you are not using vb .net standard edition.try using msde
comes with ms office. oh and to move your tables you can use the import
function of which ever tool you choose to use

bledu
 
If you want to move the entire Access database, go to micrsofts website and
download the Access Upsize Wizard. Point, click, and shazamm!!

HTH

Nick
 
Back
Top