Good Day Todd:
Sun Is on:
M2K, 7.0 SP7, Informix ( not Unix) (Currently using).
Epicor 9, 9.05, SQL (live 7/1/2010)
If you are running SQL version, could you use a SQL view.
len.hartka@...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Crosta
Sent: Monday, January 04, 2010 5:50 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal 8.5 Links to Access Database -Password Issue
Todd,
Rather than using the ODBC link for the access database in crystal try
using the "Database Files" source.
Chris
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Todd Caughey
Sent: Monday, January 04, 2010 1:52 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Crystal 8.5 Links to Access Database
-Password Issue
The password being prompted for is not ODBC related. The Access database
does use ODBC to retrieve the Vantage fields but then runs a Query to
populate entirely "native" Access tables. When I then try to link to
those tables from Excel or another Access database it works fine but
from Crystal it asks for "Access Database password". I have not had a
chance to try it yet but was thinking of doing a cut/paste of the
populated table data into an entirely separate database consisting of
just those tables and no ODBC involvement at all. Not useful for
production but might reveal something of this situation.
BTW...once in production it will use a File DSN with the database ODBC
password built in. I am doing this already for a 3rd party application
that needs to read Vantage data and it works well. Nightly scheduled
task opens the Access DB which autoruns a macro to run queries populate
tables via ODBC. 3rd part app is also Access. Seems there's something
about Crystal that's different.
Thanks,
-Todd
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of B_Stinger
Sent: Monday, January 04, 2010 8:58 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal 8.5 Links to Access Database -Password
Issue
Todd,
Did you set up a System DSN for the Access DB and connecting to it with
ODBC or are you trying a different method?
Brian
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, Todd Caughey <caugheyt@...> wrote:
Basically I need to get the customer name onto the tags. Operation and
Work Center descriptions would also be nice.
giving me issues with security and access problems. Since this is
outside the Epicor box a bit but something I'm sure has been done anyone
else get around this somehow? I can hit the database with Excel and
straight via Access without any password prompting and have tried very
security tweak in Access that I can think of. We're supposed to be using
the tags next Monday and having the customer name instead of just ID
would be really nice.
[Non-text portions of this message have been removed]
Sun Is on:
M2K, 7.0 SP7, Informix ( not Unix) (Currently using).
Epicor 9, 9.05, SQL (live 7/1/2010)
If you are running SQL version, could you use a SQL view.
len.hartka@...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Crosta
Sent: Monday, January 04, 2010 5:50 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal 8.5 Links to Access Database -Password Issue
Todd,
Rather than using the ODBC link for the access database in crystal try
using the "Database Files" source.
Chris
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
Of Todd Caughey
Sent: Monday, January 04, 2010 1:52 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Crystal 8.5 Links to Access Database
-Password Issue
The password being prompted for is not ODBC related. The Access database
does use ODBC to retrieve the Vantage fields but then runs a Query to
populate entirely "native" Access tables. When I then try to link to
those tables from Excel or another Access database it works fine but
from Crystal it asks for "Access Database password". I have not had a
chance to try it yet but was thinking of doing a cut/paste of the
populated table data into an entirely separate database consisting of
just those tables and no ODBC involvement at all. Not useful for
production but might reveal something of this situation.
BTW...once in production it will use a File DSN with the database ODBC
password built in. I am doing this already for a 3rd party application
that needs to read Vantage data and it works well. Nightly scheduled
task opens the Access DB which autoruns a macro to run queries populate
tables via ODBC. 3rd part app is also Access. Seems there's something
about Crystal that's different.
Thanks,
-Todd
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of B_Stinger
Sent: Monday, January 04, 2010 8:58 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal 8.5 Links to Access Database -Password
Issue
Todd,
Did you set up a System DSN for the Access DB and connecting to it with
ODBC or are you trying a different method?
Brian
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, Todd Caughey <caugheyt@...> wrote:
>with CR 8.5) to an Access-2000 database into which I dump data nightly.
> I am trying to link the Part Tags (WIP Material tags) report (in 6.10
Basically I need to get the customer name onto the tags. Operation and
Work Center descriptions would also be nice.
>password (actually deliberately set and unset it too) and Crystal keeps
> The problem: It is prompting for a database password. I have set no
giving me issues with security and access problems. Since this is
outside the Epicor box a bit but something I'm sure has been done anyone
else get around this somehow? I can hit the database with Excel and
straight via Access without any password prompting and have tried very
security tweak in Access that I can think of. We're supposed to be using
the tags next Monday and having the customer name instead of just ID
would be really nice.
>This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]