473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Database Password - Enter by code.

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
16 8337
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
'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
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
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


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
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
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
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
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
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
"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
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
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
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: John | last post by:
Hello. If I want to set up my first database and start using it in Dreamweaver what do I need to do? The book I'm working on has a CD with the database on. It is telling me to put it in the...
5
by: scorpion53061 | last post by:
is it possible to set the database password that you can set in access for a database from a vb.net application?
1
by: MCPD | last post by:
hello i have an aspx page that Contains tow textBoxs and Button i Must enter a correct username at the textbox 1 and password in textbox 2 that exists in database my command have this code...
2
by: rustyc | last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-) As I said over there: ... for a little side project at home, I'm writing a ham radio web site in...
2
by: runway27 | last post by:
i am helping a friend to build a forum website which uses php and mysql database. i am working on the registeration page for the forum website and its validation. i am using php 5.2.5 i am able to...
39
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
3
by: Michael Schöller | last post by:
Hello, First of all english is not my natural language so please fogive me some bad mistakes in gramatic and use of some vocables :). I have a great problem here. Well I will not use it...
9
by: Dhiru1009 | last post by:
Hi guys, I am trying to build a user registration form using PHP and MYSQL but encountring a problem. When I click on submit with empty fields it adds records to database also it doesn't matter...
1
by: kiranbabu | last post by:
<html> <head> <style type="text/css"> h2{color:#A02820} </style> </head> <script language=javascript>
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.