By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,154 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,154 IT Pros & Developers. It's quick & easy.

Open Access table with Password

P: n/a
How can i open a Access Table that have a password?
Can somebody help me?
Thanks

Nov 20 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
Are you saying you dont have the password, or you dont know how to pass it
in the connection string ?

Regards - OHM

Nuno wrote:
How can i open a Access Table that have a password?
Can somebody help me?
Thanks

Nov 20 '05 #2

P: n/a
I Dont know hot to pass it...
-----Original Message-----
Are you saying you dont have the password, or you dont know how to pass itin the connection string ?

Regards - OHM

Nuno wrote:
How can i open a Access Table that have a password?
Can somebody help me?
Thanks

.

Nov 20 '05 #3

P: n/a

You will find that the connection stringfor the connector will look
something like this, just put the Database Password= entry in and hopefully
it will work.

Regards - OHM

Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data
Source="C:\Documents and Settings\Administrator\My
Documents\FamilyPlusFriends.mdb";Password=;Jet OLEDB:Engine Type=5;Jet
OLEDB:Global Bulk Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0"; Jet
OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share
Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt
Database=False

Nuno wrote:
I Dont know hot to pass it...
-----Original Message-----
Are you saying you dont have the password, or you dont know how to
pass it in the connection string ?

Regards - OHM

Nuno wrote:
How can i open a Access Table that have a password?
Can somebody help me?
Thanks

.

Nov 20 '05 #4

P: n/a
When i try to open it...i give me this message "COULD NOT
FIND INSTALLABLE ISAM"

Can you help me...?
-----Original Message-----

You will find that the connection stringfor the connector will looksomething like this, just put the Database Password= entry in and hopefullyit will work.

Regards - OHM

Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;JetOLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;DataSource="C:\Documents and Settings\Administrator\My
Documents\FamilyPlusFriends.mdb";Password=;Jet OLEDB:Engine Type=5;JetOLEDB:Global Bulk Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0"; JetOLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ShareDeny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create SystemDatabase=False;Jet OLEDB:Don't Copy Locale on Compact=False;JetOLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:EncryptDatabase=False

Nuno wrote:
I Dont know hot to pass it...
-----Original Message-----
Are you saying you dont have the password, or you dont know how to pass it in the connection string ?

Regards - OHM

Nuno wrote:
How can i open a Access Table that have a password?
Can somebody help me?
Thanks
.

.

Nov 20 '05 #5

P: n/a
http://www.visual-basic-data-mining....spx?PostID=791
Nuno wrote:
When i try to open it...i give me this message "COULD NOT
FIND INSTALLABLE ISAM"

Can you help me...?
-----Original Message-----

You will find that the connection stringfor the connector will look
something like this, just put the Database Password= entry in and
hopefully it will work.

Regards - OHM

Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data
Source="C:\Documents and Settings\Administrator\My
Documents\FamilyPlusFriends.mdb";Password=;Jet OLEDB:Engine
Type=5;Jet OLEDB:Global Bulk

Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0"; Jet
OLEDB:System database=;Jet OLEDB:SFP=False;Extended
Properties=;Mode=Share Deny None;Jet OLEDB:New Database
Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't
Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False

Nuno wrote:
I Dont know hot to pass it...

-----Original Message-----
Are you saying you dont have the password, or you dont know how to
pass it in the connection string ?

Regards - OHM

Nuno wrote:
> How can i open a Access Table that have a password?
> Can somebody help me?
> Thanks
.

.

Nov 20 '05 #6

P: n/a
Cor
Hi Nuno,

Are you using VB.net with ado.net?
or
VB.Net with DAO?
or
MS Access?

Cor

Nov 20 '05 #7

P: n/a
THERES THE CODE...IM NOT SURE IF I CAN DO LIKE THIS...
IM REALLY CONFUSE...
Thanks...

Function OpenTable() As DataSet
Dim strDSN As String
= "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Conversao\Optiware98.MDB;pwd=et98jif%Znf[2)"
Dim strSQL As String = "SELECT * FROM Clientes"
Dim Conn As OleDbConnection
Dim DA As OleDbDataAdapter
Dim Ds As DataSet

