Source language: Translate to:

access file security

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

access file security

Postby yanzco » Sat Oct 24, 2015 12:49 am

hello... a project of mine uses an access database .mdb file

i was wondering if theres anyway to prevent manual changes on the file itself..

i mean, accessing the .mdb database file using microsoft access other than the program itself..

for security.. ? any ideas?..
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am

Re: access file security

Postby Gaev » Sat Oct 24, 2015 6:44 am

yanzco:

How about making sure it is encrypted and needs a password (that is only known to your pub) ?

From the Help file ...
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.

Separate multiple items in a compound variable with semicolons (;). This parameter may be left blank if a password and encryption are not desired.
User avatar
Gaev
 
Posts: 3738
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Re: access file security

Postby yanzco » Sat Oct 24, 2015 9:36 am

wowow, never knew that.. this is great! :D now it's password protected..
had no idea.. thanks gaev!!..
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am

Re: access file security

Postby yanzco » Tue Oct 27, 2015 6:02 pm

just wondering, how can i setup the password to the report designer..

ive set the password to the access file.. now i cant seem to set the password to the report designer.. ive set it right in neobook, but im having problem with report designer..
report properties...
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am

Re: access file security

Postby Neosoft Support » Tue Oct 27, 2015 6:08 pm

In Report Properties you have to use a connection string instead of just specifying the database file name. An example connection string with a password looks like this:

Provider=Microsoft.Jet.OLEDB.4.0
Data Source=[PubDir]yourdbfile.mdb
Jet OLEDB:Database Password=******
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5605
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: access file security

Postby yanzco » Tue Oct 27, 2015 7:35 pm

got it, thanks ! :D
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest