ODBC Connection to ACCESS from Epicor 9.05602A

Yahoo Archive
1
Hi,

I too was struggling with the #deleted return from tables I really needed to access (no pun). An alternative method is to create a new project in Access. This immediately launches a wizard askiing if you need to connect to an existing SQL database. Add the details & you have a database with all the Vantage tables added. You are able to create queries (now called views) in much the same way (but not 100%) and retain the Access ease of integration with other Office products.



--- In vantage@yahoogroups.com, "rocket7247" <joan.d.sweeny@...> wrote:
>
> I have created a ODBC DSN to connect to the live database via. MS ACCESS with version Epicor9.05602A. When I open a table, I get a table of all "#deleted" columns. Has anyone had success in connecting tables ODBC using this version of Epicor 9?
>
> Thank you for your assistance.
>
2
I have created a ODBC DSN to connect to the live database via. MS ACCESS with version Epicor9.05602A. When I open a table, I get a table of all "#deleted" columns. Has anyone had success in connecting tables ODBC using this version of Epicor 9?

Thank you for your assistance.
3
Hi Joan,

When you link the tables and it prompts for a unique key make sure you
choose a group of fields that provides that.

Mark W.
On Jan 20, 2011 1:10 PM, "rocket7247" <joan.d.sweeny@...> wrote:
> I have created a ODBC DSN to connect to the live database via. MS ACCESS
with version Epicor9.05602A. When I open a table, I get a table of all
"#deleted" columns. Has anyone had success in connecting tables ODBC using
this version of Epicor 9?
>
> Thank you for your assistance.
>


[Non-text portions of this message have been removed]
4
I have done this before but let me emphasize that is a really really bad
idea if you don't do it right. Make sure that on your ODBC settings you set
it to no-lock read only or it will lock up your epicor.

What specifically are you trying to accomplish? There may be easier / safer
ways to do it


*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Thu, Jan 20, 2011 at 1:42 PM, Mark Wonsil <mark_wonsil@...> wrote:

>
>
> Hi Joan,
>
> When you link the tables and it prompts for a unique key make sure you
> choose a group of fields that provides that.
>
> Mark W.
>
> On Jan 20, 2011 1:10 PM, "rocket7247" <joan.d.sweeny@...<joan.d.sweeny%40nasa.gov>>
> wrote:
> > I have created a ODBC DSN to connect to the live database via. MS ACCESS
> with version Epicor9.05602A. When I open a table, I get a table of all
> "#deleted" columns. Has anyone had success in connecting tables ODBC using
> this version of Epicor 9?
> >
> > Thank you for your assistance.
> >
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
5
BTW, I COMPLETELY agree with Jose. I would not recommend updating your
Vantage /Epicor database via Access.

Mark W.


[Non-text portions of this message have been removed]
6
I recently set up ODBC access to 9.05 MS SQL database, by:
- creating a ODBC access username, with by default, no access to
anything
- creating a view for each table our couple of expert users wanted:
select * from ... WITH (NOLOCK)
- granting that ODBC access username select access (only) to each view

That way the server enforces the read only no-lock, and I don't have to
worry about getting the setup on each PC correct.

Brian.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Thursday, January 20, 2011 1:47 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC Connection to ACCESS from Epicor 9.05602A

I have done this before but let me emphasize that is a really really bad
idea if you don't do it right. Make sure that on your ODBC settings you
set
it to no-lock read only or it will lock up your epicor.

What specifically are you trying to accomplish? There may be easier /
safer
ways to do it


*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Thu, Jan 20, 2011 at 1:42 PM, Mark Wonsil <mark_wonsil@...>
wrote:

>
>
> Hi Joan,
>
> When you link the tables and it prompts for a unique key make sure you
> choose a group of fields that provides that.
>
> Mark W.
>
> On Jan 20, 2011 1:10 PM, "rocket7247"
<joan.d.sweeny@...<joan.d.sweeny%40nasa.gov>>
> wrote:
> > I have created a ODBC DSN to connect to the live database via. MS
ACCESS
> with version Epicor9.05602A. When I open a table, I get a table of all
> "#deleted" columns. Has anyone had success in connecting tables ODBC
using
> this version of Epicor 9?
> >
> > Thank you for your assistance.
> >
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]



------------------------------------