Source language: Translate to:

NeoBookDBPro - database - .mdb encryption, security

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

NeoBookDBPro - database - .mdb encryption, security

Postby Skarabäus » Fri Jan 18, 2008 5:02 am

Dear neobookers,

my compiled publication extracts during runtime a .mdb database
and I have stated the following:

- .mdb file is not encrypted
- .mdb file can be opened during runtime of .exe file
- .mdb file will not be hidden during runtime and not removed after publication terminates

What have i done up to now:
- Menu/Compile/Publish Book/Advanced/
-- activate checkbox "Hide extracted files"
-- activate checkbox "Remove extracted files when publication terminates

What information have i found in forum and so on:
- NeobookDB 2.3d offers action scripts
-- Security (dbfEncryptionOn,DbfEncryptDatabase, ...)
- NeobookDBPro have not such Security

Question:
What kind of possibilities do i have to secure my datas in .mdb database or protect .mdb database itself.


Many thanks for your help.
Skarabäus
User avatar
Skarabäus
 
Posts: 37
Joined: Mon May 15, 2006 4:31 am
Location: Germany, Ostfildern

Postby Gaev » Fri Jan 18, 2008 6:40 am

Skarabäus:
What have i done up to now:
- Menu/Compile/Publish Book/Advanced/
-- activate checkbox "Hide extracted files"
-- activate checkbox "Remove extracted files when publication terminates
These options pertain only to files that NeoBook automatically extracts on your behalf e.g. image files associated with Picture Objects or .rtf files referenced in Article Objects etc. ... if you use ExtractFile for your .mdb database file, the compile options do not apply to it.

What information have i found in forum and so on:
- NeobookDB 2.3d offers action scripts
-- Security (dbfEncryptionOn,DbfEncryptDatabase, ...)
As Dave has stated before, the form of encryption used is very weak ... and (if I recall) it is only applied to string and memo fields

- NeobookDBPro have not such Security
From the Help file ...
Code: Select all
Syntax:
dbpCreateAccessDatabase "file name" "options"

file name
The database file name.

options
This is a compound parameter and can contain any combination of the following items:

Password=pwd
Replace pwd with the password you wish to use to protect  this database. The password assigned here must be passed to dbpOpenAccessDatabase in order to open the database in the future. Please use caution when assigning passwords. If you forget the password, you will not be able to open the database.
 
Encrypted=Yes/No
Use "Encrypted=Yes" to encrypt the database file to protect the data from being viewed with a hex editor.
User avatar
Gaev
 
Posts: 3737
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Postby Skarabäus » Fri Jan 18, 2008 7:36 am

Gaev:

Sorry for that.
Unfortunately, I hadn't seen the instructions in the help file clearly

The possibility to place a password in this code is below

:DatabaseOpen
If "[DBStatus]" "<>" "Open"

FileExists "[PubDir]ab.mdb" "[Result]"
If "[Result]" "=" "True"
. dbpOpenAccessDatabase "database" "[PubDir]ab.mdb" ""
dbpOpenAccessDatabase "database" "[PubDir]ab.mdb" "pioernrachzack"
dbpOpenTable "database" "companies" "DataBaseUpdate"
Else
.if database doesn't exist, so create it here
dbpCreateAccessDatabase "[PubDir]ab.mdb" "Password=pioernrachzack;Encrypted=Yes"
dbpOpenAccessDatabase "database" "[PubDir]ab.mdb" "pioernrachzack"

.........


but it doesn't work.

I can nevertheless open the database and the data are not encoded either.
Perhaps have I put the code lines in a wrong order?
Skarabäus
User avatar
Skarabäus
 
Posts: 37
Joined: Mon May 15, 2006 4:31 am
Location: Germany, Ostfildern

Postby Gaev » Fri Jan 18, 2008 8:10 am

Skarabäus:
but it doesn't work
Which part does not work ? ... the part where you create it ... or where you just open it ?
I can nevertheless open the database and the data are not encoded either.
Looks like you are trying to open an .mdb that was (perhaps) created earlier ... before you discovered the "Password=pioernrachzack;Encrypted=Yes" option ... if an .mdb is created "not encrypted" and "no password" ... you will get an error when trying to open with password/encryption.

a) Erase the ab.mdb file ... and try again

b) to make sure [PubDir] is pointing in the right place ... temporarily add the AlertBox command shown below ...
Code: Select all
:DatabaseOpen
If "[DBStatus]" "<>" "Open"

FileExists "[PubDir]ab.mdb" "[Result]"
If "[Result]" "=" "True"
. dbpOpenAccessDatabase "database" "[PubDir]ab.mdb" ""
dbpOpenAccessDatabase "database" "[PubDir]ab.mdb" "pioernrachzack"
dbpOpenTable "database" "companies" "DataBaseUpdate"
Else
.if database doesn't exist, so create it here
AlertBox "Creating ..." "[PubDir]ab.mdb|Password=pioernrachzack;Encrypted=Yes"
dbpCreateAccessDatabase "[PubDir]ab.mdb" "Password=pioernrachzack;Encrypted=Yes"
dbpOpenAccessDatabase "database" "[PubDir]ab.mdb" "pioernrachzack"


You might also try and examine ab.mdb using my AccessDBU utility program described here
http://www.neosoftware.com/forum/viewtopic.php?t=15716
... try and open the database using combinations of options for Password and Encryption ... see which one works
User avatar
Gaev
 
Posts: 3737
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Postby Skarabäus » Fri Jan 18, 2008 8:45 am

Gaev:

I made a new database by "dbpCreateAccessDatabase" with password and encryption.
I imported the data sets from the old database in the database made newly.
The new database required the password.

Result: It works.

What had i done where before it has not worked?

Before I started with the construction of the publication, I had already made the database ready.
After them i had provided the code with references on the made database and then assigned passport place, too.

Obviously the safeguarding has been pried out through this.

Gaev, you were right again.

Result:
Make the database with password and Encryption by "dbpCreateAccessDatabase" first and after them import or input the necessary data.

Best regards, Skarabäus
Skarabäus
User avatar
Skarabäus
 
Posts: 37
Joined: Mon May 15, 2006 4:31 am
Location: Germany, Ostfildern


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests