MS Access and Merant 3.6 ODBC driver issues

Yahoo Archive
1
Sorry. I use Access workgroups and the authorization error is what my
users report to me when they do not have access to the workgroup or
object. I'm assuming you are hitting the checkbox to save the password
otherwise Access would be prompting you for it from the ODBC driver. Is
it happening on just one machine or if it is happening on everyone's
computer? What version of Access are you using? Can you connect to the
database with another ODBC app to try an isolate if the problem is with
the ODBC driver, server or application?



Butch



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ecfmis
Sent: Tuesday, October 04, 2005 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues



I guess I am not being clear. The authorization fails with the
progress database, not the access one. Basically I can create an
access database, link the tables, and open them just fine. But once
I close the access database and come back in, the linked tables no
longer work. I then get the authorization error when trying to open
the linked tables. If I create a brand new access DB and link the
tables again it works. But only as long as I have it opened. Then
it breaks after I close it and come back in.

--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> The assumption is that your Access database is linked to the
Progress
> database so the data is always live. Access contains tables,
queries,
> forms, reports, etc. and that is what you are importing to a new
file.
> I don't believe you can import report builder reports. By
creating a
> new file, you are changing the owner of the objects - that is all -
> which may fix your authorization issue.
>
>
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of ecfmis
> Sent: Tuesday, October 04, 2005 7:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues
>
>
>
> Thanks for responding, but wont this create a 2nd copy of the data
> so it will no longer be 'live' data that I am querying from? And
> how do you import reports from the report builder?
>
> thanks
> ecfmis
>
> --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> > Create a new Access database and link the tables to vantage.
> Import in
> > all the other objects from the database you are having trouble
with
> > (queries, forms, reports, modules). When imported you will be
the
> owner
> > of the objects.
> >
> >
> >
> > Butch
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf
> > Of ecfmis
> > Sent: Wednesday, September 28, 2005 6:03 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
> >
> >
> >
> > I am trying to copy a report from the report writer into
Access.
> So I
> > link the tables in Access using the ODBC drivers. I use the
login
> of
> > the person who created the database. It will let me link the
> tables.
> > But as soon as I close the Access database and re-open them, it
no
> > longer works with the authorization failed message. Do I need
to
> > create a new user for the DB and transfer dba rights? Or will
> this
> > mess vantage up? I also tried to link a server in SQL but had
> > absolutely no luck with authorization failing everytime I tried.
> >
> >
> >
> >
> >
> > 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/>
> <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
> >
> >
> >
> > * 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/>
> <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
>
>
>
> * 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



* 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]
2
I am trying to copy a report from the report writer into Access. So I
link the tables in Access using the ODBC drivers. I use the login of
the person who created the database. It will let me link the tables.
But as soon as I close the Access database and re-open them, it no
longer works with the authorization failed message. Do I need to
create a new user for the DB and transfer dba rights? Or will this
mess vantage up? I also tried to link a server in SQL but had
absolutely no luck with authorization failing everytime I tried.
3
On the dialog where you are picking the Vantage tables you want to link
there is a check box on the lower right corner labeled "Save
Password". Try clicking that box, that might solve your problem.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "ecfmis" <tlillis@e...> wrote:
> I am trying to copy a report from the report writer into Access. So
I
> link the tables in Access using the ODBC drivers. I use the login of
> the person who created the database. It will let me link the
tables.
> But as soon as I close the Access database and re-open them, it no
> longer works with the authorization failed message. Do I need to
> create a new user for the DB and transfer dba rights? Or will this
> mess vantage up? I also tried to link a server in SQL but had
> absolutely no luck with authorization failing everytime I tried.
4
Create a new Access database and link the tables to vantage. Import in
all the other objects from the database you are having trouble with
(queries, forms, reports, modules). When imported you will be the owner
of the objects.



Butch



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ecfmis
Sent: Wednesday, September 28, 2005 6:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues



I am trying to copy a report from the report writer into Access. So I
link the tables in Access using the ODBC drivers. I use the login of
the person who created the database. It will let me link the tables.
But as soon as I close the Access database and re-open them, it no
longer works with the authorization failed message. Do I need to
create a new user for the DB and transfer dba rights? Or will this
mess vantage up? I also tried to link a server in SQL but had
absolutely no luck with authorization failing everytime I tried.





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



* 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]
5
Thanks for responding, but wont this create a 2nd copy of the data
so it will no longer be 'live' data that I am querying from? And
how do you import reports from the report builder?

thanks
ecfmis

--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> Create a new Access database and link the tables to vantage.
Import in
> all the other objects from the database you are having trouble with
> (queries, forms, reports, modules). When imported you will be the
owner
> of the objects.
>
>
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of ecfmis
> Sent: Wednesday, September 28, 2005 6:03 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
>
>
>
> I am trying to copy a report from the report writer into Access.
So I
> link the tables in Access using the ODBC drivers. I use the login
of
> the person who created the database. It will let me link the
tables.
> But as soon as I close the Access database and re-open them, it no
> longer works with the authorization failed message. Do I need to
> create a new user for the DB and transfer dba rights? Or will
this
> mess vantage up? I also tried to link a server in SQL but had
> absolutely no luck with authorization failing everytime I tried.
>
>
>
>
>
> 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
>
>
>
> * 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]
6
The assumption is that your Access database is linked to the Progress
database so the data is always live. Access contains tables, queries,
forms, reports, etc. and that is what you are importing to a new file.
I don't believe you can import report builder reports. By creating a
new file, you are changing the owner of the objects - that is all -
which may fix your authorization issue.



Butch



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ecfmis
Sent: Tuesday, October 04, 2005 7:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues



Thanks for responding, but wont this create a 2nd copy of the data
so it will no longer be 'live' data that I am querying from? And
how do you import reports from the report builder?

thanks
ecfmis

--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> Create a new Access database and link the tables to vantage.
Import in
> all the other objects from the database you are having trouble with
> (queries, forms, reports, modules). When imported you will be the
owner
> of the objects.
>
>
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of ecfmis
> Sent: Wednesday, September 28, 2005 6:03 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
>
>
>
> I am trying to copy a report from the report writer into Access.
So I
> link the tables in Access using the ODBC drivers. I use the login
of
> the person who created the database. It will let me link the
tables.
> But as soon as I close the Access database and re-open them, it no
> longer works with the authorization failed message. Do I need to
> create a new user for the DB and transfer dba rights? Or will
this
> mess vantage up? I also tried to link a server in SQL but had
> absolutely no luck with authorization failing everytime I tried.
>
>
>
>
>
> 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/>
> <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
>
>
>
> * 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



* 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]
7
Hi,

Be aware if moving forward with 8.0 that a few of the tables in 8.0 have
more indexes out of the box than Access can handle (I think the limit is
30), so you may need to modify database to do this.

Geordie Dukas
CONCOA

Butch Menge wrote:
> The assumption is that your Access database is linked to the Progress
> database so the data is always live. Access contains tables, queries,
> forms, reports, etc. and that is what you are importing to a new file.
> I don't believe you can import report builder reports. By creating a
> new file, you are changing the owner of the objects - that is all -
> which may fix your authorization issue.
>
>
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of ecfmis
> Sent: Tuesday, October 04, 2005 7:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues
>
>
>
> Thanks for responding, but wont this create a 2nd copy of the data
> so it will no longer be 'live' data that I am querying from? And
> how do you import reports from the report builder?
>
> thanks
> ecfmis
>
> --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
>
>>Create a new Access database and link the tables to vantage.
>
> Import in
>
>>all the other objects from the database you are having trouble with
>>(queries, forms, reports, modules). When imported you will be the
>
> owner
>
>>of the objects.
>>
>>
>>
>>Butch
>>
>>
>>
>>________________________________
>>
>>From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
>
> Behalf
>
>>Of ecfmis
>>Sent: Wednesday, September 28, 2005 6:03 AM
>>To: vantage@yahoogroups.com
>>Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
>>
>>
>>
>>I am trying to copy a report from the report writer into Access.
>
> So I
>
>>link the tables in Access using the ODBC drivers. I use the login
>
> of
>
>>the person who created the database. It will let me link the
>
> tables.
>
>>But as soon as I close the Access database and re-open them, it no
>>longer works with the authorization failed message. Do I need to
>>create a new user for the DB and transfer dba rights? Or will
>
> this
>
>>mess vantage up? I also tried to link a server in SQL but had
>>absolutely no luck with authorization failing everytime I tried.
>>
>>
>>
>>
>>
>>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/>
>
>><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
>>
>>
>>
>>* 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
>
>
>
> * 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
>
>
>
>
>
>
>
8
I guess I am not being clear. The authorization fails with the
progress database, not the access one. Basically I can create an
access database, link the tables, and open them just fine. But once
I close the access database and come back in, the linked tables no
longer work. I then get the authorization error when trying to open
the linked tables. If I create a brand new access DB and link the
tables again it works. But only as long as I have it opened. Then
it breaks after I close it and come back in.

