 |  |  |  |  |  |  |  |
VB/MS Access Issue
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
I've got a VB app I wrote that runs over Access and works pretty well for the most part. However, there are a couple of pages where I get the following error when trying to access a database (no pun intended).
I'm getting the error "Unrecognized Database Format (path to .mdb file)". This seems to happen both if I'm trying to load a grid or a data control. The program keeps running after I hit "OK", but no data is loading into the objects (of course).
Any ideas?
I'm getting the error "Unrecognized Database Format (path to .mdb file)". This seems to happen both if I'm trying to load a grid or a data control. The program keeps running after I hit "OK", but no data is loading into the objects (of course).
Any ideas?
Hi, from my experience, this usually happens when the Access database is corrupt, or in the process of going corrupt. Try using the Access repair utility and see if it corrects your error.
Charles
Charles
•
•
•
•
Originally Posted by Roobyroo 
I've got a VB app I wrote that runs over Access and works pretty well for the most part. However, there are a couple of pages where I get the following error when trying to access a database (no pun intended).
I'm getting the error "Unrecognized Database Format (path to .mdb file)". This seems to happen both if I'm trying to load a grid or a data control. The program keeps running after I hit "OK", but no data is loading into the objects (of course).
Any ideas?
•
•
•
•
Originally Posted by cdgaefke
Hi, from my experience, this usually happens when the Access database is corrupt, or in the process of going corrupt. Try using the Access repair utility and see if it corrects your error.
Charles
I'm going under Tools/Database Utilities/Compare and Compact Database, but it keeps giving me the change to open a database over and over, but never to repair it. I'm using Access 2003. What am I missing?
In Access 97, the repair and compact methods are separate. In Access 2003, they appear to be the same. That goes along with everything I've seen ... the JetComp utility does it all in one, and the JRO method does as well.
I assume this didn't fix your problem?
If not, other things I'd check are:
- Try to have the version of the database match the version of Access, if possible. That is, if you have Access 2003, don't use it on an Access 97 or Access 2000 database.
- Check your connection method. How are you establishing the connection to the Access database? The most direct, efficient, and safe is with Jet 4. If you aren't sure, can you post the connection string used on the connection object? (Might be an ADO control or an actual ADODB.Connection object, or something else still.)
I assume this didn't fix your problem?
If not, other things I'd check are:
- Try to have the version of the database match the version of Access, if possible. That is, if you have Access 2003, don't use it on an Access 97 or Access 2000 database.
- Check your connection method. How are you establishing the connection to the Access database? The most direct, efficient, and safe is with Jet 4. If you aren't sure, can you post the connection string used on the connection object? (Might be an ADO control or an actual ADODB.Connection object, or something else still.)
•
•
•
•
Originally Posted by Roobyroo
I'm going under Tools/Database Utilities/Compare and Compact Database, but it keeps giving me the change to open a database over and over, but never to repair it. I'm using Access 2003. What am I missing?
OK may I know how you create your database? Is it You just type outside your program(By means of opening Microsoft Access manually from outside of VB6)?
You are trying to connect a MSAccess database written in higher version than what the underlying data control is trying to access.
Select the data control and press F4 (properties). Look for Connect property. If is set to 'Access', make it 'Access 2000'. This works if your database is in MSOffice 2000. If your database is in MSOffice 95 or 97, 'Access' value is correct.
Check project references (Project > References menu in VB IDE).
Use the latest DAO version 3.6 (or higher).
This should fix your problem.
If not, repair the database and try to open in MSAccess itself.
If you can not, the database is irrepairable.
Select the data control and press F4 (properties). Look for Connect property. If is set to 'Access', make it 'Access 2000'. This works if your database is in MSOffice 2000. If your database is in MSOffice 95 or 97, 'Access' value is correct.
Check project references (Project > References menu in VB IDE).
Use the latest DAO version 3.6 (or higher).
This should fix your problem.
If not, repair the database and try to open in MSAccess itself.
If you can not, the database is irrepairable.
•
•
•
•
Originally Posted by 1g0r
OK may I know how you create your database? Is it You just type outside your program(By means of opening Microsoft Access manually from outside of VB6)?
I created all the tables in the database four or five years ago in Access 97.
•
•
Join Date: Nov 2006
Posts: 848
Reputation: 
Solved Threads: 120
Practically a Posting Shark
Hi,
Access 2000 And Greater Versions Cannot be bound to DataControl Control In VB6. For that u will have To Use ADODC Control.
Regards
Veena
Access 2000 And Greater Versions Cannot be bound to DataControl Control In VB6. For that u will have To Use ADODC Control.
Regards
Veena
Connect property of data control can be set to 'Access 2000' instead of older 'Access'. Just this simple change will work.
•
•
•
•
Originally Posted by udaywali
Connect property of data control can be set to 'Access 2000' instead of older 'Access'. Just this simple change will work.
I did this and it solved the initial problem. However, now I'm getting the error message:
Couldn't find installable ISAM
Do you know what that's about?
|
Similar Threads
- Wireless Network Remote Access Issue (Networking Hardware Configuration)
- Sensor Access issue in Win2000 (Windows NT / 2000 / XP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: How Use 32 Bit Icon
- Next Thread: retrieve record
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
