Database Password - Enter by code.

[Greg (codepug@gmail.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

[Larry Linson]

Re: Database Password - Enter by code.

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

<codepug@gmail. comwrote in message
news:53387dc7-f624-4607-9419-93415a5e0452@c6 5g2000hsa.googl egroups.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]

Re: Database Password - Enter by code.

'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
>
<codepug@gmail. comwrote in message
news:53387dc7-f624-4607-9419-93415a5e0452@c6 5g2000hsa.googl egroups.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@gmail.com)]

Re: Database Password - Enter by code.

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:53387dc7-f624-4607-9419-93415a5e0452@c6 5g2000hsa.googl egroups.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]

Re: Database Password - Enter by code.

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

<codepug@gmail. comwrote in message
news:6c2c6503-ef32-46ac-876e-92fc5c0ad389@w7 g2000hsa.google groups.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:53387dc7-f624-4607-9419-93415a5e0452@c6 5g2000hsa.googl egroups.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 passwordautomat ically when linking from the FE?



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]

Re: Can you password protect the BE database and supply the password automatically when linking from the FE?

On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bobalston9@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]

Re: Can you password protect the BE database and supply the passwordautomat ically when linking from the FE?

Tom van Stiphout wrote:

On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bobalston9@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]

Re: Can you password protect the BE database and supply the password automatically when linking from the FE?

On Mon, 04 Aug 2008 23:01:55 -0500, Bob Alston <bobalston9@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 <bobalston9@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]

Re: Database Password - Enter by code.

On Mon, 4 Aug 2008 08:14:01 -0700 (PDT), "Greg (codepug@gmail. com)"
<codepug@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

[Bob Alston]

Re: Can you password protect the BE database and supply the passwordautomat ically when linking from the FE?

Tom van Stiphout wrote:

On Mon, 04 Aug 2008 23:01:55 -0500, Bob Alston <bobalston9@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 <bobalston9@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=my Password;DATABA SE=C:\M2Dev\pwP rotected.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?

OK I mean can you use the menu to link to an external table in a
password protected database and have the front end supply the password
each time the BE is accessed via the link?

Bob

[Keith Wilby]

Re: Database Password - Enter by code.

"Chuck" <libbeyc@school link.netwrote in message
news:caog94l0td 2qvej0puckltjtl f44a0a94a@4ax.c om...

>
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.
>

User-level security would prevent the casual user but not a clued-up hacker.

Keith.

[Chuck]

Re: Database Password - Enter by code.

On Tue, 5 Aug 2008 16:34:03 +0100, "Keith Wilby" <here@there.com wrote:

>"Chuck" <libbeyc@school link.netwrote in message
>news:caog94l0t d2qvej0puckltjt lf44a0a94a@4ax. com...

>>
>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.
>>

>
>User-level security would prevent the casual user but not a clued-up hacker.
>
>Keith.

Thanks for the compliment. However I'm far far from a "clued-up hacker"

Chuck

[Tom van Stiphout]

Re: Can you password protect the BE database and supply the password automatically when linking from the FE?

On Tue, 05 Aug 2008 09:46:06 -0500, Bob Alston <bobalston9@yah oo.com>
wrote:

I don't think so.
-Tom.


<clip>

>>>
>>Now can I do it with regular linked tables?

>OK I mean can you use the menu to link to an external table in a
>password protected database and have the front end supply the password
>each time the BE is accessed via the link?
>
>Bob

[Keith Wilby]

Re: Database Password - Enter by code.

"Chuck" <libbeyc@school link.netwrote in message
news:aifh94dkg1 90lakv3o641fr7f jsdesetq8@4ax.c om...

On Tue, 5 Aug 2008 16:34:03 +0100, "Keith Wilby" <here@there.com wrote:
>

>>"Chuck" <libbeyc@school link.netwrote in message
>>news:caog94l0 td2qvej0puckltj tlf44a0a94a@4ax .com...

>>>
>>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.
>>>

>>
>>User-level security would prevent the casual user but not a clued-up
>>hacker.
>>
>>Keith.

>
Thanks for the compliment. However I'm far far from a "clued-up hacker"
>

I wasn't intending to imply anything about you Chuck, just making a general
statement.

Keith.