Access XP and Crystal Reports 8 - ODBC Issue

[mmsbasd]

I hope this is in the correct forum:

We use a program called TrackIt! to process our repair issues. It's server-based, so I export my work orders into an Access database that's local and look at them through a custom interface. TrackIt! does not have an export feature built-in for this, so I run a report (which uses Crystal Reports 8) and then export it to the database via ODBC.

Everything works fine except for one thing: During the export, I want to OVERWRITE the existing table with the newest version. When I do the export, however, it gives me an error saying that the table name exists and to choose a different name. There is no option to overwrite (no options at all).

What I have to do is save it under a different table name, open the database, delete the old one, rename the new one, recreate the relationship between that table and another one that stays local and then everything works fine. My questions:

1. Is there something I can do on the Access side to allow the export to overwrite the file?
2. Is there a better way to make this happen? Crystal Reports allows for other types of export formats and I'm not looking to change data anyway.

Thanks.



Michael
BASD IS/IT Dept

 

[SBendBuckeye]

Hello Michael. Use the Kill command in Access to delete the old file before you start your Crystal Report procedure. If you need to, you could copy it first.


Have a great day!

j2consulting@yahoo.com