Playing with MS Access

system · May 30, 2006, 3:26pm

I may be jumping in on this thread a bit late Ben, but I have delt alot
with ODBC connections and data extraction for our employees. We
currently use several methods of exposing Vantage data. We run Crystal
reports overnight, which export massive amounts of data which are then
linked via Access MDBs to generate final XLS spreadsheet reports.

We also have a live ODBC (read-only) connection which links a website up
to Vantage and displays basic job information (work order data). Since
most basic Queries to the vantage database involving a single job are
almost instantaneous, this connection works out great for us. Also,
since a connection to a webpage exists only briefly, you tend not to bog
down the DB server.

If you would like to know more about either of these, please email me
off-list.

Andrew Reed
Crestview Aerospace Corporation

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 1:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

system · May 23, 2006, 2:21pm

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

system · May 23, 2006, 2:29pm

Ben,

> My question is, can I do this without the ability to change the data?
> The last thing I want to do is edit the database on accident.

You can set up a read-only ODBC user for this. What version of Vantage are you
running?

Mark W.

system · May 23, 2006, 2:36pm

Access is a great tool for getting the data and using forms really
simplifies things for the user so good job getting into it! Here's what
I would do to get started:

1) Start with making the ODBC driver Read Uncommitted. This makes the
system report an error if you try and modify the data.
2) Change the ODBC Fetch Array Size to 2000. This will elminate some
errors when accessing large records from Vantage.
3) Link to your Vantage tables and make sure you store the password.
Users don't want to be bothered with this.
4) Add another layer of read-only security by using Tools | Security |
User and Group Permissions to mark all the tables as Read Only. This
will prevent users from even trying to edit data in tables.
5) To add even another layer, when you create your form, set the
properties on the data tab of the form to not allow additions, edits,
and deletions.
6) Use the switchboard (under database uitilities) to create a menu for
the users so they can easily launch the forms you create.
7) Hide the database (Tools | Startup) so the users can only access the
forms you create.

Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 11:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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/.
(2) To search through old msg's goto:
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

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

system · May 23, 2006, 2:36pm

Whenever you set up an odbc connection to Vantage, you can choose in the
advance tab from READ COMMITED (you can make changes in the database) or
READ UNCOMITTED (read-only). By the way, this works on 9.1D and below.
No idea about 8.0.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, May 23, 2006 12:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access

Ben,

> My question is, can I do this without the ability to change the data?
> The last thing I want to do is edit the database on accident.

You can set up a read-only ODBC user for this. What version of Vantage
are you
running?

Mark W.

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/.
(2) To search through old msg's goto:
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

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

system · May 23, 2006, 2:45pm

>Hi All,
>Call me uneducated, but I need a little head start on using Access.
>My thought was to create a spreadsheet for my sales dept where they can

enter a field and see data based on that field.

Ben,
Do you have Progress provision? If so, you can write a script that will
prompt
For variables such as company, part number, and it will return onhand
quantities and open jobs.

Regards,

system · May 23, 2006, 3:04pm

You can setup your ODBC connection as "Read -Uncommitted". Because I
have some self proclaimed Access Experts, I went a step further and
created a user in progress called "Access" and granted 'select on' the
tables that I wanted them to have access to, this ensures that any
changes made to the ODBC client permissions will have no affect on the
DB user permissions.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

system · May 23, 2006, 3:38pm

We just went through this at our company.

You probably don't want to open up the keys to the kingdom (payroll &
accounting or other sensitive info) so you'll want to setup a new
Progress "user" and set permissions on specific tables. Then setup the
ODBC client for this "user". There is excellent documentation available
from Epicor on how to setup ODBC.

Once the ODBC is setup you can link to the Progress tables in Access.
Then setup query to run based on the spreadsheet value (although I
prefer using an Access Forms).

Something like this:

"SELECT fields FROM tables WHERE key_value = " & spreadsheet value & ";"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

system · May 23, 2006, 3:55pm

My experience is that you can set up a macro to link (ODBC-read only if
preferred), extract (query-create table), and report in whatever format
supported by Access (plenty). The macro has passwords, etc. and you can
"hide" the macro from the user. The only thing that the user has to do
is click on a button to run the macro - no passwords, etc. to do and the
user gets the results with live data and no mess. The only set up is
ODBC and Access 2000 or higher. You can email me directly if you do not
know how to set up a macro with 6.1 or lower.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Tuesday, May 23, 2006 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access

We just went through this at our company.

You probably don't want to open up the keys to the kingdom (payroll &
accounting or other sensitive info) so you'll want to setup a new
Progress "user" and set permissions on specific tables. Then setup the
ODBC client for this "user". There is excellent documentation available
from Epicor on how to setup ODBC.

Once the ODBC is setup you can link to the Progress tables in Access.
Then setup query to run based on the spreadsheet value (although I
prefer using an Access Forms).

Something like this:

"SELECT fields FROM tables WHERE key_value = " & spreadsheet value & ";"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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/.
(2) To search through old msg's goto:
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

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

system · May 26, 2006, 8:05am

I use MS Access to connect to the Vantage database using link tables. Every time I open the application it ask me to enter the password to access vantage. Is there a way so that I can set the password and it won't prompt for it again? I've tried using a File DSN but it does the same thing.

Any ideas?
Thanks,
Jasper

-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Tuesday, May 23, 2006 3:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

My experience is that you can set up a macro to link (ODBC-read only if
preferred), extract (query-create table), and report in whatever format
supported by Access (plenty). The macro has passwords, etc. and you can
"hide" the macro from the user. The only thing that the user has to do
is click on a button to run the macro - no passwords, etc. to do and the
user gets the results with live data and no mess. The only set up is
ODBC and Access 2000 or higher. You can email me directly if you do not
know how to set up a macro with 6.1 or lower.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Tuesday, May 23, 2006 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access

We just went through this at our company.

You probably don't want to open up the keys to the kingdom (payroll &
accounting or other sensitive info) so you'll want to setup a new
Progress "user" and set permissions on specific tables. Then setup the
ODBC client for this "user". There is excellent documentation available
from Epicor on how to setup ODBC.

Once the ODBC is setup you can link to the Progress tables in Access.
Then setup query to run based on the spreadsheet value (although I
prefer using an Access Forms).

Something like this:

"SELECT fields FROM tables WHERE key_value = " & spreadsheet value & ";"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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/.
(2) To search through old msg's goto:
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

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

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/.
(2) To search through old msg's goto: 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
Yahoo! Groups Links

system · May 26, 2006, 8:14am

Hi Jasper

When you link the ODBC table with the link manager you need to check the
save password box in the bottom right hand corner.

It will then connect with prompting for the password

Regards

Gary

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: 25 May 2006 22:12
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

I use MS Access to connect to the Vantage database using link tables.
Every time I open the application it ask me to enter the password to
access vantage. Is there a way so that I can set the password and it
won't prompt for it again? I've tried using a File DSN but it does the
same thing.

Any ideas?
Thanks,
Jasper

-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Tuesday, May 23, 2006 3:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

My experience is that you can set up a macro to link (ODBC-read only if
preferred), extract (query-create table), and report in whatever format
supported by Access (plenty). The macro has passwords, etc. and you can
"hide" the macro from the user. The only thing that the user has to do
is click on a button to run the macro - no passwords, etc. to do and the
user gets the results with live data and no mess. The only set up is
ODBC and Access 2000 or higher. You can email me directly if you do not
know how to set up a macro with 6.1 or lower.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Tuesday, May 23, 2006 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access

We just went through this at our company.

You probably don't want to open up the keys to the kingdom (payroll &
accounting or other sensitive info) so you'll want to setup a new
Progress "user" and set permissions on specific tables. Then setup the
ODBC client for this "user". There is excellent documentation available
from Epicor on how to setup ODBC.

Once the ODBC is setup you can link to the Progress tables in Access.
Then setup query to run based on the spreadsheet value (although I
prefer using an Access Forms).

Something like this:

"SELECT fields FROM tables WHERE key_value = " & spreadsheet value & ";"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

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

system · May 26, 2006, 8:26am

Wow,

I never saw that before.

THANKS!
Jasper

-----Original Message-----
From: Gary Parfrey [mailto:garyp@...]
Sent: Friday, May 26, 2006 8:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

Hi Jasper

When you link the ODBC table with the link manager you need to check the
save password box in the bottom right hand corner.

It will then connect with prompting for the password

Regards

Gary

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: 25 May 2006 22:12
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

I use MS Access to connect to the Vantage database using link tables.
Every time I open the application it ask me to enter the password to
access vantage. Is there a way so that I can set the password and it
won't prompt for it again? I've tried using a File DSN but it does the
same thing.

Any ideas?
Thanks,
Jasper

-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Tuesday, May 23, 2006 3:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

My experience is that you can set up a macro to link (ODBC-read only if
preferred), extract (query-create table), and report in whatever format
supported by Access (plenty). The macro has passwords, etc. and you can
"hide" the macro from the user. The only thing that the user has to do
is click on a button to run the macro - no passwords, etc. to do and the
user gets the results with live data and no mess. The only set up is
ODBC and Access 2000 or higher. You can email me directly if you do not
know how to set up a macro with 6.1 or lower.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Tuesday, May 23, 2006 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access

We just went through this at our company.

You probably don't want to open up the keys to the kingdom (payroll &
accounting or other sensitive info) so you'll want to setup a new
Progress "user" and set permissions on specific tables. Then setup the
ODBC client for this "user". There is excellent documentation available
from Epicor on how to setup ODBC.

Once the ODBC is setup you can link to the Progress tables in Access.
Then setup query to run based on the spreadsheet value (although I
prefer using an Access Forms).

Something like this:

"SELECT fields FROM tables WHERE key_value = " & spreadsheet value & ";"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

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

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/.
(2) To search through old msg's goto: 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
Yahoo! Groups Links

system · May 26, 2006, 8:56am

Is it the ODBC connection that is prompting you? If so, when you link
your tables, you just have to check off the 'save password' box and it
won't prompt you for the password anymore.

-Sarah

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Thursday, May 25, 2006 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

I use MS Access to connect to the Vantage database using link tables.
Every time I open the application it ask me to enter the password to
access vantage. Is there a way so that I can set the password and it
won't prompt for it again? I've tried using a File DSN but it does the
same thing.

Any ideas?
Thanks,
Jasper

system · May 26, 2006, 12:06pm

Hi All,
It appears that a lot of people are using MS Access to link to Vantage
tables.
I am assuming this is for reporting.
Is there an issue of database size and speed with MS Access?
Can you link to Vantage from the MS Access MSDE data engine?
Are there any other options for linking to Vantage for reporting?
Thanks,
Robert MacDonald
Information Technology Manager
Ground Effects Ltd.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, May 26, 2006 8:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

Wow,

I never saw that before.

THANKS!
Jasper

-----Original Message-----
From: Gary Parfrey [mailto:garyp@...]
Sent: Friday, May 26, 2006 8:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

Hi Jasper

When you link the ODBC table with the link manager you need to check the
save password box in the bottom right hand corner.

It will then connect with prompting for the password

Regards

Gary

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: 25 May 2006 22:12
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

I use MS Access to connect to the Vantage database using link tables.
Every time I open the application it ask me to enter the password to
access vantage. Is there a way so that I can set the password and it
won't prompt for it again? I've tried using a File DSN but it does the
same thing.

Any ideas?
Thanks,
Jasper

-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Tuesday, May 23, 2006 3:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access and Macros

My experience is that you can set up a macro to link (ODBC-read only if
preferred), extract (query-create table), and report in whatever format
supported by Access (plenty). The macro has passwords, etc. and you can
"hide" the macro from the user. The only thing that the user has to do
is click on a button to run the macro - no passwords, etc. to do and the
user gets the results with live data and no mess. The only set up is
ODBC and Access 2000 or higher. You can email me directly if you do not
know how to set up a macro with 6.1 or lower.

Mario Aguirre - IT Manager
Lakin General Corp., Inc.
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Clunn
Sent: Tuesday, May 23, 2006 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Playing with MS Access

We just went through this at our company.

You probably don't want to open up the keys to the kingdom (payroll &
accounting or other sensitive info) so you'll want to setup a new
Progress "user" and set permissions on specific tables. Then setup the
ODBC client for this "user". There is excellent documentation available
from Epicor on how to setup ODBC.

Once the ODBC is setup you can link to the Progress tables in Access.
Then setup query to run based on the spreadsheet value (although I
prefer using an Access Forms).

Something like this:

"SELECT fields FROM tables WHERE key_value = " & spreadsheet value & ";"

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, May 23, 2006 2:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Playing with MS Access

Hi All,

Call me uneducated, but I need a little head start on using Access.

My thought was to create a spreadsheet for my sales dept where they can
enter a field and see data based on that field.

IE They can enter a part number and see how much we have in stock, and
what is on order... or something to that effect.

My question is, can I do this without the ability to change the data?
The last thing I want to do is edit the database on accident.

If so, can someone give me a little boost as to how I would set this up?
IE connecting to the database, making sure I am in read-only etc. I
just need the basics, and I can take it all from there.

Thanks in advance!

Ben Belzer
Inside Sales Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

