Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?

I had the same reaction when I saw it. In fact, I told somebody in this
newsgroup he was using the wrong provider before discovering my error.

William Vaughn wrote:
Thanks bud. I never would have guessed it based on the name. "ACE"?


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:eE72mf5zHHA.5948@xxxxxxxxxxxxxxxxxxxxxxx
William Vaughn wrote:
Bob, I just converted one of my NWind.mdb databases using Access
2007 and it created an entirely new database file with a new
extension. Now the
JET 4.0 OLE DB provider won't open it. What are customers supposed
to do now?
Fall back 10 yards and punt?


There's a new provider for the Jet2007 databases. I don't remember
what it's called. Off to connectionstrings.com ...
Here we go:
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Persist Security
Info=False;

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • 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)
  • Re: Help with configuring Connection Filtering - RBL - zen.spamhaus.org
    ... your abuse address here]" is just the template of error email. ... The RBL is provide by the connection filter provider: ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Winmgmt 5603 Error
    ... I would like to make sure that if you have applied SBS 2003 SP1, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | WMI provider runs under the LocalSystem context. ...
    (microsoft.public.windows.server.sbs)
  • Re: alt.binaries.birds not carried by major IPs.
    ... You could try a different newsgroup server... ... READ messages and do fairly little downloading, ... I do a bit more downloading - searching for rare songs, ... depend on your local broadband provider - and even if you change providers, ...
    (rec.birds)