Prev: MDE
Next: shared Access 2000 db in Access 2007
From: magick on 21 May 2010 12:44
ps - it is the 32 bit version.

"Tom van Stiphout" wrote:

> On Fri, 21 May 2010 05:26:01 -0700, magick
> <magick(a)discussions.microsoft.com> wrote:
>
> Perhaps this machine has Office 2010 64-bit installed against all
> recommendations, and the drivers are eh, sub-optimal.
>
> -Tom.
> Microsoft Access MVP
>
>
> >the oracle database is on a server, not local. the app runs numerous
> >reports, macros, queries, from various combo boxes or command buttons on
> >forms. Depending on what it is running, the macro error box comes up, then
> >when you click the "stop all macros" button, i get a "connection to '|'
> >failed" error. If it isn't a macro, I get the odbc call failed error
> >immediately. It never brings up the odbc driver connect login window. yes,
> >the dsn has been set up, and as i said, the test connection brings up the
> >odbc connect login window as expected, and is successful. i have this app
> >running successfully on hundreds of machines with a variety of operating
> >systems and office versions - this is the first install with office 2010.
> >what code would be helpful to post? thanks!
> >
> >"Tom van Stiphout" wrote:
> >
> >> On Thu, 20 May 2010 09:33:01 -0700, magick
> >> <magick(a)discussions.microsoft.com> wrote:
> >>
> >> What is the exact error? What is the app trying to do at that time?
> >> Maybe you can post some code. Is that ODBC database on the machine? Is
> >> an ODBC Data Source Name (DSN) setup in the ODBC applet?
> >>
> >> -Tom.
> >> Microsoft Access MVP
> >>
> >>
> >> >i recently got a new computer with win7, and also purchased Office 2010. A
> >> >database that i have had for years is producing odbc connection failed
> >> >errors. i had no problems with 2007 (with win7). i have gone throught the
> >> >"sandbox" security change in the registry that i found in the online help. i
> >> >have also added it to trusted sites, enabled macros, but still no luck. the
> >> >test connection in odbc administrator works fine.
> >> .
> >>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: MDE
Next: shared Access 2000 db in Access 2007