Security

[Jim Heavey]

I know nothing about securing my access database. I have figured out how
to set a password on my database and that seems to work, but what is the
associated "user name"? If I am going to build a VB front-end for the DB,
my connection string wants user name and password....what is the user name
in this instance?

I am thinking that I want a user/name and password which only has the
ability to read the table and no update authority and this will be the user
name/pass word that I will use in my VB.net application to access that
table. Is there a way to set up a user name and password with only read
ability and have another one which has full capability? How do I go about
doing this?

When I bring up enterprise Manager in SQL server and attempt to export data
to the Access Database, I can not log into the database now that I have set
this password. I can bring up access and get into the file, but it does
not ask me for my User ID. I tried "admin" and I also tried my Login name,
but neither works.

Got any ideas?

Thanks in advance for your assistance!!!!!!!!

 

[Brendan Reynolds]

The user ID and password options in the connection string apply to JET
user-and-group-level security, which you're not using. To specify a database
password, there's a different option. Here's an example ...

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\SomeFolder\SomeFile.MDB;Persist Security Info=False;Jet
OLEDBatabase Password=SomePassword

I got this by creating a UDL (Universal Data Link) file. Right-click in the
folder of your choice, choose New, then Text Document, then rename the text
file with a udl extension, e.g. 'test.udl'. Then double-click the UDL file
to open the Data Link Properties dialog. On the Provider tab, choose
Microsoft Jet 4.0 OLE DB Provider. On the Connection tab, browser to your
MDB file. Leave the user name as the default, 'Admin', and leave 'Blank
password' checked - this is the JET user-and-group-level security password,
not the database password. Now go to the All tab, select 'Jet OLEDB:
Database Password', and click the Edit Value button to enter your password.
Go back to the Connection tab and click the Test Connection button.

If all is well, you can close the Data Link Properties dialog, and open the
UDL file in Notepad to view and copy the connection string.