Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Connecting ARS Remedy to MS Access

Posted on 2006-04-21
3
Medium Priority
?
1,548 Views
Last Modified: 2008-01-09
I am using ARS Remedy Version 4.05.02
at the end of the day I would like to be able to generate a report on all the tickets I opened for the day.  I am having trouble generated reports in remedy (I can do searches but can't get a report view).

If I can't get it to work in Remedy, I'd like to pull the information into MS Access 2003

I believe I have to do something with ODBC or DSN connection? (don't know anything about creating this so I'm not even sure if I am saying it right)

I need someone to walk me through generating a report either in Remedy or MS Access
Also, is there a variable "TODAY" --- date didn't seem to work, when I get this going I want to create a macro to run at the end of the day so I don't want to hard code the date.

Other information --- I am a remedy end-user...don't have access to the server...but I do know the server name if I need it to create a connection.

Thanks in advanced
0
Comment
Question by:alikat538
  • 2
3 Comments
 
LVL 1

Author Comment

by:alikat538
ID: 16525495
Update:
I got the DB to connect in MSACCESS and created a query because our remedy DB is pretty large.
The query should be relatively small --- less than 10 records

So then I tried to a query to pull only the first record so that I could see it was actually pulling in the data --- it still doesn't respond.  It actually crashes and I have to close Access.

I know it is connected cause it asks for my username / password and the fields are correct on the table.

Help :)
0
 
LVL 1

Author Comment

by:alikat538
ID: 16552919
Figured out how to use the Remedy reports --- not great, but it gets the job done.  Requesting to be closed
0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16553870
Closed, 300 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question