Accessing Access DB from different workstations

Did you set up the ODBC driver on that computer?

Go into Control Panel, Administrative Tools, Data Sources (ODBC) and
set it up the same way you have on your computer.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 6:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Accessing Access DB from different workstations



I created an Access DB that determines the standards for different
jobs. This DB works great and prints out exactly what I need.

However, I put this Access DB on a different computer and now I cannot
access the tables. I receive an error that says: ODBC--connection
to 'PRGS91dODBC' failed.

Can anyone clue me in as to how I can distribute my Access database
for others to use?

Thanks,
Tony






[Non-text portions of this message have been removed]
I created an Access DB that determines the standards for different
jobs. This DB works great and prints out exactly what I need.

However, I put this Access DB on a different computer and now I cannot
access the tables. I receive an error that says: ODBC--connection
to 'PRGS91dODBC' failed.

Can anyone clue me in as to how I can distribute my Access database
for others to use?

Thanks,
Tony
Did you create an ODBC connection on each workstation? Make sure the connection name is the same as yours on your computer.

-----Original Message-----
From: sheehanam21 [mailto:sheehanam@...]
Sent: Thursday, March 08, 2007 7:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Accessing Access DB from different workstations



I created an Access DB that determines the standards for different
jobs. This DB works great and prints out exactly what I need.

However, I put this Access DB on a different computer and now I cannot
access the tables. I receive an error that says: ODBC--connection
to 'PRGS91dODBC' failed.

Can anyone clue me in as to how I can distribute my Access database
for others to use?

Thanks,
Tony







[Non-text portions of this message have been removed]
You need to create the odbc connection on each workstation that needs to
run the reports. The name of the connection has to be exactly the same
as the original connection. Also, make sure you set these connections
to "Read Uncommitted" and lock down the ODBC config files so it can't be
change by your users. This will help to insure your users don't
accidentally write to the datasbase.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 7:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Accessing Access DB from different workstations

I created an Access DB that determines the standards for different
jobs. This DB works great and prints out exactly what I need.

However, I put this Access DB on a different computer and now I cannot
access the tables. I receive an error that says: ODBC--connection
to 'PRGS91dODBC' failed.

Can anyone clue me in as to how I can distribute my Access database
for others to use?

Thanks,
Tony



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



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
How do you lock down the ODBC config files?

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, March 09, 2007 9:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Accessing Access DB from different workstations



You need to create the odbc connection on each workstation that needs to
run the reports. The name of the connection has to be exactly the same
as the original connection. Also, make sure you set these connections
to "Read Uncommitted" and lock down the ODBC config files so it can't be
change by your users. This will help to insure your users don't
accidentally write to the datasbase.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of sheehanam21
Sent: Thursday, March 08, 2007 7:20 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Accessing Access DB from different workstations

I created an Access DB that determines the standards for different
jobs. This DB works great and prints out exactly what I need.

However, I put this Access DB on a different computer and now I cannot
access the tables. I receive an error that says: ODBC--connection
to 'PRGS91dODBC' failed.

Can anyone clue me in as to how I can distribute my Access database
for others to use?

Thanks,
Tony

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. <http://groups.yahoo.com/group/vantage/files/.> yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages> yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links> yahoo.com/group/vantage/links
Yahoo! Groups Links

<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________<DIV><FONT>






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