Visual Basic :: :Connection String Of Password Protected Access Database

Access Report Password Protected From VB5 DAO Connection
Can anybody help me out with this one: I have an Access Report that I would like to call from my Visual Basic Application, the Access Database is password protected.

here is the code I've been trying:

Code:
dim objAccess as Object

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase AppPath & "DBName.mdb"
objAccess.Visible = False
objAccess.DoCmd.OpenReport "ReportName", acViewPreview
objAccess.Quit
Set objAccess = Nothing

'
' This other one didn't work either
'
' CrystalReport1.ReportFileName = AppPath & "ReportName.rpt"
' CrystalReport1.Password = "Password1"
' CrystalReport1.Destination = crptToPrinter
' CrystalReport1.Action = 1
'
If there is a way that I could get rid of those and call the Access Report from Visual Basic instead you know, without using Access library OR if there is an easier way to include the password on the connection, It will be helpfull a lot.

tks. in advance.

Edit by Moderator: Please use the [vb][/vb] tags when you post your code. Reply to, or edit this post to see how.

Pass A Password To A Password Protected Access Database Using OLE??
I need to pass a password to an access database that is password protected.

This database is going to be opened by a vb app, that uses the access application ref. 9.0 libary. What I need to do is open a report in preview mode. All that I have done previously.

This is the code...

Dim AccessApp As Access.Application
Set AccessApp = New Access.Application

AccessApp.OpenCurrentDatabase ReadFromINI("DATABASES", "ESITE", App.Path & "settings.ini")
AccessApp.DoCmd.OpenReport "rptAnvändarLösen", acViewNormal
AccessApp.CloseCurrentDatabase

Set AccessApp = Nothing

When I have done this before the OpenCurrentApplication had a seperate input for password, but not the 9.0 library...

How can I answer the password box that now appears on the screen..???

/Smirre

Supplying Password For Password Protected Access Database
for protection of access database suppose i set password for the database.

then i have given the connection string to connection object of ADO. now if i open this connection for database i get an error.
so any suggestions in this matter are welcome.

Password Protected Database Access
If I want to access a database through my code is there any way that I can disguise the password?

For example, is there a way to NOT have the password show up in my code?

Rather than show this:
Oracon.Open "Provider=MSDAORA;User ID =; Password = "vbforumsRock"; Data Source = ora1.gv.hsu;"

I'd rather show:
Oracon.Open "Provider=MSDAORA;User ID =; Password = "************"; Data Source = ora1.gv.hsu;"

Password Protected Access Database
ive got an access database which i want to be password protected, how do i access this through VB6? ive tried MSDN and i cant seam to find nething

thanx in advance
chenko

Password Protected Access Database
How to open password protected Access Database with ADO connectoin

My connection is as follow
Public Function OpenDB()
sconnect = App.Path & "db1.mdb"
sprovider = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=False;Data Source=" & sconnect
With cnn
.ConnectionString = sprovider
.Open
End With

Password Protected Access Database
Hello,

I have an Access Database that is protected by password.  I want to open that Database using ADO the code used is shown below

Dim cnClass as Connection
Dim rs as Recordset

Set cnClass = New Connection
  cnClass.Open "Provider=Microsoft.Jet.OLEDB.4.0 ;" & _
                "Data Source=" & App.Path & "DatabaseClass.mdb"

When I try to add a password field in it, it starts giving errors.

Can someone help me with this.

I want to use ADO and password in the database.

Thanks in advance

Password Protected Access Database
I create a database in MS Access, and I put a password for security.
now when I was accessing the database without password it was working fine. but after putting the passward it is not being accessed in my program.

can anybody tell how to access this database from a visual basic program.
I have created a DSN using some coding in Visual basic. Each time when the program runs the dsn is created automatically.

I am using ADO for connectivity.

I am waiting eagerly.

with best regards.
shiv

DAO Password Protected Access Database
Hi,

how can i connect to an Access database that has a password on it

