INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access 2010/Crystal XI

Access 2010/Crystal XI

(OP)
Just had my computer replaced and the one thing I forgot to get off the old one was my connection to an Access 2010 database.

I'm using Crystal XI

When I try to build an ODBC connection the driver is looking for mdb files, what I have is an accdb file. Same thing when I just do "new connection" and select "Access/Excel" as the option.

I remember that it was a pain to set up the first time, but don't remember how I did it. Any ideas?

RE: Access 2010/Crystal XI

First off you need the ODBC driver for Microsoft Access Driver (*.mdb, *.accdb). Then you will have to create the ODBC (I did not know that CR XI would even work with Access 2007+). At least that is how it works with CR 2011.

RE: Access 2010/Crystal XI

(OP)
Sorry to take so long to get back on this. I ran into some conflicts and had to uninstall a 32-bit app in order to allow the 64-bit driver to install.

Thanks for the assistance.

RE: Access 2010/Crystal XI

(OP)
Oops, I spoke too soon. The driver installed correctly, but I'm still having trouble getting Crystal to use the Access database. When I try to set up an ODBC connection I'm prompted for a username and password - this database does not have one.

I remember it being quite difficult to get set up the first time, and I need to resolve this quickly because people are pushing me to get the data.

RE: Access 2010/Crystal XI

If there is no user name or password, then you should be able to leave those blank and still connect. Of course be sure to use the 32-bit OBDC.

RE: Access 2010/Crystal XI

(OP)
Okay, I have the 64 bit installed. Back to the installing board.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close