Thanks, the macro does work...it's a good start.
--- In vantage@yahoogroups.com, Mario Aguirre <maguirre@l...> wrote:
> How about a macro? You need to have ODBC in working condition in
both the
> client and the server sides. Also, in the client odbc connection,
make sure
> you you're your advance settings to uncommitted so you only read
records not
> locked.
>
> Here is the macro:
>
> Action
> Set warnings - No to avoid warning messages
> DeleteObject - Delete table LAKINOpnBal - refresh the whole table
with the
> following.
> Transfer Database - This option has the following settings:
> Transfer Type: Link (takes less time to connect - More time to run
reports
> against. Import is my favorite option).
> Database Type: ODBC Database
> Database Name: ODBC;DSN=epic51;HOST={Server
> Name};PORT=3550;DB=vantage;DATABASE=;UID=sysprogress;PWD=sysprogress
> Object Type: Table
> Source: PUB.GLOpnBal
> Destination: LAKINOpnBal
> Structure Only: No
> Set warnings - Yes to make sure warnings are turn on again.
>
> This macro establish a connection with Vantage (epic51 - port 3550 -
server
> name), gets table GLOpnBal and creates table LAKINOpnBal. You can
include in
> your VB code to run this macro to get the tables you need. Let me
know if
> you need more info.
>
> Mario Aguirre
> Lakin General
>
> -----Original Message-----
> From: joeyloken [mailto:joeyloken@y...]
> Sent: Monday, July 07, 2003 10:43 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Getting Vantage Data with MS Access
>
> PLEASE! Does anyone have any code or sample app built in MS Access
to
> retrieve data from Vantage?? I could use some advice on how to
> access Vantage using VBA code. Thanks!!!
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=244522.3512152.4794593.1261774/D=egroupweb/S=17
050071
>
83:HM/A=1595055/R=0/SIG=1247d4o3g/*http:/ashnin.com/clk/muryutaitakena
ttogyo
> ?YH=3512152&yhad=1595055> Click Here!
>
>
> <http://us.adserver.yahoo.com/l?
M=244522.3512152.4794593.1261774/D=egroupmai
> l/S=:HM/A=1595055/rand=144097606>
>
> 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!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
> [Non-text portions of this message have been removed]