Re: Accessing Access 2007 Databases

No, it is not included in MDAC (neither was the Jet provider after MDAC
2.5 I think ... too lazy to go look it up). I believe you have togo here
to get it:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Thatch wrote:
Bob,

Thanx. It worked like a charm.

Just one final questions. Is this provider part of MDAC when you
distribute software? Or must I distribute a specific file for it?

T

"Bob Barrows [MVP]" wrote:

Thatch wrote:
I'm using the following code to open an Access 2007 database:
Dim rstRecords as new ADODB.Recordset
Dim strConnectionString as string

' Set the connection string
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Databases\Access2007.accdb;Persist Security Info=False;"

' Connect to the database
rstRecords.let_ActiveConnection(strConnectionString)

And I get an "Unrecognized Database Format" error when I execute the
.let_ActiveConnection.

This works fine on an Access 2000 database but I'm trying to upgrade
to Access 2007 and I can't get Jet 4.0 to recognize the new
database. Any hints on what string I should use to make this
work????

T
There is a new provider you need to use for Access 2007 ... off to
connectionstrings.com to get its name ... Here you go:
http://www.connectionstrings.com/?carrier=access2007

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: cant access databases publisher 2002
    ... Can you open the database file in Works? ... Look at the Works newsgroup. ... I have tried to update the MDAC and I get "MDAC 2.8 RTM is ... Have you downloaded the component checker to see if you have any MDAC ...
    (microsoft.public.publisher)
  • Re: IIS, asp and a database
    ... Is performance better in a OLEDB ... > Provider if you set the Data Source=the complete path to ... full path to the database. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: accessing blob fileds from oracle
    ... I am connecting to Oracle9.2 database from VB6.0 using MSDAORA ... provider. ... This is a VB.Net newsgroup. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Backup Wizard Error
    ... > This newsgroup only focuses on SBS technical issues. ... >>1) There are no error regarding the backup application, ... This provider will be run using the LocalSystem ... >>2) Well the Backup Wizard (Server Management\Standard ...
    (microsoft.public.windows.server.sbs)
  • Re: DNS Name
    ... This newsgroup only focuses on SBS technical issues. ... <POP 3 provider? ... <ten employees and one POP3 for the extra 60 or so non-employees. ... Do you plan to handle all the e-mails on the new Exchange ...
    (microsoft.public.windows.server.sbs)