Set password on database

Is it possible is ASP to set a password on an Access database that
previously had no password protection?

Thanks!

Re: Set password on database

Jake wrote:
> Is it possible is ASP to set a password on an Access database that
> previously had no password protection?
>
> Thanks!
http://groups-beta.google.com/group/microsoft.public.in.csha rp/msg/53d7f45b3bdeb8de

The code in the post is VB code. To convert it to vbscript, simply remove
the datatype declarations ( ... As String, etc.)

Are you creating a database maintenance app? Otherwise it really makes no
sense to put this ability in the hands of users...

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Set password on database

Thanks Bob!

I have a function in my application that allows users to backup(copy to temp
dir) and download their database in case they cannot get to our servers for
some reason in the future.
Along with this, I provide some local utilities that allow the users to view
limited data from their backup copy of the database but I want to keep them
from opening the database directly.

This should do the trick.



"Bob Barrows [MVP]" wrote in message
news:Om1HYrIAFHA.1404@TK2MSFTNGP11.phx.gbl...
> Jake wrote:
>> Is it possible is ASP to set a password on an Access database that
>> previously had no password protection?
>>
>> Thanks!
> http://groups-beta.google.com/group/microsoft.public.in.csha rp/msg/53d7f45b3bdeb8de
>
> The code in the post is VB code. To convert it to vbscript, simply remove
> the datatype declarations ( ... As String, etc.)
>
> Are you creating a database maintenance app? Otherwise it really makes no
> sense to put this ability in the hands of users...
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

Re: Set password on database

<<
I have a function in my application that allows users to backup(copy to
temp dir) and download their database in case they cannot get to our
servers for some reason in the future.
Along with this, I provide some local utilities that allow the users to
view limited data from their backup copy of the database but I want to
keep them from opening the database directly.
>>

For another possible approach that I use a lot:

Perhaps add the ability for the user to download a CSV file which can
easily be opened in Excel.

Puzzle 5 Not much different from other solutions by Manohar Kamath
posted 1/12/99
http://www.asp101.com/puzzles/puzzle5_s7.asp

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!