MS Access database

[Jan Janssen]

Hi there

I'm currently creating a program (VB .Net 2003) in which I can create MS
Access databases. It took me a while to figure out how to create such
databases, but I'm still missing a few options which MS Access support:s:

1. Opening a database readonly from
2. Opening a database in exclusive mode
3. Encrypting and decrypting a database

Can anyone help me out?

thnx

 

[Ralph]

Hi there

I'm currently creating a program (VB .Net 2003) in which I can create MS
Access databases. It took me a while to figure out how to create such
databases, but I'm still missing a few options which MS Access support:s:

1. Opening a database readonly from
2. Opening a database in exclusive mode
3. Encrypting and decrypting a database

Can anyone help me out?

thnx

--
<response type="generic" language="VB.Net">
This newsgroup is for users of Visual Basic version 6.0
and earlier and not the misleadingly named VB.Net
or VB 200x. Solutions, and often even the questions,
for one platform will be meaningless in the other.
When VB.Net was released Microsoft created new newsgroups
devoted to the new platform so that neither group of
developers need wade through the clutter of unrelated
topics. Look for newsgroups with the words "dotnet" or
"vsnet" in their name. For the msnews.microsoft.com news
server try these:

news://msnews.microsoft.com/

microsoft.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.languages.vb.data
microsoft.public.dotnet.framework.adonet
microsoft.public.dotnet.framework.windowsforms.databinding
microsoft.public.vsnet.general
microsoft.public.vstudio.general
microsoft.public.access.security
microsoft.public.dotnet.security

</response>

 

[Cor Ligthert [MVP]]

Jan,

Don't get confused by using MS Access Interop, using ADO or older versions
of that (needs MDAC DLL's) or using ADONET (the most normal way for VS Net
2003).

This are three different ways of using an Access Database (there are more
differences than written below).

Using ADO and ADONET you only use the database Jet Engine as MS Access use
it as well, it does not give you all the posibilities from the MS Access
product. Therefore I would in your situation first decide what methode you
want to use.

MS Access Intereop cannot be used without a fully licenced MS Access
Microsoft product with the same version on a computer by the way. ADO and
AdoNet can access a Jet engine without that.

I hope this helps sofar,

Cor

 

[Paul Clement]

¤ Hi there
¤
¤ I'm currently creating a program (VB .Net 2003) in which I can create MS
¤ Access databases. It took me a while to figure out how to create such
¤ databases, but I'm still missing a few options which MS Access support:s:
¤
¤ 1. Opening a database readonly from
¤ 2. Opening a database in exclusive mode
¤ 3. Encrypting and decrypting a database
¤
¤ Can anyone help me out?

Questions 1 and 2 are a function of the connection string.

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\biblio.mdb;Mode=Read"

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\biblio.mdb;Mode=Share Exclusive"

I believe you use CompactDatabase to encrypt an Access database:

http://support.microsoft.com/kb/306287/EN-US/
http://msdn.microsoft.com/library/d...en-us/odeopg/html/deovrencryptingdatabase.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[m.posseth]

as addition

I believe you use CompactDatabase to encrypt an Access database:

yes but you need a connection string with a system mdb to get the resulting
database encrypted


hth

Michel Posseth [MCP]

 

[Paul Clement]

¤ as addition
¤ > I believe you use CompactDatabase to encrypt an Access database:
¤
¤ yes but you need a connection string with a system mdb to get the resulting
¤ database encrypted
¤

Can you explain why that is because I don't see a reference to a system.mdw in the example I posted?
Or, is it simply using the default system.mdw file?


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[m.posseth]

if you scroll a litle bit lower you see that it accepts these arguments
optional

but after rereading ,,, i guess i was not so clear in what i meant (
rry )

rephrase :

¤ yes but you need a connection string with a system mdb to get the
resulting

¤ database secure

I believe it is the intention of the TS to create from a unprotected
database a protected one, well as second connection string you should then
take one with a customized system.mdw

I do not see anny point of encrypting a database that anyone still may
access

regards

Michel Posseth [MCP]