Re: Accessing mdb file via VB code

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks guys, your info was good and I was able to get one of my forms up and
running, but then I encountered the error message "Unable to find
installable ISAM" when a connection to my database was attempted on another
form.( Man , talk about learing to ride your bike while trying to dodge
bricks!)

Googled this and went to MS KB where it talks about such a message but the
info they give (at KB # 283881) appears to deal with Access 2003 (which is
what I am using) but then goes on in the body to indicate that I am
supposed to look for a JET 3 file ! My provider is Jet 4.0 not Jet 3.


I am not afraid to edit the registry (Well I kinda sorta am but still can
do it if need be) but I am unclear if this KB article applies to me. All of
my connections are to the same DB and the conection string is the same:

Private m_adoConnection As ADODB.Connection

Dim strConn As String

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data " & _
"Source=" & m_sDataFile & ";" & _ 'm_sDatafile is my path
to my Database
"Jet OLEDB:Database Password = MyPassword; &
Mode=ReadWrite;"

m_adoConnection.Open strConn

What gives now??

Any


"Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
news:P5ednVKYeI7F0DTZnZ2dnUVZ_u6dnZ2d@xxxxxxxxxxxxxxx

"Jeff Johnson" <i.get@xxxxxxxxxxx> wrote in message
news:%23vots6rnGHA.1664@xxxxxxxxxxxxxxxxxxxxxxx
"AK" <nospam@xxxxxxxxxxx> wrote in message
news:%23AWrUArnGHA.5056@xxxxxxxxxxxxxxxxxxxxxxx

I started by adding a password to my test DB by setting it by using
Tools|Security

Then I changed my Connection.Open Method statements to add the UserID
and
Passwords.

If all you did was add a "database password" then "User ID" (note the
space)
and "Password" are not the keywords you want; you want "JetOLEDB:Database
Password".


Doh!

By using UserID and Password in the connection string one is telling Jet
that you intend to invoke User-Level security, not Database security, but
the 'current' mdw doesn't support that request.

-ralph
[sometimes one can have too much coffee! <g>]




.

Relevant Pages

  • Re: Changing Connection String programmatically
    ... Connection strings of different years can be stored in app.config ... is declared in MyDataset.Designer.cs as private, ... every year we will create new database. ... If you are storing connnection string information related to additional ...
    (microsoft.public.sqlserver.connect)
  • Send Form results to database error
    ... ' Send results to the database. ... ' myConnString = Connection string to database. ... ' myConnection = The database connection object. ...
    (microsoft.public.access.forms)
  • Re: User count
    ... Dim colUsers as New Collection ... Dim sCompName as string ... or back it up, or something, then take a look at the use of the "Connection ... Create a table in the front-end database, ...
    (microsoft.public.access.formscoding)
  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Installer - Custom Textboxes in UI problem
    ... > void Install function. ... I've tested it by writing the string out to a text ... > intended, a ADO.Net Connection String. ... > throw new InstallException("The database conection information is not ...
    (microsoft.public.dotnet.languages.csharp)