Ds = New DataSet()
Conn = New OleDbConnection(strDSN)
DA = New OleDbDataAdapter(strSQL, Conn)

Try
DA.SelectCommand.CommandType =
CommandType.StoredProcedure

DA.Fill(Ds, "Mensagens")

Return Ds

Catch e As Exception
MessageBox.Show(e.Message)
Finally
Conn.Close()
End Try

End Function

-----Original Message-----
Hi Nuno,

Are you using VB.net with ado.net?
or
VB.Net with DAO?
or
MS Access?

Cor

.

Nov 20 '05 #8

P: n/a
Cor
Hi Nuno,

Can you try it with these changes, and if it does not work, cut that pwd
part again from it and try it again.

I hope this does work?

Cor
Function OpenTable() As DataSet
Dim strDSN As String
= "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Conversao\Optiware98.MDB;pwd=et98jif%Znf[2)"
Dim strSQL As String = "SELECT * FROM Clientes"
Ds = New DataSet()

Dim Conn As New OleDbConnection(strDSN)
Try
Dim cmd As New OleDbCommand(strSQL, Conn)
da = New OleDbDataAdapter(cmd)
da.Fill(ds, "Mensagens")
Return ds
Catch oledbExc As OleDbException
MessageBox.Show(oledbExc.ToString)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
Conn.Close()
End Try

Nov 20 '05 #9

P: n/a
It Still give the same error...
The pwd is the password of the table...
but thanks for your efforts...

-----Original Message-----
Hi Nuno,

Can you try it with these changes, and if it does not work, cut that pwdpart again from it and try it again.

I hope this does work?

Cor
Function OpenTable() As DataSet
Dim strDSN As String
= "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\Conversao\Optiware98.MDB;pwd=et98jif%Znf[2)"
Dim strSQL As String = "SELECT * FROM Clientes"
Ds = New DataSet()

Dim Conn As New OleDbConnection(strDSN)
Try
Dim cmd As New OleDbCommand(strSQL, Conn)
da = New OleDbDataAdapter(cmd)
da.Fill(ds, "Mensagens")
Return ds
Catch oledbExc As OleDbException
MessageBox.Show(oledbExc.ToString)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
Conn.Close()
End Try

.

Nov 20 '05 #10

P: n/a
I think this is typically caused by a bad connection string. One common
error is not putting a space in Data Source. In case of word wrap, that
should read Data Source.

"Nuno" <an*******@discussions.microsoft.com> wrote in message
news:05****************************@phx.gbl...
When i try to open it...i give me this message "COULD NOT
FIND INSTALLABLE ISAM"

Can you help me...?
-----Original Message-----

You will find that the connection stringfor the

connector will look
something like this, just put the Database Password=

entry in and hopefully
it will work.

Regards - OHM

Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry

Path=;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Database

Password=;Data
Source="C:\Documents and Settings\Administrator\My
Documents\FamilyPlusFriends.mdb";Password=;Jet

OLEDB:Engine Type=5;Jet
OLEDB:Global Bulk

Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0"; Jet
OLEDB:System database=;Jet OLEDB:SFP=False;Extended

Properties=;Mode=Share
Deny None;Jet OLEDB:New Database Password=;Jet

OLEDB:Create System
Database=False;Jet OLEDB:Don't Copy Locale on

Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;User

ID=Admin;Jet OLEDB:Encrypt
Database=False

Nuno wrote:
I Dont know hot to pass it...

-----Original Message-----
Are you saying you dont have the password, or you dont know how to pass it in the connection string ?

Regards - OHM

Nuno wrote:
> How can i open a Access Table that have a password?
> Can somebody help me?
> Thanks
.

.

Nov 20 '05 #11

P: n/a
On Fri, 28 Nov 2003 03:45:17 -0800, "Nuno" <an*******@discussions.microsoft.com> wrote:

How can i open a Access Table that have a password?
Can somebody help me?

Assuming you mean database password?

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db2.mdb;" & _
"Jet OLEDB:Database Password=password"
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.