By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Database Password - Enter by code.

P: n/a
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
Aug 3 '08 #1
Share this Question
Share on Google+
16 Replies


P: n/a
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**********************************@c65g2000 hsa.googlegroups.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

Aug 3 '08 #2

P: n/a
'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**********************************@c65g2000 hsa.googlegroups.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


Aug 4 '08 #3

P: n/a
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...@localhost.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**********************************@c65g2000 hsa.googlegroups.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 -
Aug 4 '08 #4

P: n/a
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**********************************@w7g2000h sa.googlegroups.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...@localhost.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**********************************@c65g2000 hsa.googlegroups.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 -

Aug 5 '08 #5

P: n/a


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

Bob
Aug 5 '08 #6

P: n/a
On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bo********@yahoo.com>
wrote:

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

Dim td As DAO.TableDef
Set td = CurrentDb.CreateTableDef("Table1")
td.Connect = "MS
Access;PWD=myPassword;DATABASE=C:\M2Dev\pwProtecte d.accdb"
td.SourceTableName = "Table1"
CurrentDb.TableDefs.Append td
CurrentDb.TableDefs.Refresh
-Tom.
Microsoft Access MVP

>

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

Bob
Aug 5 '08 #7

P: n/a
Tom van Stiphout wrote:
On Mon, 04 Aug 2008 22:07:44 -0500, Bob Alston <bo********@yahoo.com>
wrote:

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

Dim td As DAO.TableDef
Set td = CurrentDb.CreateTableDef("Table1")
td.Connect = "MS
Access;PWD=myPassword;DATABASE=C:\M2Dev\pwProtecte d.accdb"
td.SourceTableName = "Table1"
CurrentDb.TableDefs.Append td
CurrentDb.TableDefs.Refresh
-Tom.
Microsoft Access MVP

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

Bob
Interesting.

Now can I do it with regular linked tables?
Aug 5 '08 #8

P: n/a
On Mon, 04 Aug 2008 23:01:55 -0500, Bob Alston <bo********@yahoo.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********@yahoo.com>
wrote:

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

Dim td As DAO.TableDef
Set td = CurrentDb.CreateTableDef("Table1")
td.Connect = "MS
Access;PWD=myPassword;DATABASE=C:\M2Dev\pwProtect ed.accdb"
td.SourceTableName = "Table1"
CurrentDb.TableDefs.Append td
CurrentDb.TableDefs.Refresh
-Tom.
Microsoft Access MVP

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

Bob
Interesting.

Now can I do it with regular linked tables?
Aug 5 '08 #9

P: n/a
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
Aug 5 '08 #10

P: n/a
Tom van Stiphout wrote:
On Mon, 04 Aug 2008 23:01:55 -0500, Bob Alston <bo********@yahoo.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********@yahoo.com>
wrote:

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

Dim td As DAO.TableDef
Set td = CurrentDb.CreateTableDef("Table1")
td.Connect = "MS
Access;PWD=myPassword;DATABASE=C:\M2Dev\pwProtec ted.accdb"
td.SourceTableName = "Table1"
CurrentDb.TableDefs.Append td
CurrentDb.TableDefs.Refresh
-Tom.
Microsoft Access MVP
Can you password protect the BE database and supply the password
automatically 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
Aug 5 '08 #11

P: n/a
"Chuck" <li*****@schoollink.netwrote in message
news:ca********************************@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.

Aug 5 '08 #12

P: n/a
On Tue, 5 Aug 2008 16:34:03 +0100, "Keith Wilby" <he**@there.comwrote:
>"Chuck" <li*****@schoollink.netwrote in message
news:ca********************************@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
Aug 5 '08 #13

P: n/a
On Tue, 05 Aug 2008 09:46:06 -0500, Bob Alston <bo********@yahoo.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
Aug 6 '08 #14

P: n/a
"Chuck" <li*****@schoollink.netwrote in message
news:ai********************************@4ax.com...
On Tue, 5 Aug 2008 16:34:03 +0100, "Keith Wilby" <he**@there.comwrote:
>>"Chuck" <li*****@schoollink.netwrote in message
news:ca********************************@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.

Aug 6 '08 #15

P: n/a
Yes, you can use the menu to link to the external table in a password
protected db and you'll be prompted for the password. Thereafter the front
end will supply this password every time the linked table is opened in the
front end, like when double clicking on the linked table in the db window.
If you use vba code to connect to the back end, you'll have to supply the
password programmatically.

Chris
Microsoft MVP
Bob Alston wrote:
>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?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Aug 8 '08 #16

P: n/a
The password you can supply in the shortcut as a command line switch is for
user level security, the one where the user name and user's password are
required. The command line switch for the password doesn't work for the
database password.

Chris
Microsoft MVP
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Aug 8 '08 #17

This discussion thread is closed

Replies have been disabled for this discussion.