When i use opendatabase("<Mypath>",,,"pwd=<MyPassword>") it says that my password is incorrect (and i'm sure it is not.

PS i know how to do this with ado, but it is a program that is already written and now we have to change it so the database has a password on it.

Thanx

Connect To Password-protected MS Access Database
Dear Friends

I Am the beginner-programmer, working in Vietnam (Small country in South-east Asia)

I have the following problem:

We have the web-page, using ASP, to retreive data from a Access Database (not password protected).

We are also work within a group, each user has their own password to log-in to the database.

Now we try to set the password for the database, but then, the ASP does'nt work.

The code I use is:

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "MyDB","username","password"
sql = "SELECT * FROM MyTable"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
reponse.write "Result: " & rs.fields("Filed_Number_1")
rs.close

The server return the message of "Not correct username or password" when the password is set. It we do not set the password. it runs OK.

Can you - experts, to help me on that

Thanks a lot

Trung

How Do I Connect To A Password Protected Access Database?
Hi Every one,
I ve created an application using VB 6.0 SP 5 and using backend as ACCESS XP. It is working all fine. I m using Jet Engine 4 to connect. Now I want to upgrade my database. I made it password protected. After that i have set the same password in my ADODC controls and changed the connection string property. But still it is not able to access the database. It gives some Data link error. If any one has experienced such kind of problems before then please do help me.

Thanks A Lot...

Dipanjan.

Opening A Password-protected Access Database
Hi Guys,

I do have an MS access 2000 database and it is password protected... Now im making an ADO recordset in vb6 and i want to open the database. Can somebody here help me in making the right connection string in the adodc property? Thank you very much!!!

Connecting Password Protected Access Database
Hi,

i know this has been asked a lot of times but i haven't found a good solution for my problem so i ask again.

I want to connect to an access database that is password protected (i set password through access menus--> tools --> security

My connection string is

Code:

Set m_cn = New adodb.Connection

With m_cn
If .State <> adStateOpen Then

.CursorLocation = adUseClient

.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source==" & App.Path & "db2.mdb;" & _
"Jet OLEDB:Database Password=banksim", _
"Admin", "banksim"

End If
End With
and i get error :

-2147217843(80040e4d) Application can't be initialized.Workgrup information file is missing or is open in exclusive mode by another user

I'm using Access 2003 database, and i haven't set a workgrup

What it's wrong here?

Opening A Password-protected Access Database With VB6 Or VB.NET
How do you open a password-protected Access database file in the program invoked in a Visual Basic 6 or .NET project? I'm concerned about this, because I want to be more confident or secure about the program that I'm going to give to the final end-user of a company, including that concerned database file.

Opening Password Protected Access Database
I am trying to open a password protected Access 97 database using DAO,
without using ADO. The Opendatabase method doesn't seem to support this for
Access databases. If I try
Set dbsStudent = OpenDatabase("Student.mdb", , , "Jet;pwd=mypassword"), it
does not work. Can anyone help?
Regards
Phil Jones
The Logical Interface
02 9541 0367
www.logint.com.au
email@removed

Connecting To A Password-protected Access Database From A VB5 App
Hi all,

I am trying to connect to a password-protected Access database from a VB5 app. (Yes, I know the password - I'm not trying to bring down the government.) I can connect to a databse that isn't password-protected. But once a password is introduced, I don't know how to tell the app what the password is.

I've been told that ODBC is the way to go. Is this true? If so, how do I do this step by step? Bear in mind that I need to be able to package the whole thing up into a single installation executable.

Thanks!

Problem With DAO 3.6 With ACCESS 97 Password Protected Database
Hello,

When setting my reference to DAO 3.6 Object Library ,I'm getting an invalid password problem with the following syntax''

Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase(Appath + "aopt1", False, False, "MS Access; PWD=psswd")

When I try to put the reference back to DAO 2.5/3.5, I'm still getting the invalid password error message.

Please Help.

Thanks.

Access Automation With Password Protected Database
(VB6, DAO v3.6, Access library v9.0)

i've been pulling my hair out now for two days because of two lines of code.

this code works perfectly fine (access opens and it opens the database perfectly) ...
Code:Set tempDB = oAccess.DBEngine.OpenDatabase(sDatabaseName, False, False, "MS Access;PWD=password")
oAccess.OpenCurrentDatabase sDatabaseName, False

however, change the read-only option to True and now it doesn't...
Code:Set tempDB = oAccess.DBEngine.OpenDatabase(sDatabaseName, False, True, "MS Access;PWD=password")
oAccess.OpenCurrentDatabase sDatabaseName, False

after it executes the second line, Access pops up the password box for the database. if i manually type in the password and hit ok, the code continues.

to add more soup to the mix ... normally i use an MDB file. if i use the same code in my first example above, it works fine. if i change the database to a MDE file (and change the sDatabaseName variable appropriately) access will no longer open the database as i get a error 7866 -- "the database cannot be found or it is already opened exclusively by another user"

i've been searching the microsoft site and google for about 6 hours, any ideas?

thanks,
syn

(edit: p.s. my goal here is to open the database in a way so that the user (or access) is prevented from altering the database. so getting either the read-only to work or the MDE method is sufficient)

Edited by - syntax53 on 11/30/2004 11:26:23 AM

Access Password Protected Database Compression Using Vb6
i am using access2003 with windowsxp database my MDB is password protected and i want to compress it because it is jet database
i have used the following lines of code

Dim JRO As JRO.JetEngine

Set JRO = New JRO.JetEngine

  JRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Data Source=" & strWorkDB & ";Jet OLEDBDatabase Password=abc", _
                      "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                      "Data Source=" & mstrBakDB & ";Jet OLEDB:Encrypt Database=True;Engine Type=4;Jet OLEDBatabase             Password=abc"

where as strWorkDB as source databse name and path and
  mstrBakDB as destination databse name and path and

but it generate an error that is
"Could not find installable ISAM"

any body can help me

How To Open A Password Protected Access Database In Vb?
Please help me! I am trying to open a password protected database using vb.I appreciate if someone can provide me with the codes. I put a password in the Database so that people can't edit from it,but now my problem is how can i access the record using vb.

Here is my codes:

Private Sub Form_Load()
    Dim reply, prompt
    Set dbTimeRecorder = OpenDatabase("C:ClockTimeRecorder.mdb", False, False)
    Set rsEmployee = dbTimeRecorder.OpenRecordset("Employee", dbOpenTable)
    Set rsRecords = dbTimeRecorder.OpenRecordset("Records", dbOpenTable)
    Me.Show
    prompt = "YOUR CURRENT SYSTEM DATE IS " & UCase(Format(Date, "MMM.DD, YYYY")) & " IS THIS CORRECT?"
    reply = MsgBox(prompt, vbYesNo, "SYSTEM DATE CHECK")
    If reply = vbYes Then
        frmSplash.Show 1
    Else
        Calendar.Show 1
    End If
    With rsEmployee
    While Not .EOF
    '.MoveFirst
    If !In = "YES" And !Indate = Date Then
    lstPresent.AddItem !Firstname & " " & !LastName
    .MoveNext
    Else
    .Edit
    !In = "NO"
    .Update
    .MoveNext
    End If
    Wend
    End With


End Sub

Edited by - labmher on 2/25/2003 8:07:18 PM

Connecting To Password Protected Access Database
I have made a few posts on this subject and I have yet to get this feature to work.

I have an access database. It has a user account that is password protected. I know the username and password, but I don't know how to open the database using ADO in VB6. If I get rid of the password, I can open it no problem. I REALLY need to have this DB password protected.

Can anyone please tell me how, via a working example or other means, HOW to open a connection to a password protected database- Using ADO.

This is driving me crazy. I can't get it to work no matter what I try.

There has to be someone out thee who has done this and can share with me HOW they did it.

Thanks,
Josh

Edited by - JoshSommers on 10/2/2002 2:30:18 PM

Accessing A Password Protected Access Database
I have password protected an Access database to prevent unauthorized editing of tables. However I have this problem of accessing it thru VB using OLE DB connection. I have no problem with using an ODBC but I want it done using direct connection. The same is with crystal reports. Can anyone help me?

Opening Password Protected Access Database In Vb Using Ado
Hi,

I would like to know the coding for opening a access database using the ado ole db provider.

Please help me.

Thanks

How To Open Password Protected ACCESS Database
Hi...
I have given a password in access. Now I want to use database in VB through DAO. How do i do this?
Kindly help. Urgent!!!

Thanks in advance

Santulan

ADO - Accessing A MS Access Password-protected Database
Hi, I have a password-protected Access database (a password on the database itself) and I'm trying to open a connection to it using the following code:

On Error GoTo HandleDbNotAccessible

Dim conn As ADODB.Connection

Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & txtDbFilePath.Text & ";"
Call conn.Open(, txtUID.text, txtPWD.text)
Exit Function

HandleDbNotAccessible:
MsgBox ("The database either cannot be accessed with the information you supplied or does not exist.")

However, this always fails. I have a form in which I request the file path of the database and the username and password and then run this code when they click OK. I'm also wondering if there is even a username associated with an Access password-protected database. If anyone has any knowledge about these things, *please* teach me.

Thanks so much,

Sonny

Open Access Form From A Password Protected Access Database Through VB
Iam using a password protected Access database. I can open the database with out any problem. There is a startup Access form associated with this database. I would like to open this form with out any prompt to the user for the password. When the program is run, the database opens twice. The first instance with the login screen prompting the user for the password. The second instance opens as desired. How to overcome this problem with the program opening the form only once.
Code:

Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Private Declare Function GetKeyboardState Lib "user32" (pbKeyState As Byte) As Long
Private Const VK_NUMLOCK = &H90
Private Const VK_SCROLL = &H91
Private Const VK_CAPITAL = &H14
Private Const KEYEVENTF_EXTENDEDKEY = &H1
Private Const KEYEVENTF_KEYUP = &H2

Private Sub SafeSendkeys(ByVal keys As String, Optional bWait As Variant)
Dim keysBefore(0 To 255) As Byte
Dim keysAfter(0 To 255) As Byte
Call GetKeyboardState(keysBefore(0))

If IsMissing(bWait) Then
Call SendKeys(keys, False)
Else
Call SendKeys(keys, CBool(bWait))
End If
Call GetKeyboardState(keysAfter(0))

If keysBefore(VK_NUMLOCK) <> keysAfter(VK_NUMLOCK) Then
Call keybd_event(VK_NUMLOCK, &H45, KEYEVENTF_EXTENDEDKEY, 0)
Call keybd_event(VK_NUMLOCK, &H45, KEYEVENTF_EXTENDEDKEY Or KEYEVENTF_KEYUP, 0)
End If
If keysBefore(VK_CAPITAL) <> keysAfter(VK_CAPITAL) Then
Call keybd_event(VK_CAPITAL, &H45, KEYEVENTF_EXTENDEDKEY, 0)
Call keybd_event(VK_CAPITAL, &H45, KEYEVENTF_EXTENDEDKEY Or KEYEVENTF_KEYUP, 0)
End If

If keysBefore(VK_SCROLL) <> keysAfter(VK_SCROLL) Then
Call keybd_event(VK_SCROLL, &H45, KEYEVENTF_EXTENDEDKEY, 0)
Call keybd_event(VK_SCROLL, &H45, KEYEVENTF_EXTENDEDKEY Or KEYEVENTF_KEYUP, 0)
End If

End Sub
'Under a click event I have:
'************************
UserApps(AppAP).appRunPath = "C: estdb1.mdb"
If UserApps(AppAP).appAvailable = True Then LaunchFile (UserApps(AppAP).appRunPath)
hApp = FindWindow(vbNullString, "Password Required")
Call SetForegroundWindow(hApp)

Call SafeSendkeys("password", True)
Call SafeSendkeys("{Enter}", True)
'************************
What is wrong in my code?

Thanks in advance.
Rama

How To Open An Access Form From A Password Protected Access Database?
I have a password protected access database. I can open this database. Though the startup form (Access form) comes up, the database opens twice. One instance with the login screen for the password (since the database is password protected) and the other opens properly with the form. Can any one help in opening without the first instance occuring?

Code:
UserApps(AppAP).appRunPath = "c: estdb.mdb"
If UserApps(AppAP).appAvailable = True Then LaunchFile (UserApps(AppAP).appRunPath)
(AppAP).appRunPath, "password")
hApp = FindWindow(vbNullString, "Password Required")
Call SetForegroundWindow(hApp)
Call SafeSendkeys("password", True)
Call SafeSendkeys("{Enter}", True)

Thanks in advance,
Rama

Dataenvironment With Access Database Password Protected, Is It Posible Or Not
please tell me how to connected with
dataenvironment and Access database password protected

is it posible or not

thankx

Open Access Password Protected Database Issues.
Hi, I am having trouble in perhaps both creating and opening an access password protected database. I opened the database for exclusive user only and created a password for the database. On trying to acces it via an ADODC control, I get an error stating workgroup absent or opened exclusively by user.
How can I avoid this by connection via ADODC control page property and via connection string thanks.

DAO: Opening A Password Protected Access 2000 Database...
How do I do that if I'm using data control to access my Access databases? How do I put it in plain code too?

Please help. Thanks.

Using Password Protected Access Database With Data Environment
Hi,
I need to use a password protected access database with data Environment in vb 6.

I do not know anything about workspaces and the software that i am designing will be used on several machines which will not share a single workspace file.

When i try to give a password in the connection property in data environment, i get an error stating the workgroup info file is missing.

Please help me on how to use the password protected access database with th data designer.

I am not using any library for data access.

Thanks

VB5 Application Can't Connect To Password-protected Access Database
This question concerns the same scenario described in my previous question (subject "VB5 connecting to MS Access 2003"). I am writing a VB5 application that connects to an Access database.

The problem is this. I want to place a password on the .mdb file because it contains sensitive client data. I don't want anybody to be able to gain access to it by double-clicking on it. But when I do this, my application can't connect to it.

Taking into account the information described in my previous question (that is, the fact that I'm using a Data Access Object pasted onto my form), how do I tell my application what the .mdb file's password is so that it can connect to it?

Thanks again for your help.
Greg.

Changing An MS Access Password Protected Database From Within VB Code
Hi everyone,

I am trying to allow my application to change it's MS Access database password. I have to have the database password protected but I also need the user to be able to change that password from with my VB application that I am creating.

Thanks in advance.

Thank you for all your help

www.besware.com
Tom

Working With A Password Protected Shared MS Access Database
Hello all,
I have to open a password protected Access database from VB 6.I am using a dsn connection and the code is

Set db1 = New ADODB.Connection
db1.Open "fms", "Admin", "password"
Dim rs As New ADODB.Recordset
Set rs = db1.Execute("Select * from userdata")

If I am running the application as an administrator of the domain/computer ,it is working fine,But if I logged in as a

normal user of the domain , and try to run the application I am getting the following error

Runtime error= '-2147467259(800045)'[Microsoft[ODBC]Microsoft Access Driver]Could not use '(unknown)'file already in use.

I have to access a password protected shared database from the server using dsn connection.My application is a client side

application. So at a time ,more than one user is trying to access this database and will have to do all type of database

opearation (read,add,modify and delete)
Anybody please help me

Dhanya

Compacting A Password Protected Access-2000 Database
I have developed many VB 6.0 applications using MS-Access 2000 as backend. I want to compact the database from VB Form. Till today, I am compacting the db by opening MS access and using the "Compact and Repair" option from the Menu.

The Access-2000 Database is a password protected one and I am using ADO codiing. I have tried DBEngine.CompactDatabase method and it works only with Access-97 databases.

Since the database file I am using in the application is a dynamic one, and keep on growing in its size, I want to compact from the application itself.

Thanks in advance.

-Madhu

Open A Password-protected Database Through Automation In Access 2000
Hello All,

I'm using the above with some difficulties, the
only problem that I have left with is the Access prompt message.

When opening the DB to copy from, Access prompt
a question window (attached image...), how can I go with
the process without this Access msgbox?

currently using:

Code:
Dim tmpDB As DAO.Database
Dim objApp As Object
Dim Source As String, Destination As String
Source = App.Path & "file.mdb"
Destination = App.Path & "new_file.mdb"
Set objApp = CreateObject("Access.Application")
objApp.Visible = False
Set tmpDB = objApp.DBEngine.OpenDatabase(Source, False, False, ";PWD=mypass")
objApp.OpenCurrentDatabase Source
tmpDB.Close
Set tmpDB = Nothing
objApp.DoCmd.TransferDatabase acExport, "Microsoft Access", Destination, acTable, "Table_1", "Table_1"
objApp.CloseCurrentDatabase
objApp.Quit
Set objApp = Nothing

Generate Crystal Report Using Password Protected MS Access Database
Respected Sirs,

I m using crystal report 9 for reporting, ms access2003 as back end and VB6 as Front end.
My project is runing prperly but while generation reports software gives error as [ODBC Microsoft Access Driver] invalid connection string attribute DATABASE
so pls help me
pls give me any suggestion.
thanx

How To Open MS Access Database Which Are Password Protected Using MS ADODC Control
Hello to all of u once again...

Now i am in BIG trouble... i hav one more week to complete this project and i cant find a method to connect MS Access Database(a password protected database) to MS ADODC Control.

I hav the codes to conncect Password Protected database with DAO 3.6, but not with ADODC Control.

So can anyone of u help me by givin the steps for how to solve my problem. It wud do a great help for me.

Thanking you in advance...

Adhu

Accessing Password Protected Ms Access Database In Crystal Reports
Sir,

I am using vb6 and crystal reports 8.0 and ms access database 2002 . i want to access password protected database and want to send password to crystal reports at runtime .

Please Help me
Thanx in Advance

Access Password Protected Access Database
heyy all..just a small question..

i use DAO to manipulate my access database. When i protect my database with a password, i cannot access it with my code. I get an error message saying "Invalid password" i think or something like that. Where should i include the password in my code?

The code i use to access my database is in a module, and this is it:

VB Code:
Public dbServer As DatabasePublic rsFileLog As Recordset public sub connect()Dim qry As Stringqry = "Select * from FileLog" '<--- Table name is FileLogSet dbServer = OpenDatabase(App.Path & "Log.mdb") Set rsFileLog = dbServer.OpenRecordset(qry, dbOpenDynaset)

thanxx in advance

How To Put Password In Access For Connection String Password?
I want that no one can open Access database that is shipped with My App.
I use following connection String.
cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "" & DBName & ";User Id=Admin;Password=MyPw"

Without using password and configuring any thing in Access, it works fine. But using Password, I can't Open DB.
TO use Password in connection string, what should I set in Access?

I tried :
1. Open exclusive, Tools --> Security --> Set Database Password ==> didn't work
2. User and Group Accounts --> Change Logon Pass for Admin.. ==> didn't work..

Does any one know how to do this?

Thank you..

Connection String For Access W/password
I'm trying to figure out how to connect to a pword protected access database thru vb6 using ado.
I did some searching and tried some of the examples in http://www.carlprothman.net/Default....orMicrosoftJet, but I'm still having problems.

The example from that page that applies is: oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:somepathmydb.mdb;" & _
"Jet OLEDB:Database Password=MyDbPassword", _
"myUsername", "myPassword"

But my db doesn't have a username.
I've only given it a password to keep prying eyes from opening it directly.

The connectionstring I use to open it without a password is:AdoSettings.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "Eva.mdb;Persist Security Info=False"

Can someone tell me how to modify the above connection string to include a password?

ADO Connection String For Access W Password
Hello,

anybody know how to open passworded access db with ADO .... ?

I use this one and not workout :

with connobj
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Password=aaa;Data Source=" & strDataPath & ";Persist Security Info=False"
.open
end with

the error msg sound like this
'The workgroup information file is missing or opened exclusively by another user'

thank you..
handy

Connection Strings + Password Protected Excel
Hi Pals.
Do everyone know how to access excel connection strings with password protected?
let said x.xls protected with password 123

connection strings:
connX = "Driver={Microsoft Excel Driver .xls)};DriverId=790;Dbq=c:DemoImportx.xls;DefaultDir=c:DemoImport;"

where to add password from the above line?

Hanz

Database Password Protected
How can I protect my database with a password.
Access database can be protected by password by opening it exclusively & then setting the database password.

Then when I use the connection to this password, first it said "Not a valid password", then I changed my connection string to set a password then it generated an error "The File is opened exclusively by another user"

Could somebody help me secure my database & still use it in the application.

Thanks in advance

Password Protected Database
When I try to connect a Access 2000 Password Protected Database through ADO, I am getting this following error:-

Unable to initialisze provider. Workgroup information file may be missing or it may be exclusively opened by other users.

How to overcome this problem and establish ADo connection with the mdb file.

Thank you in advance.

Password Protected Database
I am trying to make an access db that is password protected and make a graphical front end in VB to access it
Or if there is a tutorial that does this can I get pointed in that direction

Password Protected Database...
Here is a code that compares the name and password of a password protected Access database against two textbox entries:

Code:strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:JD Records" & txtdbName.Text & ".mdb;Jet OLEDBatabase Password =" & txtdbPassword.Text

I have two qiestions:

1) How can I do error checking, to see whether the entries match?

2) Can I still add the "Persist Security Info=False" to the end of it?

Many thanks...

Edited by - D-Race on 8/10/2006 8:43:14 AM