Hi!
Happy new year to all VB Guru out there my previous query was
solved in a couple of days, I am stuck again, i am doing a project with
access has a database and VB 6.0 has a front end. I want my database to
be password protect i.e if any dblclick access file it must ask for a
password. Can i link a password protect access file to VB if tried but
error like worksheet file not found was thrown, can any VB GuRu out
there let me know the steps in accomplishin the task.
Also i want in my project to display mathematical formulas, has some
fine guy know how to store mathematical formula( like sin2A + Cos2A=1
here '2' must be superscript & some integration and derivative
formula as well which has some symbols of integration )in access. and
then dispaly those on Front End.
Cheers!
password in access
Hot Topic
- My.Application.OpenForms missing after VB6 Conversion
- Creating a byte array from a stream
- One or more errors encountered while loading the designer
- System.Data.SQLClient.SqlExcemption: Login failed for user '(null)'. Reason: Not associated....
- dataset.haschanges
- When is DLL Main executed?
- Refresh the Winows OS from within Visual Basic
- passing events to different classes
- VS 2005 TableAdapter and SQL
- VB2005 Express b2: Where are the libraries?
Visual Basic
- VB Application Settings
- Adding Keywords to XML Comments
- VB.Net 2005 Professional and Enterprise differences
- I cannot reference my class
- how to add icon to vb.net menu
- how does timer work in vb.net 2003?
- VB & WinSock
- CommandLines, JIT, and Errors
- How can I hide the dialog print form
- Using Application framework, but having main form in another Library DLL
password in access
jlgervais
First question: access password. If your database as a password, you can connect to it by declaring a password in your connection string, for example:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"
Which I got from http://www.connectionstrings.com/
Of course, you will need some way to obsfucate the connection string within your program.
Second question, you have couple of options: store it as a simple string, but display it using a specific font which contains the symbols/letters/numbers you need. Store it as a BLOB data type (A Microsoft Equation, for example, or a custom format).
Hope that helps, or gives you some ideas.
thinkCode96
Xeon_boy
Hi SJ,
I wonder if that's what the question is I agree with you that there are conection strings and that they may or may not be passworded and that is a way to globally controll access to a database for an application.
However, I was wondering if the questions were about invidual users having individual username/password protection
EarlyAdoptors
Hi all;
In fact, I am working in a project that is same as yours & also I want to restrict access to the database and the (cnn file) that links the VB application with the database...
Therefore, I am looking for help from you guys too..
Thanks.
JanJacobs
Hmmm, yes user/password control is set by the workgroup 'file': it's been a while since I've used access. However, I do remember that it was pretty much useless since it was straight forward enough to open up the database without supplying a user name/password (it was an older version of Access, 95 or so)
.
It's possible to set a global password, then have a 'users' table in the database itself, with the passwords hashed.
I guess it depends on what is trying to be achieved through security.
Alan Cobb
When I implemenented this, I just made a table for usernames, passwords and relative privileges.
The bad news is... I did it in VB6 in DAO 3.6 or was it ADO I never have known what the difference is between the two. But I have implemented this and it's quite doable.
Mark FMJ