Topic Options
Rate This Topic
#16011 - 10/01/99 05:58 PM Re: Access 2000
rob walsman Offline
Stealth Member

Registered: 06/12/01
Posts: 72

Rob Walsman
GTE Data Services

-----Original Message-----
From: John.Bobik@SMED.COM [ mailto:John.Bobik@SMED.COM]
Sent: Friday, September 24, 1999 13:17
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Access 2000


We run our printing tickets and reports through Access 97 via a run
process. We have a site where a couple of the users upgrade to Office 2000
and they get a access error of win.exec failed.

Has anyone run in to the same problem. I checked microsoft support but did
not see anything.

Thanks in advance for your help

John Bobik
Shared Medical System
john.bobik@smed.com

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist



Top
#16012 - 10/01/99 06:13 PM Re: Access 2000 [Re: hvrbyte]
zbyluta Offline
Stealth Member

Registered: 06/12/01
Posts: 39
works...

The way we print reports is to fire a macro that exports a .csv file to a
specified location. Then we have a Run Process call Access and run an
Access Macro which prints the appropriate report. The Access db consists of
Linked Tables that draw from the .csv files.

The only way this will work is if Access is installed with text drivers, and
if you have your autoexec.bat (Windows 95) or Environment Variables (Windows
NT) calling the path to MS Office on startup. To resolve the issue of
manually changing that option on our systems, I created an install file that
installs the Access database and sets the appropriate variables, depending
on the OS and the permissions of the user logged in.

If you want more info, let me know...

Best Regards,

Ann Zbylut
Remedy Programmer Analyst
SMS Technical Services, Sutter Health
ZbylutA@sutterhealth.org
http://remedyweb


> -----Original Message-----
> From: Walsman, Rob [SMTP:Rob.Walsman@TELECOM.GTE.COM]
> Sent: Friday, October 01, 1999 2:59 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: Access 2000
>
> John: Just out of curiosity, how did you get the connection between
> Remedy data and access? I've been working with Remedy tech support to get
> this working and come up empty so far.
>
> Rob Walsman
> GTE Data Services
>
> -----Original Message-----
> From: John.Bobik@SMED.COM [ ]
> Sent: Friday, September 24, 1999 13:17
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Access 2000
>
>
> We run our printing tickets and reports through Access 97 via a run
> process. We have a site where a couple of the users upgrade to Office 2000
>
> and they get a access error of win.exec failed.
>
> Has anyone run in to the same problem. I checked microsoft support but did
>
> not see anything.
>
> Thanks in advance for your help
>
> John Bobik
> Shared Medical System
> john.bobik@smed.com
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


Top


Moderator:  Matt Reinfeldt