Database Password - Enter by code.

[Greg (codepug]

If one converts that .mdb into an .mde the code is secure but the
tables can still be imported.
Just for Very Basic protection, I have placed a Password on the
database using the "Set Database Password" option. Now it requires
that the password be entered each time you start the database. How do
I enter the Password using code, so that the database starts up
without having to type it in ??? I notice that there is a way in code
to set the password, which I believe is for changing the password. I
don't want to change it, just enter it.

Thanks

[Larry Linson]

Look in Help for Command Line Options. I am reasonably certain you can
specify the password in the shortcut you place on the user's desktop, but,
er, wouldn't that defeat its purpose?

Larry Linson
Microsoft Office Access MVP

<co*****@gmail. comwrote in message
news:53******** *************** ***********@c65 g2000hsa.google groups.com...

If one converts that .mdb into an .mde the code is secure but the
tables can still be imported.
Just for Very Basic protection, I have placed a Password on the
database using the "Set Database Password" option. Now it requires
that the password be entered each time you start the database. How do
I enter the Password using code, so that the database starts up
without having to type it in ??? I notice that there is a way in code
to set the password, which I believe is for changing the password. I
don't want to change it, just enter it.

Thanks

[c0l0nelFlagg]

'Send Key' string in a macro then convert to code ?? Maybe??

Larry Linson wrote:

Look in Help for Command Line Options. I am reasonably certain you can
specify the password in the shortcut you place on the user's desktop, but,
er, wouldn't that defeat its purpose?

Larry Linson
Microsoft Office Access MVP

<co*****@gmail. comwrote in message
news:53******** *************** ***********@c65 g2000hsa.google groups.com...

>>If one converts that .mdb into an .mde the code is secure but the
tables can still be imported.
Just for Very Basic protection, I have placed a Password on the
database using the "Set Database Password" option. Now it requires
that the password be entered each time you start the database. How do
I enter the Password using code, so that the database starts up
without having to type it in ??? I notice that there is a way in code
to set the password, which I believe is for changing the password. I
don't want to change it, just enter it.

Thanks

[Greg (codepug]

Thankyou Larry

I am basically looking to secure the data tables from import/export!
Since the Database Password offers
some protection, I was hoping to have code on startup (ie in the .mde)
a startup macro or something, that
would eliminate the need to enter the pass manually. The password is
not meant to secure the application
but simply prevent Import/Export accessibility to the tables.

I'll look into the help function, but am concerned now that the
password is required before the code executes?

Thanks Greg
On Aug 3, 6:41*pm, "Larry Linson" <boun...@localh ost.notwrote:

Look in Help for Command Line Options. I am reasonably certain you can
specify the password in the shortcut you place on the user's desktop, but,
er, wouldn't that defeat its purpose?

*Larry Linson
*Microsoft Office Access MVP

<code...@gmail. comwrote in message

news:53******** *************** ***********@c65 g2000hsa.google groups.com...

If one converts that .mdb into an .mde the code is secure but the
tables can still be imported.
Just for Very Basic protection, I have placed a Password on the
database using the "Set Database Password" option. Now it requires
that the password be entered each time you start the database. *How do
I enter the Password using code, so that the database starts up
without having to type it in ??? *I notice that there is a way in code
to set the password, which I believe is for changing the password. *I
don't want to change it, just enter it.

Thanks- Hide quoted text -

- Show quoted text -

[Larry Linson]

Yes, for Access security, the password is required to open Access, long
before the database is opened and any code or macros run... so, no, a
database can't supply its own password. That is why I suggested you put a
Shortcut on the user's desktop and include the password argument in the
Command Line associated with the Shortcut.

Larry Linson
Microsoft Office Access MVP

<co*****@gmail. comwrote in message
news:6c******** *************** ***********@w7g 2000hsa.googleg roups.com...
Thankyou Larry

I am basically looking to secure the data tables from import/export!
Since the Database Password offers
some protection, I was hoping to have code on startup (ie in the .mde)
a startup macro or something, that
would eliminate the need to enter the pass manually. The password is
not meant to secure the application
but simply prevent Import/Export accessibility to the tables.

I'll look into the help function, but am concerned now that the
password is required before the code executes?

Thanks Greg
On Aug 3, 6:41 pm, "Larry Linson" <boun...@localh ost.notwrote:

Look in Help for Command Line Options. I am reasonably certain you can
specify the password in the shortcut you place on the user's desktop, but,
er, wouldn't that defeat its purpose?

Larry Linson
Microsoft Office Access MVP

<code...@gmail. comwrote in message

news:53******** *************** ***********@c65 g2000hsa.google groups.com...

If one converts that .mdb into an .mde the code is secure but the
tables can still be imported.
Just for Very Basic protection, I have placed a Password on the
database using the "Set Database Password" option. Now it requires
that the password be entered each time you start the database. How do
I enter the Password using code, so that the database starts up
without having to type it in ??? I notice that there is a way in code
to set the password, which I believe is for changing the password. I
don't want to change it, just enter it.

Thanks- Hide quoted text -

- Show quoted text -

[Bob Alston]

Can you password protect the BE database and supply the password
automatically when linking from the FE? If so, exactly how?

Bob

[Tom van Stiphout]

On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bo********@yah oo.com>
wrote:

I used A2007 accdb, and the "Encrypt with password" option.

Dim td As DAO.TableDef
Set td = CurrentDb.Creat eTableDef("Tabl e1")
td.Connect = "MS
Access;PWD=myPa ssword;DATABASE =C:\M2Dev\pwPro tected.accdb"
td.SourceTableN ame = "Table1"
CurrentDb.Table Defs.Append td
CurrentDb.Table Defs.Refresh
-Tom.
Microsoft Access MVP

>

Can you password protect the BE database and supply the password
automaticall y when linking from the FE? If so, exactly how?

Bob

[Bob Alston]

Tom van Stiphout wrote:

On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bo********@yah oo.com>
wrote:

I used A2007 accdb, and the "Encrypt with password" option.

Dim td As DAO.TableDef
Set td = CurrentDb.Creat eTableDef("Tabl e1")
td.Connect = "MS
Access;PWD=myPa ssword;DATABASE =C:\M2Dev\pwPro tected.accdb"
td.SourceTableN ame = "Table1"
CurrentDb.Table Defs.Append td
CurrentDb.Table Defs.Refresh
-Tom.
Microsoft Access MVP

>>
Can you password protect the BE database and supply the password
automaticall y when linking from the FE? If so, exactly how?

Bob

Interesting.

Now can I do it with regular linked tables?

[Tom van Stiphout]

On Mon, 04 Aug 2008 23:01:55 -0500, Bob Alston <bo********@yah oo.com>
wrote:

??? Why do you accuse mine of being irregular?
-Tom.

>Tom van Stiphout wrote:

>On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bo********@yah oo.com>
wrote:

I used A2007 accdb, and the "Encrypt with password" option.

Dim td As DAO.TableDef
Set td = CurrentDb.Creat eTableDef("Tabl e1")
td.Connect = "MS
Access;PWD=myP assword;DATABAS E=C:\M2Dev\pwPr otected.accdb"
td.SourceTableN ame = "Table1"
CurrentDb.Table Defs.Append td
CurrentDb.Table Defs.Refresh
-Tom.
Microsoft Access MVP

>>>
Can you password protect the BE database and supply the password
automatical ly when linking from the FE? If so, exactly how?

Bob

Interesting.

Now can I do it with regular linked tables?

[Chuck]

On Mon, 4 Aug 2008 08:14:01 -0700 (PDT), "Greg (co*****@gmail. com)"
<co*****@gmail. comwrote:

>Thankyou Larry

I am basically looking to secure the data tables from import/export!
Since the Database Password offers
some protection, I was hoping to have code on startup (ie in the .mde)
a startup macro or something, that
would eliminate the need to enter the pass manually. The password is
not meant to secure the application
but simply prevent Import/Export accessibility to the tables.

I'll look into the help function, but am concerned now that the
password is required before the code executes?

Thanks Greg

This intrigues me. I know very little about Access. But if I had your front
end on my computer, what would prevent me from writing a query with no filters
to display one table at a time. Then export the queries to excel or word
files.

Chuck