• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Can Crstyal Reports Update Fields in an Access DataBase?

I currently have Crystal 2008 and Access 2010.  My database is from Access.
I need to be ablle to put values in 2 of the fields on the table. What would be the
best way to do this?
0
MidWestGirl
Asked:
MidWestGirl
  • 9
  • 5
1 Solution
 
wkrasnerCommented:
either you can ODBC or you can directly link to Access. There is a choice for access/excel in the database expert for connection.
0
 
MidWestGirlAuthor Commented:
Yes I am connected to the access from Crystal. I created some formulas in crystal to change the
value of 2 fields. I need this to be a permanent change in the access table.
0
 
MidWestGirlAuthor Commented:
Does just setting the values in Crystal actually change it in the database?

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
wkrasnerCommented:
sorry  Imissed your question about "update",  as far as I know cr is a view only you can export though.
0
 
MidWestGirlAuthor Commented:
yes I set it up to export to excel. I get 3 sheets created in the workbook. Don't know why this is.
0
 
wkrasnerCommented:
you would have to likely export through ODBC
0
 
wkrasnerCommented:
in an export through odbc to access I believe you will have o create a new table, so in essence you can update and replace an existing field in a data table.
0
 
MidWestGirlAuthor Commented:
I thought I could use SQL or some other language to do a write to the table. I go through the export report function. I did not see anything there for acess.
0
 
wkrasnerCommented:
use odbc for the export
0
 
wkrasnerCommented:
export to odbc
0
 
wkrasnerCommented:
whoops wrong one


Picture1.jpg
0
 
wkrasnerCommented:
0
 
MidWestGirlAuthor Commented:
Cool! Learned something new. hanks!
0
 
wkrasnerCommented:
my pleasure
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now