Orcad CIS database Microsoft Access Error.

Note to the person who submitted this - it got flagged as spam (and went into moderation) because there is a lot of repeated text (not your fault) in the message, and this gets automatically recognised as potential spam. As a moderator (of other forums), I got notified and approved the post. I'll leave it to somebody from this community forum to respond though!

Andrew.

Andrew Thank You.

Also guys this was a really bad problem and I went through and sought help from Cadence Support on it, I will try and relay what exactly the problem was and how it was solved in order to help the community as I owe it to my helpers. 

OK Mac helped me and I'm going to describe what he did to fix my Microsoft Access Database in the event it helps someone else in the future who is trying to setup their ODBC database for their organization.  

My Access database had some illegal field symbols that was causing the error I had specifically "?"   The reason I had that symbol was because I put in some fields for my organization that I wasn't sure If I truly wanted to implement or not.  That was causing the error screens shown in the pictures above.  

Make sure you do not use "?" or any Illegal symbols as any "field" or "table" names in Microsoft Access because it craps out when you are creating your XXXXX.DBC file in Orcad CIS.   

Orcad doesn't want to see a "?" character as a field name.  

Also make sure the Access database file is in     XXXXX.MDB format when you link it as a source. 

Also use the wizard if you understand it, Its asking to match parameters 2 at a time on each screen.