This e-mail is for the use of the intended recipient(s) only. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not use, disclose
or distribute this e-mail without the author's prior permission. We have
taken precautions to minimize the risk of transmitting software viruses, but
we advise you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.

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

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/.
(2) To search through old msg's goto:
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
Yahoo! Groups Links

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/.
(2) To search through old msg's goto:
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
Yahoo! Groups Links

system · May 26, 2006, 12:14pm

Hi,

In terms of other reporting packages, there is corvu. It is a great
reporting tool at a minimum. Epicor have bundled a suite of canned
reports etc. Has direct access to the progress database rather than
going through ODBC. Great for management and extracting data out of
vantage. I am afraid I don't know the costs.

--- In vantage@yahoogroups.com, "Robert MacDonald" <rmacdonald@...>
wrote:

>
> Hi All,
> It appears that a lot of people are using MS Access to link to

Vantage

> tables.
> I am assuming this is for reporting.
> Is there an issue of database size and speed with MS Access?
> Can you link to Vantage from the MS Access MSDE data engine?
> Are there any other options for linking to Vantage for reporting?
> Thanks,
> Robert MacDonald
> Information Technology Manager
> Ground Effects Ltd.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> Jasper Recto
> Sent: Friday, May 26, 2006 8:25 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Playing with MS Access and Macros
>
> Wow,
>
> I never saw that before.
>
> THANKS!
> Jasper
>
> -----Original Message-----
> From: Gary Parfrey [mailto:garyp@...]
> Sent: Friday, May 26, 2006 8:14 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Playing with MS Access and Macros
>
>
> Hi Jasper
>
>
>
> When you link the ODBC table with the link manager you need to

check the

> save password box in the bottom right hand corner.
>
>
>
> It will then connect with prompting for the password
>
>
>
> Regards
>
>
>
> Gary
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of Jasper Recto
> Sent: 25 May 2006 22:12
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Playing with MS Access and Macros
>
>
>
> I use MS Access to connect to the Vantage database using link

tables.

> Every time I open the application it ask me to enter the password

to

> access vantage. Is there a way so that I can set the password and

it

> won't prompt for it again? I've tried using a File DSN but it

does the

> same thing.
>
> Any ideas?
> Thanks,
> Jasper
>
> -----Original Message-----
> From: Mario Aguirre [mailto:maguirre@...]
> Sent: Tuesday, May 23, 2006 3:55 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Playing with MS Access and Macros
>
>
> My experience is that you can set up a macro to link (ODBC-read

only if

> preferred), extract (query-create table), and report in whatever

format

> supported by Access (plenty). The macro has passwords, etc. and

you can

> "hide" the macro from the user. The only thing that the user has

to do

> is click on a button to run the macro - no passwords, etc. to do

and the

> user gets the results with live data and no mess. The only set up

is

> ODBC and Access 2000 or higher. You can email me directly if you

do not

> know how to set up a macro with 6.1 or lower.
>
> Mario Aguirre - IT Manager
> Lakin General Corp., Inc.
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of Chris Clunn
> Sent: Tuesday, May 23, 2006 1:36 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Playing with MS Access
>
>
> We just went through this at our company.
>
>
>
> You probably don't want to open up the keys to the kingdom

(payroll &

> accounting or other sensitive info) so you'll want to setup a new
> Progress "user" and set permissions on specific tables. Then

setup the

> ODBC client for this "user". There is excellent documentation

available

> from Epicor on how to setup ODBC.
>
>
>
> Once the ODBC is setup you can link to the Progress tables in

Access.

> Then setup query to run based on the spreadsheet value (although I
> prefer using an Access Forms).
>
>
>
> Something like this:
>
>
>
> "SELECT fields FROM tables WHERE key_value = " & spreadsheet value

& ";"

>
>
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf

> Of Ben Belzer
> Sent: Tuesday, May 23, 2006 2:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Playing with MS Access
>
>
>
> Hi All,
>
>
>
> Call me uneducated, but I need a little head start on using Access.
>
>
>
> My thought was to create a spreadsheet for my sales dept where

they can

> enter a field and see data based on that field.
>
>
>
> IE They can enter a part number and see how much we have in stock,

and

> what is on order... or something to that effect.
>
>
>
> My question is, can I do this without the ability to change the

data?

> The last thing I want to do is edit the database on accident.
>
>
>
> If so, can someone give me a little boost as to how I would set

this up?

> IE connecting to the database, making sure I am in read-only

etc. I

