WRITING TO ACCESS DATABASE

[ajdesigns]

Is there any way that I can setup a 1 page report(pallet statement) and write the data entered to an access database.I need to use parameter fields to promt the user to enter a lotno, product code etc I then want the data entered to be written back to the corresponding access database.

 

[synapsevampire]

You can probably write it back to the database using ODBC, but it would have to be to a new table.

Keep in mind that data isn't entered into a Crystal Report, it's read from a data source (except for parameters), so what you're requesting is something that Access would do very nicely itself and not require Crystal.

There may be other means, but without knowing your version of Crystal nor Access it's hard to speak beyond this.

-k

 

[chelseatech]

You could also do it inside a UFL. Watch out for our ODBC UFL function to be released in the near future.

Or I can email you trial version if you are interested.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm