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]

"Jan Janssen" <Ja********@ned .com> wrote in message
news:43******** *************** @news.wanadoo.n l...

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.Ne t">
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.microsof t.com news
server try these:

news://msnews.microsoft.com/

microsoft.publi c.dotnet.genera l
microsoft.publi c.dotnet.langua ges.vb
microsoft.publi c.dotnet.langua ges.vb.data
microsoft.publi c.dotnet.framew ork.adonet
microsoft.publi c.dotnet.framew ork.windowsform s.databinding
microsoft.publi c.vsnet.general
microsoft.publi c.vstudio.gener al
microsoft.publi c.access.securi ty
microsoft.publi c.dotnet.securi ty

</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]

On Mon, 21 Nov 2005 20:36:30 +0100, "Jan Janssen" <Ja********@ned .com> wrote:

¤ 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=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=E:\My Documents\bibli o.mdb;Mode=Read "

"Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=E:\My Documents\bibli o.mdb;Mode=Shar e Exclusive"

I believe you use CompactDatabase to encrypt an Access database:

http://support.microsoft.com/kb/306287/EN-US/
http://msdn.microsoft.com/library/de...ngdatabase.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" <Us************ ***********@sws pectrum.com> schreef in bericht
news:u4******** *************** *********@4ax.c om... On Mon, 21 Nov 2005 20:36:30 +0100, "Jan Janssen" <Ja********@ned .com>
wrote:

¤ 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=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=E:\My Documents\bibli o.mdb;Mode=Read "

"Provider=Micro soft.Jet.OLEDB. 4.0;" & _
"Data Source=E:\My Documents\bibli o.mdb;Mode=Shar e Exclusive"

I believe you use CompactDatabase to encrypt an Access database:

http://support.microsoft.com/kb/306287/EN-US/
http://msdn.microsoft.com/library/de...ngdatabase.asp
Paul
~~~~
Microsoft MVP (Visual Basic)

[Paul Clement]

On Tue, 22 Nov 2005 19:29:50 +0100, "m.posseth" <po*****@planet .nl> wrote:

¤ 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]


"Paul Clement" <Us************ ***********@sws pectrum.com> wrote in message
news:94******** *************** *********@4ax.c om... On Tue, 22 Nov 2005 19:29:50 +0100, "m.posseth" <po*****@planet .nl> wrote:

¤ 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)