Open Access table with Password

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

Nov 20 '05 #1

1544

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

Nuno

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

One Handed Man

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:\Docu ments and Settings\Admini strator\My
Documents\Famil yPlusFriends.md b";Password=;Je t OLEDB:Engine Type=5;Jet
OLEDB:Global Bulk Transactions=1; Provider="Micro soft.Jet.OLEDB. 4.0";Jet
OLEDB:System database=;Jet OLEDB:SFP=False ;Extended Properties=;Mod e=Share
Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System
Database=False; Jet OLEDB:Don't Copy Locale on Compact=False;J et
OLEDB:Compact Without Replica Repair=False;Us er 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

Nuno

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:Databa se Locking Mode=1;Jet OLEDB:Database Password=;DataSource="C:\Doc uments and Settings\Admini strator\My
Documents\Fami lyPlusFriends.m db";Password=;J et OLEDB:Engine Type=5;JetOLEDB:Global Bulk Transactions=1; Provider="Micro soft.Jet.OLEDB. 4.0";JetOLEDB:System database=;Jet OLEDB:SFP=False ;Extended Properties=;Mod e=ShareDeny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create SystemDatabase=False ;Jet OLEDB:Don't Copy Locale on Compact=False;J etOLEDB:Compac t Without Replica Repair=False;Us er ID=Admin;Jet OLEDB:EncryptDatabase=Fal se

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

One Handed Man

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:\Docu ments and Settings\Admini strator\My
Documents\Famil yPlusFriends.md b";Password=;Je t OLEDB:Engine
Type=5;Jet OLEDB:Global Bulk

Transactions=1; Provider="Micro soft.Jet.OLEDB. 4.0";Jet
OLEDB:System database=;Jet OLEDB:SFP=False ;Extended
Properties=;Mod e=Share Deny None;Jet OLEDB:New Database
Password=;Jet OLEDB:Create System Database=False; Jet OLEDB:Don't
Copy Locale on Compact=False;J et OLEDB:Compact Without Replica
Repair=False;Us er 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

Cor

Hi Nuno,

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

Cor

Nov 20 '05 #7

NUno

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=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\Conve rsao\Optiware98 .MDB;pwd=et98ji f%Znf[2)"
Dim strSQL As String = "SELECT * FROM Clientes"
Dim Conn As OleDbConnection
Dim DA As OleDbDataAdapte r
Dim Ds As DataSet

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

Try
DA.SelectComman d.CommandType =
CommandType.Sto redProcedure

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

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=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\Conve rsao\Optiware98 .MDB;pwd=et98ji f%Znf[2)"
Dim strSQL As String = "SELECT * FROM Clientes"
Ds = New DataSet()

Dim Conn As New OleDbConnection (strDSN)
Try
Dim cmd As New OleDbCommand(st rSQL, Conn)
da = New OleDbDataAdapte r(cmd)
da.Fill(ds, "Mensagens" )
Return ds
Catch oledbExc As OleDbException
MessageBox.Show (oledbExc.ToStr ing)
Catch ex As Exception
MessageBox.Show (ex.Message)
Finally
Conn.Close()
End Try

Nov 20 '05 #9

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=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\Conve rsao\Optiware98 .MDB;pwd=et98ji f%Znf[2)"
Dim strSQL As String = "SELECT * FROM Clientes"
Ds = New DataSet()

Dim Conn As New OleDbConnection (strDSN)
Try
Dim cmd As New OleDbCommand(st rSQL, Conn)
da = New OleDbDataAdapte r(cmd)
da.Fill(ds, "Mensagens" )
Return ds
Catch oledbExc As OleDbException
MessageBox.Show (oledbExc.ToStr ing)
Catch ex As Exception
MessageBox.Show (ex.Message)
Finally
Conn.Close()
End Try

.

Nov 20 '05 #10

Similar topics

2945

Strange access denied problem

by: Steve | last post by:

Hi, Yesterday I signed up for another dedicated linux server with the hosting company I use and I am having problems getting MySQL 4.1.3 working on it. I've tried just about everything I can think of to login via the MySQL client but get a variation of the following error every time: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

MySQL Database

4597

Open and update a SQL table

by: Bruce Lawrence | last post by:

I have a table on a SQL server called history. When I link this table using an ODBC connection, i give it the username and password and tell it to save the password and it works great. On my PC. Other computers however get asked for the password each time they try to write records to the table. What I'm trying to do is remove the linked table and open the SQL database in a module and use the INSERT INTO query to insert my records and...

Microsoft Access / VBA

1889

Can't open my .mdb

by: dennist685 | last post by:

Can't open my .mdb I was experimenting with opening an access database in IIS. For experimenting, I have an .mdb called HasbaraSample. In this case I copied it to the C:\Inetpub\wwwroot\Access folder. I had various problems trying to get it to open in IIS. I went to asp.net forums and was told to right_click the app_data folder and click the security tab. To make a long story short, that never worked out.

ASP.NET

5486

MS Access Frontend for remote sql server

by: aspsql | last post by:

I have a website which runs off a Access database which I am currently converting to sql server database. I would like to still use my access front end for reporting and queries.. I created an odbc connection on my computer to the remote sql server and created a link in access to my sql server tables. All my report and Queries run fine I just have one problem it keeps on prompting me for ther password of the remote sqlserver database. I...

Microsoft SQL Server

3815

Open MS Acess with password protected in c#

by: -xx- | last post by:

Hi, I am new to c# and just trying out c# with ms access. First problem i encountered is how do i open up ms access that has password. Here is my current codes which working fine if there is no password on ms access: //Specify sql server-specific connection string private const string strdns = @"Provider=Microsoft.Jet.OLEDB.4.0;Data

C# / C Sharp

44113

Access startup - can you run code on database open?

by: JodiPhillips | last post by:

MS Access2000 Hi everyone, I've searched the forums for an answer to this question and nothing jumps out at me. When a database is opened I want to automatically run code (at start-up) that compares the path of the opened database to a specific path (where the original database is located). This is for security reasons - I need to know if the original database has been copied without authorisation. Due to network issues I cannot use...

Microsoft Access / VBA

3708

Need Help !!! Login Level to Open different form.

by: Mai Le | last post by:

Hello Experts. Coul you please help me to fix my program. I created a login from with 2 levels. Admin an User. If Admin login will open A form and If User login will open B form I had table tblAdmins EmpID EmpName EmpPassword

Microsoft Access / VBA

6901

open encrypted database programatically

by: n8kindt | last post by:

i'm trying to create a secure scenario where no one will be able to know our encrypted database passcode. BUT if they login to a form in another database successfully, it will open the encrypted database and systematically plug in the passcode thru vba (kind of like a user on a website logging into a secure SQL database i suppose). i may be going about this whole situation completely wrong but here is what i have for the code that i need to...

Microsoft Access / VBA

409

Re: Advice on securing a sensitive Access database

by: Les Desser | last post by:

In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very clear and I actually understand it!

Microsoft Access / VBA

9621

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9454

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10267

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10106

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10046

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9915

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6717

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3611

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2852

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General