I am working on a networked version of Access 2000 using a Visual Basic 6 front end. The access file was recently moved to a new server with MS Server 2003 installed. Over the last couple of days my clients, who have todate had no problems accessing the data, have one by one been unable to access the data getting error message "Unrecognized database format".
Any help would be appreciated.
ADODC unrecognized database format for Access 2000
igloo iguana
What may have happened is that the database is now on a windows Server 2003, what version of Access is on this machine. Access 2000 or Access 2003.
If its 2003 then this may be your problem - the database format for Access 2003 is different from that of Access 2000. When you open it up in Access it will want to do a conversion to the new format.
When VB is trying to access the database it is making use of MDAC (Microsoft Data Access Components) to access the database, this ultimately has to access the file which is in an older format. Now the original drivers etc. around when VB6 was released would know nothing about the versions of Access released after it. So this is what the MDAC/JET Service Packs are all about.
I had seen a similar problem to this a long while back when it was Access 2 to Access 97. If the database format was coverted to the later format which was what Access wanted to do it wouldnt work, and the later version wouldnt let me do any table changes etc. without it being converted.
Some things I would do.
Ensure that your using the latest MDAC / JET drivers to access the database. I think we are probably looking at SP8 for MDAC and Jet 4.0 Drivers
I would determine what version of Access you are using
Determine if it has changed from the earlier version that was working - if you try loading the new file into the older version does it work
Heres another forums thread which may provide some clues
http://forums.devx.com/showthread.php p=428056
But as this is a VB6 issue and not really the focus of these forums which are for VB.Net I'll hope that the above information will get you going again.
Pramod Gurunath - MSFT
This may be of use....
http://support.microsoft.com/kb/q238401/
http://www.devx.com/vb2themax/Tip/18535
Please note these forms are intended for VB.net questions. . Questions regarding VB6 / Access 2000 should be posted in the newsgroups
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vb.general.discussion&lang=en&cr=US
Alan Cameron Wills
Hello Spotty,
Thanks for your responce. The help you pointed me at made sense if I was just developing the application but this is a developed application, which has been opperational for almost a year, who's data backend has been moved to a new server. The server has the Windows Server 2003 operating system and is being used as an application server. What I don't get is why this would affect the visual basic front end which is installed on the clients machine