×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

VB 6.0 cannot access upgraded Access 2000

VB 6.0 cannot access upgraded Access 2000

VB 6.0 cannot access upgraded Access 2000

(OP)
Hi, I upgraded from Access 97 to Access 2000 recently. Whenever i try to access Access 2000, it give me a "unrecognized database format" error. I did some research and found out thats it because of outdated DAO and ADO (whatever that means!)

The "remedy" at the microsoft site does not help. I access the database using the Databound control and setting its properties on the right. Whenever I click on the data source property it says "it doesnt recognize the database format". Interstingly the databases which are originally 97 are accessed without problem. Now my questions are:

1. What do i need to upgrade/download
2. Where can i get these downloads for free
3. Do i have to upgrade both Access 2000 (the database components)
4. Do I have to upgrade just the VB6.0 (service packs?)
5. Will I get this same error if i try to access it via script instead of setting properties? (I havent learnt it yet)

It would be great if you can provide me with the links also. thank you in advance. i'm a novice at programming.. so a little descriptive detail would be great and this is my first post here in any of the forums on this site.

thank you
CrazyHorse!!!

RE: VB 6.0 cannot access upgraded Access 2000

To upgrade your data access components (ADO and DAO, among other things) you need to install the newest version of mdac. This is available at microsofts website (the filename should be mdac_typ.exe). I dont know if this will update your data controls also, i never use them.

Ruairi
ruairi@logsoftware.com
Experienced with:
VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions
ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications

RE: VB 6.0 cannot access upgraded Access 2000

(OP)
Thank you Ruairi

I will check on that and update you

-CH

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! Already a Member? Login

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