compact database Access 2007 via VB.net

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

Hi,

Has anyone succeed to compact an Access 2007 database via VB.net code?

The previous methods from JRO don't work anymore and there is no help
on msdn on how this could be done for 2007.

We use the correct connection string for 2007 with Microsoft ACE 12.
sConn= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _
sSource & ";User IDPassword=test;"

Many thanks.
 
Hi, Adrian.
Has anyone succeed to compact an Access 2007 database via VB.net code?
Click to expand...

Most of the folks who answer questions in this newsgroup code in VBA and
SQL, not .Net programming languages. I suggest you post your question in a
..Net newsgroup for a quicker answer.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
yeah; these people don't use .NET because .NET doesn't have a ROI.

I would reccomend either

a) not using DOTNET
b) not using MDB files.

SQL Server Express is PAINLESS to install; isn't it?

-Aaron
 
Back
Top