Vantage 8.0 - Write Access Via ODBC

Yahoo Archive
1
I found this in a search. I thought it might help you out

http://www.progresstalk.com/showthread.php?t=94500


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karl Dash
Sent: Wednesday, November 21, 2007 9:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.0 - Write Access Via ODBC



Ari,
You reference the SQL Explorer tool which I have used in the past. But
with my recent migration to 8.80.403 the tool is no longer there. Epicor
says it is no longer available and they have no suggestion or plan to
make a replacement available. Has anyone else encountered this impasse
and found a good replacement tool?

-Karl

Ari Footlik <ari@... <mailto:ari%40zweig-cnc.com> > wrote:
I'm not 100% positive, but, I believe that with the ODBC connection set
to "Read Committed," as long as you select a field in your table to use
as an index (when linking the table), you should be able to make changes
to the data.

(I spent days bashing my head against a wall trying to figure this out,
especially because every once in a while I'd "accidentally" do it right,
get it to allow me to update data, and then not be able to do it again!)

That being said, I think that it's extremely dangerous to do something
like this. Previous admins had been using MSAccess to perform typo
corrections and such, but it always made me cringe to see the database
open in Access. A better practice might be to use the SQL Explorer Tool
and execute proper SQL selects and updates to change data.

--Ari
----------------------------------------------------------
Ari Footlik

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of davek2127
Sent: Wednesday, November 21, 2007 8:13 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.0 - Write Access Via ODBC

We are looking to condition some data in our currnet OpenEdge Database
for Vantage 8.00.11b.

Can this be done through an ODBC connection in MS Access. How is the
write permission established for the connection.

Thanks for any help,

Dave Kwiatkowski
davidk@... <mailto:davidk%40barber-nichols.com>
<mailto:davidk%40barber-nichols.com>
303-327-8637

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

---------------------------------
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See
how.

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






[Non-text portions of this message have been removed]
2
We are looking to condition some data in our currnet OpenEdge Database
for Vantage 8.00.11b.

Can this be done through an ODBC connection in MS Access. How is the
write permission established for the connection.

Thanks for any help,

Dave Kwiatkowski
davidk@...
303-327-8637
3
I'm not 100% positive, but, I believe that with the ODBC connection set
to "Read Committed," as long as you select a field in your table to use
as an index (when linking the table), you should be able to make changes
to the data.

(I spent days bashing my head against a wall trying to figure this out,
especially because every once in a while I'd "accidentally" do it right,
get it to allow me to update data, and then not be able to do it again!)

That being said, I think that it's extremely dangerous to do something
like this. Previous admins had been using MSAccess to perform typo
corrections and such, but it always made me cringe to see the database
open in Access. A better practice might be to use the SQL Explorer Tool
and execute proper SQL selects and updates to change data.

--Ari
------------------------------------------------------------------------
Ari Footlik



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of davek2127
Sent: Wednesday, November 21, 2007 8:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.0 - Write Access Via ODBC



We are looking to condition some data in our currnet OpenEdge Database
for Vantage 8.00.11b.

Can this be done through an ODBC connection in MS Access. How is the
write permission established for the connection.

Thanks for any help,

Dave Kwiatkowski
davidk@... <mailto:davidk%40barber-nichols.com>
303-327-8637






[Non-text portions of this message have been removed]
4
Ari,
You reference the SQL Explorer tool which I have used in the past. But with my recent migration to 8.80.403 the tool is no longer there. Epicor says it is no longer available and they have no suggestion or plan to make a replacement available. Has anyone else encountered this impasse and found a good replacement tool?

-Karl

Ari Footlik <ari@...> wrote:
I'm not 100% positive, but, I believe that with the ODBC connection set
to "Read Committed," as long as you select a field in your table to use
as an index (when linking the table), you should be able to make changes
to the data.

(I spent days bashing my head against a wall trying to figure this out,
especially because every once in a while I'd "accidentally" do it right,
get it to allow me to update data, and then not be able to do it again!)

That being said, I think that it's extremely dangerous to do something
like this. Previous admins had been using MSAccess to perform typo
corrections and such, but it always made me cringe to see the database
open in Access. A better practice might be to use the SQL Explorer Tool
and execute proper SQL selects and updates to change data.

--Ari
----------------------------------------------------------
Ari Footlik

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of davek2127
Sent: Wednesday, November 21, 2007 8:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.0 - Write Access Via ODBC

We are looking to condition some data in our currnet OpenEdge Database
for Vantage 8.00.11b.

Can this be done through an ODBC connection in MS Access. How is the
write permission established for the connection.

Thanks for any help,

Dave Kwiatkowski
davidk@... <mailto:davidk%40barber-nichols.com>
303-327-8637

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






---------------------------------
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.

[Non-text portions of this message have been removed]
5
Read commited will work as well as removing the entry all together. Keep
in mind that with the Read Committed option, Access locks the table so
you want to make sure that you aren't modifying the data during busy
times


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation
More than 100,000 Ion Beam Sputtered filters delivered - extensive
inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ari Footlik
Sent: Wednesday, November 21, 2007 9:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.0 - Write Access Via ODBC



I'm not 100% positive, but, I believe that with the ODBC connection set
to "Read Committed," as long as you select a field in your table to use
as an index (when linking the table), you should be able to make changes
to the data.

(I spent days bashing my head against a wall trying to figure this out,
especially because every once in a while I'd "accidentally" do it right,
get it to allow me to update data, and then not be able to do it again!)

That being said, I think that it's extremely dangerous to do something
like this. Previous admins had been using MSAccess to perform typo
corrections and such, but it always made me cringe to see the database
open in Access. A better practice might be to use the SQL Explorer Tool
and execute proper SQL selects and updates to change data.

--Ari
----------------------------------------------------------
Ari Footlik

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of davek2127
Sent: Wednesday, November 21, 2007 8:13 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.0 - Write Access Via ODBC

We are looking to condition some data in our currnet OpenEdge Database
for Vantage 8.00.11b.

Can this be done through an ODBC connection in MS Access. How is the
write permission established for the connection.

Thanks for any help,

Dave Kwiatkowski
davidk@... <mailto:davidk%40barber-nichols.com>
<mailto:davidk%40barber-nichols.com>
303-327-8637

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






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