> just need the basics, and I can take it all from there.
>
>
>
>
>
> Thanks in advance!
>
>
>
> Ben Belzer
> Inside Sales Manager
>
> TCI Precision Metals
> 800.234.5613.W
> 310.323.1255.F
> bbelzer@... <mailto:bbelzer@...>
> www.tciprecision.com <http://www.tciprecision.com/>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
> Manufacturing software
> <http://groups.yahoo.com/gads?

t=ms&k=Manufacturing+software&w1=Manufactu

>

ring+software&w2=Membership+database+software&w3=Database+mortgage+so
ftw

>

are&w4=Pda+database+software&w5=Database+management+software&w6=Datab
ase

> +marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
> Membership database software
> <http://groups.yahoo.com/gads?

t=ms&k=Membership+database+software&w1=Man

>

ufacturing+software&w2=Membership+database+software&w3=Database+mortg
age

>

+software&w4=Pda+database+software&w5=Database+management+software&w6
=Da

> tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
> Database mortgage software
> <http://groups.yahoo.com/gads?

t=ms&k=Database+mortgage+software&w1=Manuf

>

acturing+software&w2=Membership+database+software&w3=Database+mortgag
e+s

>

oftware&w4=Pda+database+software&w5=Database+management+software&w6=D
ata

> base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-

0Si39A>

> Pda database software
> <http://groups.yahoo.com/gads?

t=ms&k=Pda+database+software&w1=Manufactur

>

ing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twa

>

re&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se+

> marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
> Database
> management software
> <http://groups.yahoo.com/gads?

t=ms&k=Database+management+software&w1=Man

>

ufacturing+software&w2=Membership+database+software&w3=Database+mortg
age

>

+software&w4=Pda+database+software&w5=Database+management+software&w6
=Da

> tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
> Database marketing software
> <http://groups.yahoo.com/gads?

t=ms&k=Database+marketing+software&w1=Manu

>

facturing+software&w2=Membership+database+software&w3=Database+mortga
ge+

>

software&w4=Pda+database+software&w5=Database+management+software&w6=
Dat

>

abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
> ________________________________
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> 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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> 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
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> SPONSORED LINKS
>
> Manufacturing software
> <http://groups.yahoo.com/gads?

t=ms&k=Manufacturing+software&w1=Manufactu

>

ring+software&w2=Membership+database+software&w3=Database+mortgage+so
ftw

>

are&w4=Pda+database+software&w5=Database+management+software&w6=Datab
ase

> +marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
>
> Membership database software
> <http://groups.yahoo.com/gads?

t=ms&k=Membership+database+software&w1=Man

>

ufacturing+software&w2=Membership+database+software&w3=Database+mortg
age

>

+software&w4=Pda+database+software&w5=Database+management+software&w6
=Da

> tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
>
> Database mortgage software
> <http://groups.yahoo.com/gads?

t=ms&k=Database+mortgage+software&w1=Manuf

>

acturing+software&w2=Membership+database+software&w3=Database+mortgag
e+s

>

oftware&w4=Pda+database+software&w5=Database+management+software&w6=D
ata

> base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
>
> Pda database software
> <http://groups.yahoo.com/gads?

t=ms&k=Pda+database+software&w1=Manufactur

>

ing+software&w2=Membership+database+software&w3=Database+mortgage+sof
twa

>

re&w4=Pda+database+software&w5=Database+management+software&w6=Databa
se+

> marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
>
> Database management software
> <http://groups.yahoo.com/gads?

t=ms&k=Database+management+software&w1=Man

>

ufacturing+software&w2=Membership+database+software&w3=Database+mortg
age

>

+software&w4=Pda+database+software&w5=Database+management+software&w6
=Da

> tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
>
> Database marketing software
> <http://groups.yahoo.com/gads?

t=ms&k=Database+marketing+software&w1=Manu

>

facturing+software&w2=Membership+database+software&w3=Database+mortga
ge+

>

software&w4=Pda+database+software&w5=Database+management+software&w6=
Dat

> abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
>
>
>
> ________________________________
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "vantage
> <http://groups.yahoo.com/group/vantage> " on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> ________________________________
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If

you have

> received this e-mail in error, please notify the sender

immediately and then

> delete it. If you are not the intended recipient, you must not

use, disclose

> or distribute this e-mail without the author's prior permission.

We have

> taken precautions to minimize the risk of transmitting software

viruses, but

> we advise you to carry out your own virus checks on any attachment

to this

> message. We cannot accept liability for any loss or damage caused

by

> software viruses.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> 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/.
> (2) To search through old msg's goto:
> 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
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> 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/.
> (2) To search through old msg's goto:
> 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
> Yahoo! Groups Links
>