Export data from Vantage 8.03 to Microsoft Access

I did that and it seemed it was using up odbc connections for each
linked table then we started experiencing issues connecting into
Vantage something to the affect of no more odbc connections available

Thanks

Dan

--- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@...> wrote:
>
> Dan,
>
> Edit your ODBC DSN by going to the advanced tab and
> selecting "Read Uncommitted" as the Default Isolation Level.
>
> This will allow that DSN to access the Vantage tables without
creating a
> record lock. It will also prevent the adventurous users from
> inadvertently modifying or deleting any data within Vantage.
>
>
>
> Gerard M Wadman
>
> Sr. Network Systems Engineer
>
>
>
> Scandius BioMedical Inc.
>
> 11A Beaver Brook Road
>
> Littleton, MA 01460
>
>
>
> 978/486-4088 x 124
>
> 978/486-4108 (fax)
>
>
>
> http://www.scandius.com/
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dan Ernst
> Sent: Friday, March 23, 2007 1:45 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Export data from Vantage 8.03 to Microsoft Access
>
>
>
> Does anyone export data from Vantage to Access? When we were on 6.1
we
> could export a BAQ in a DB format. In 8.03 you do not have that as
one
> of the choices now, I believe you only have 2 choices CSV and TXT.
We
> have tried to link the tables with an ODBC connection set at read
only
> but then we were getting connection error messages that said
something
> like that we had no more connections available.
>
> Thanks
> Dan Ernst
> Correct Craft Inc
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Does anyone export data from Vantage to Access? When we were on 6.1 we
could export a BAQ in a DB format. In 8.03 you do not have that as one
of the choices now, I believe you only have 2 choices CSV and TXT. We
have tried to link the tables with an ODBC connection set at read only
but then we were getting connection error messages that said something
like that we had no more connections available.

Thanks
Dan Ernst
Correct Craft Inc
Dan,

Edit your ODBC DSN by going to the advanced tab and
selecting "Read Uncommitted" as the Default Isolation Level.

This will allow that DSN to access the Vantage tables without creating a
record lock. It will also prevent the adventurous users from
inadvertently modifying or deleting any data within Vantage.



Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Ernst
Sent: Friday, March 23, 2007 1:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Export data from Vantage 8.03 to Microsoft Access



Does anyone export data from Vantage to Access? When we were on 6.1 we
could export a BAQ in a DB format. In 8.03 you do not have that as one
of the choices now, I believe you only have 2 choices CSV and TXT. We
have tried to link the tables with an ODBC connection set at read only
but then we were getting connection error messages that said something
like that we had no more connections available.

Thanks
Dan Ernst
Correct Craft Inc





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