We do not, and I will tell you why. First, I will say that I know my way around databases in general, and Access in particular. I read from the Vantage/Vista database (8.03.403) in Access and use it for reporting.
There are two reasons I do not load data into or delete data from Vantage/Vista using Access:
1. Epicor may refuse to support you if they find out you are loading data this way. Now, I know some people will question the value of Epicor support. Without opening that issue, let me just say that if your database takes a nosedive, you might consider that any support or help will be valuable. So, why cut off one avenue of help?
2. You must know all relationships that are involved when you add a piece of data. There are integrity checks built into Vantage/Vista that you can completely bypass if you manipulate the data using Access. If you fail to perform all the necessary integrity checks in your Access database, you could cause a serious crash of the Vantage/Vista database. I don't know about your situation, but for us, Vantage/Vista is a mission critical application. I am not going to mess with that.
Epicor does have a tool (Service Connect) for loading data from outside Vantage/Vista. That tool does perform the integrity checks. I recommend you investigate that option if you have a need for external data loading.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror.com
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of quest_erp
Sent: Thursday, January 22, 2009 6:54 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} [Vantage] Direct Access
Is anyone back loading Vantage via Microsoft Access?
I would love to hear some true stories.
We are on 8.03.305i using progress.
We have successfully back loaded in our test system and found no
problems.
Thanks in advance.
kmiller@...
There are two reasons I do not load data into or delete data from Vantage/Vista using Access:
1. Epicor may refuse to support you if they find out you are loading data this way. Now, I know some people will question the value of Epicor support. Without opening that issue, let me just say that if your database takes a nosedive, you might consider that any support or help will be valuable. So, why cut off one avenue of help?
2. You must know all relationships that are involved when you add a piece of data. There are integrity checks built into Vantage/Vista that you can completely bypass if you manipulate the data using Access. If you fail to perform all the necessary integrity checks in your Access database, you could cause a serious crash of the Vantage/Vista database. I don't know about your situation, but for us, Vantage/Vista is a mission critical application. I am not going to mess with that.
Epicor does have a tool (Service Connect) for loading data from outside Vantage/Vista. That tool does perform the integrity checks. I recommend you investigate that option if you have a need for external data loading.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
F 425 491-8200
AÂ 11831 Beverly Park Rd, Bldg D, Everett, WA 98204Â USA
www.electricmirror.com
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of quest_erp
Sent: Thursday, January 22, 2009 6:54 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} [Vantage] Direct Access
Is anyone back loading Vantage via Microsoft Access?
I would love to hear some true stories.
We are on 8.03.305i using progress.
We have successfully back loaded in our test system and found no
problems.
Thanks in advance.
kmiller@...