 |
09-22-2003, 12:27 PM
|
|
Regular
|
|
Join Date: Jan 2003
Posts: 68
|
|
Grade 11 Computer Science
|
|
Right now i'm in class where we are trying to solve a problem. We cannot link visual basic to microsoft access? We are following the microsft visual basic 6.0 step by step book, yet an error reedadly comes up "Unrecognized Database Format". This is when we try and set the RecordSource through data1. Any suggests or anyone know the problem?
|
|
09-22-2003, 12:31 PM
|
 |
Contributor
|
|
Join Date: Jul 2003
Location: Singapore
Posts: 686
|
|
May i comment
May be this helps..
R U Using Access 2000 db or above?
If so U Should try to install Service Pack 5?
|
__________________
I May Have Interpret It wrongly
Correct me..if I misunderstood U.
Hope This helps........and Enjoy Coding........//
zak2zak
|
09-22-2003, 12:40 PM
|
|
Regular
|
|
Join Date: Jan 2003
Posts: 68
|
|
|
09-22-2003, 12:43 PM
|
 |
Keeper of foo
Retired Moderator
* Guru *
|
|
Join Date: Nov 2001
Location: Graceland
Posts: 15,612
|
|
Then you need to download and install VB6 Service Pack 5.
|
|
09-22-2003, 12:48 PM
|
|
Senior Contributor
|
|
Join Date: Apr 2000
Location: Edge City, CA
Posts: 799
|
|
Ok,
By "Data1" are you saying your using a datacontrol??
Making sure you have the latest versions is a good idea, but, I don't think that is the problem here.
Please excuse me, but, there isn't much information to go on by your post.
The recordsource is done AFTER the connection is made to the database.
Maybe you could zip up your project with the database and let us take a look at it.
->Noah
|
|
09-22-2003, 12:49 PM
|
|
Keeper of foo
Retired Moderator
* Guru *
|
|
Join Date: Nov 2001
Location: Graceland
Posts: 15,612
|
|
The data control that comes with VB6 pre-SP5 is incompatible with Access 2k. *shrug*
|
|
09-22-2003, 12:49 PM
|
|
Junior Contributor
|
|
Join Date: Aug 2003
Posts: 286
|
|
ah thats what the problem was... i was getting the same crap the other day, i just recreated the db with visdata designer
|
|
09-22-2003, 12:57 PM
|
|
Senior Contributor
|
|
Join Date: Apr 2000
Location: Edge City, CA
Posts: 799
|
|
Ok, now I'm really confused.
Which control?? There are at least 3, right?? RDO, DAO, ADO. So, the only way that SP5 installation (which I recommend) could be the answer is if all three were incompatible. Which I could buy, because it is Micro$oft, after all.
->Noah
|
|
09-22-2003, 04:55 PM
|
|
Centurion
|
|
Join Date: Sep 2003
Posts: 124
|
|
Alex Spiro come on down. It's cam. I think you got it fixed in class didn't you?
|
__________________
In THEORY communism works... In THEORY Mountain Dew tastes good...
|
09-22-2003, 06:27 PM
|
|
Regular
|
|
Join Date: Jan 2003
Posts: 68
|
|
sorry cameron...we did not solve it. and in response to everyone else...i tried installing SP5 at home...no difference... as to everything concerning ADO,DAO and whatnot, i could not tell you. It is not organized and what we are supposed to do is add del and mod entries in a databse..through VB, so far we have only discussed the datacontrol. Wether or not that is enough someone please let me know.
|
|
09-22-2003, 07:39 PM
|
 |
Village VB Idiot
* Expert *
|
|
Join Date: Jan 2003
Location: Idaho
Posts: 1,850
|
|
I get that same error when trying to use the DAO data control with Access 2002/2000. Try using an ADO control instead of the default DAO data control. Either that, or recreate your database in Access 97. DAO is pretty much dead... 
To use the ADO control click Project->Components and select the Microsoft ADO Data Control. That will also automatically add the reference to Microsoft ActiveX Data Objects 2.x.
|
|
09-23-2003, 02:27 AM
|
|
Contributor
|
|
Join Date: Jul 2003
Location: Singapore
Posts: 686
|
|
May I Comment
May be this helps...
If U Have Installed VB6 Service Pack 5
U Should Have At Least Microsoft DAO 3.6 Object Library
Referrence in The Referrence property when U insert the
Data Control. Try Check If it is if it is still Refer to
Microsoft DAO 3.5 Then U have not installed VB6 Service Pack 5
Properly.
If U have confirmed to have the Service Pack Installed Then
U'r property window for Data Control will have the following
As In the picture. Choose Access 2000 in conjunction with u'r
Database?
|
__________________
I May Have Interpret It wrongly
Correct me..if I misunderstood U.
Hope This helps........and Enjoy Coding........//
zak2zak
|
09-23-2003, 07:15 PM
|
|
Regular
|
|
Join Date: Jan 2003
Posts: 68
|
|
thank you very much zak we have now solved the problem.
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
| |
|
