Make sure you save the password with your ODBC connection strings.
--- In vantage@y..., Joanne Yargeau <jyargeau@t...> wrote:
> We have a new wrinkle. We can now run the programs after doing a
registry
> fix program from Epicor. However if you get out of Access and then
go back
> in to run a program you will get the error [MERANT][ODBC PROGRESS
> driver][PROGRESS] Access denied(authorisation failed)(7512)(#-
20228). The
> way around this is to go to File, get external data like you are
going to
> get a new table then just say OK without saving password then you
will be
> able to run your Access programs as long as Access remains open.
But if you
> close Access then you will have to repeat the process of getting
external
> data. This is really a pain but at least we can now run the
programs. I
> will be talking with Epicor more on this.
>
> -----Original Message-----
> From: Leonard, Jeremy [mailto:jleonard@k...]
> Sent: Tuesday, April 16, 2002 10:22 AM
> To: 'vantage@y...'
> Subject: RE: [Vantage] 4.00 to 5.00 ODBC problem
>
>
> I'm having the same issue with a few tables. From everything I
have read it
> seems to me that in my case I need to do an index rebuild.
>
> Hope that helps
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Joanne Yargeau [mailto:jyargeau@t...]
> Sent: Tuesday, April 16, 2002 7:50 AM
> To: 'vantage@y...'
> Subject: RE: [Vantage] 4.00 to 5.00 ODBC problem
>
>
> We ran the ODBC fix program from Epicor. Now I don't get any
errors and I
> can link the tables in Access and that comes up OK. But when you
try and
> run a report or guery Microsoft just hangs. When you go to the
task manager
> it now says Microsoft not responding. I have gotten a few reports
to run
> but if you get out of Access and back in and rerun the same report
it will
> now hang. We have brought in new tables and saved password but same
> results. We use Access all day long to run everything from our
schedules to
> inventory etc. Any suggestions would be greatly appreciated. We
are using
> the SQLdriver 92. If we can't get this running we hopefully can go
back to
> 3.6 89 driver.
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@e...]
> Sent: Monday, April 15, 2002 6:19 PM
> To: vantage@y...
> Subject: Re: [Vantage] 4.00 to 5.00 ODBC problem
>
>
> Can you describe your errors more specifically? It may help us
pinpoint
> different problems.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: jyargeau2001
> To: vantage@y...
> Sent: Monday, April 15, 2002 1:47 PM
> Subject: [Vantage] 4.00 to 5.00 ODBC problem
>
>
> We converted this weekend from 4.00 to 5.00 348 and our using the
SQL
> ODBC driver with Access. We are having major problems getting
this
> to work. When we do a test connection it says the sql driver is
> connected but when we try to refresh the access tables to the new
> driver it gives us all kinds of errors. If anyone else is using
the
> SQL ODBC driver and have successfully converted to 5.00 could you
> please contact me off list. Thanks in advance.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.> >
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> < http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages> >
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
> < http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links> >
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <
>
http://rd.yahoo.com/M=217097.2003762.3481930.1261774/D=egroupweb/S=170
50071
>
<http://rd.yahoo.com/M=217097.2003762.3481930.1261774/D=egroupweb/S=17
050071
> >
> 83:HM/A=1042587/R=0/* http://service.bfast.com/bfast/click?
bfmid=29150849
> <http://service.bfast.com/bfast/click?bfmid=29150849&sit> &sit
> eid=39282504&bfpage=account>
>
> <
> http://us.adserver.yahoo.com/l?
M=217097.2003762.3481930.1261774/D=egroupmai
> <http://us.adserver.yahoo.com/l?
M=217097.2003762.3481930.1261774/D=egroupmai
> >
> l/S=1705007183:HM/A=1042587/rand=218706696>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.> >
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> < http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages> >
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
> < http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links> >
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> < http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/> > .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=178320.1964497.3448863.1261774/D=egroupweb/S=17
050071
> 83:HM/A=879171/R=0/*http://www.fastweb.com/ib/yahoo-57f>
>
> <http://us.adserver.yahoo.com/l?
M=178320.1964497.3448863.1261774/D=egroupmai
> l/S=1705007183:HM/A=879171/rand=215904548>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]