"MS Access Object Model" examples needed

  • Thread starter Thread starter dk9
  • Start date Start date
D

dk9

I want to use Access Object Model from .NET to open access database
files and change/add/delete Tables, Views, etc and to repair/compact
Databases.

MSDN is lacking this kind of information.


Any links where I can get source code examples?

Thank you
 
There's no need to use automation for this...
I want to use Access Object Model from .NET to open access database
files and change/add/delete Tables, Views, etc
Click to expand...

To manipulate Jet database objects, simply send DDL SQL to the database
through ADO.NET just like you would send any other query.
and to repair/compact Databases.
Click to expand...

This is a little trickier, but again doesn't need automation:

http://www.codeproject.com/cs/database/mdbcompact_latebind.asp
 
hi,
Thank you
Click to expand...
But change the path of the compacted, temporary database. The root C:\
is not appropriate, as users cannot write there (NTFS).


mfG
--> stefan <--
 
But change the path of the compacted, temporary database. The root C:\ is
not appropriate, as users cannot write there (NTFS).
Click to expand...

Of course they can, unless *explicitly* prevented from doing so... The root
of the C:\ drive (or any other drive) is not read-only by default...
 
hi Mark,

Mark said:
Of course they can, unless *explicitly* prevented from doing so... The root
of the C:\ drive (or any other drive) is not read-only by default...
Click to expand...
They can't. Check a default WinXP installation. Normal users have not
the NTFS permissions to do that.
Don't mix it up with the default user created during the installtion,
which is in fact a local administator.


mfG
--> stefan <--
 
Back
Top