--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> The assumption is that your Access database is linked to the
Progress
> database so the data is always live. Access contains tables,
queries,
> forms, reports, etc. and that is what you are importing to a new
file.
> I don't believe you can import report builder reports. By
creating a
> new file, you are changing the owner of the objects - that is all -
> which may fix your authorization issue.
>
>
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of ecfmis
> Sent: Tuesday, October 04, 2005 7:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues
>
>
>
> Thanks for responding, but wont this create a 2nd copy of the data
> so it will no longer be 'live' data that I am querying from? And
> how do you import reports from the report builder?
>
> thanks
> ecfmis
>
> --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> > Create a new Access database and link the tables to vantage.
> Import in
> > all the other objects from the database you are having trouble
with
> > (queries, forms, reports, modules). When imported you will be
the
> owner
> > of the objects.
> >
> >
> >
> > Butch
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf
> > Of ecfmis
> > Sent: Wednesday, September 28, 2005 6:03 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
> >
> >
> >
> > I am trying to copy a report from the report writer into
Access.
> So I
> > link the tables in Access using the ODBC drivers. I use the
login
> of
> > the person who created the database. It will let me link the
> tables.
> > But as soon as I close the Access database and re-open them, it
no
> > longer works with the authorization failed message. Do I need
to
> > create a new user for the DB and transfer dba rights? Or will
> this
> > mess vantage up? I also tried to link a server in SQL but had
> > absolutely no luck with authorization failing everytime I tried.
> >
> >
> >
> >
> >
> > 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/>
> > <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
> >
> >
> >
> > * 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
>
>
>
> * 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]
9
Hello,



Is anyone currently working with or testing RFID to work with Vantage? We are currently looking at ways we can better manage large, organic, dimensional inventory that resides outdoors.



Thanks,

Paul Krotts

J.H. Baxter & Company



[Non-text portions of this message have been removed]
10
Did you try checking the "Save Password" box when selecting the
tables you are linking like I mentioned after your initial question?

Its been a long time, but I swear I had the same issue when I first
got started with the new ODBC setup and I believe checking that box
took care of it. If not let me know and I'll start digging through
the dust bunnies in my memory.

Brian Stenglein
Clow Stamping

--- In vantage@yahoogroups.com, "ecfmis" <tlillis@e...> wrote:
> I guess I am not being clear. The authorization fails with the
> progress database, not the access one. Basically I can create an
> access database, link the tables, and open them just fine. But
once
> I close the access database and come back in, the linked tables no
> longer work. I then get the authorization error when trying to
open
> the linked tables. If I create a brand new access DB and link the
> tables again it works. But only as long as I have it opened. Then
> it breaks after I close it and come back in.
>
> --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> > The assumption is that your Access database is linked to the
> Progress
> > database so the data is always live. Access contains tables,
> queries,
> > forms, reports, etc. and that is what you are importing to a new
> file.
> > I don't believe you can import report builder reports. By
> creating a
> > new file, you are changing the owner of the objects - that is
all -
> > which may fix your authorization issue.
> >
> >
> >
> > Butch
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of ecfmis
> > Sent: Tuesday, October 04, 2005 7:48 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues
> >
> >
> >
> > Thanks for responding, but wont this create a 2nd copy of the
data
> > so it will no longer be 'live' data that I am querying from? And
> > how do you import reports from the report builder?
> >
> > thanks
> > ecfmis
> >
> > --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> > > Create a new Access database and link the tables to vantage.
> > Import in
> > > all the other objects from the database you are having trouble
> with
> > > (queries, forms, reports, modules). When imported you will be
> the
> > owner
> > > of the objects.
> > >
> > >
> > >
> > > Butch
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> On
> > Behalf
> > > Of ecfmis
> > > Sent: Wednesday, September 28, 2005 6:03 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
> > >
> > >
> > >
> > > I am trying to copy a report from the report writer into
> Access.
> > So I
> > > link the tables in Access using the ODBC drivers. I use the
> login
> > of
> > > the person who created the database. It will let me link the
> > tables.
> > > But as soon as I close the Access database and re-open them, it
> no
> > > longer works with the authorization failed message. Do I need
> to
> > > create a new user for the DB and transfer dba rights? Or will
> > this
> > > mess vantage up? I also tried to link a server in SQL but had
> > > absolutely no luck with authorization failing everytime I
tried.
> > >
> > >
> > >
> > >
> > >
> > > 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/>
> > > <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
> > >
> > >
> > >
> > > * 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
> >
> >
> >
> > * 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]
11
I made a macro that links to Vantage Tables, create the tables needed
for reporting (you will know that not all fields are needed) and delete
the link tables again so no odbc connection is hanging all with 1 button
in a form. No user interference either since they only click on 1 button
to do it all. If you need help on this, email me directly and I will
help you.

Mario Aguirre
Lakin General Corporation, Inc.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Stenglein
Sent: Tuesday, October 04, 2005 12:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues


Did you try checking the "Save Password" box when selecting the
tables you are linking like I mentioned after your initial question?

Its been a long time, but I swear I had the same issue when I first
got started with the new ODBC setup and I believe checking that box
took care of it. If not let me know and I'll start digging through
the dust bunnies in my memory.

Brian Stenglein
Clow Stamping

--- In vantage@yahoogroups.com, "ecfmis" <tlillis@e...> wrote:
> I guess I am not being clear. The authorization fails with the
> progress database, not the access one. Basically I can create an
> access database, link the tables, and open them just fine. But
once
> I close the access database and come back in, the linked tables no
> longer work. I then get the authorization error when trying to
open
> the linked tables. If I create a brand new access DB and link the
> tables again it works. But only as long as I have it opened. Then
> it breaks after I close it and come back in.
>
> --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> > The assumption is that your Access database is linked to the
> Progress
> > database so the data is always live. Access contains tables,
> queries,
> > forms, reports, etc. and that is what you are importing to a new
> file.
> > I don't believe you can import report builder reports. By
> creating a
> > new file, you are changing the owner of the objects - that is
all -
> > which may fix your authorization issue.
> >
> >
> >
> > Butch
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of ecfmis
> > Sent: Tuesday, October 04, 2005 7:48 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: MS Access and Merant 3.6 ODBC driver issues
> >
> >
> >
> > Thanks for responding, but wont this create a 2nd copy of the
data
> > so it will no longer be 'live' data that I am querying from? And
> > how do you import reports from the report builder?
> >
> > thanks
> > ecfmis
> >
> > --- In vantage@yahoogroups.com, "Butch Menge" <bmenge@t...> wrote:
> > > Create a new Access database and link the tables to vantage.
> > Import in
> > > all the other objects from the database you are having trouble
> with
> > > (queries, forms, reports, modules). When imported you will be
> the
> > owner
> > > of the objects.
> > >
> > >
> > >
> > > Butch
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> On
> > Behalf
> > > Of ecfmis
> > > Sent: Wednesday, September 28, 2005 6:03 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] MS Access and Merant 3.6 ODBC driver issues
> > >
> > >
> > >
> > > I am trying to copy a report from the report writer into
> Access.
> > So I
> > > link the tables in Access using the ODBC drivers. I use the
> login
> > of
> > > the person who created the database. It will let me link the
> > tables.
> > > But as soon as I close the Access database and re-open them, it
> no
> > > longer works with the authorization failed message. Do I need
> to
> > > create a new user for the DB and transfer dba rights? Or will
> > this
> > > mess vantage up? I also tried to link a server in SQL but had
> > > absolutely no luck with authorization failing everytime I
tried.
> > >
> > >
> > >
> > >
> > >
> > > 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/>
> > > <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
> > >
> > >
> > >
> > > * 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
> >
> >
> >
> > * 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



* 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]