Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting

Post new topic   Reply to topic
Connecting VB6 to Access 2000 - Please Help!
View previous topic :: View next topic  
Author Message
Mitesh2004
Freshman


Joined: 26 Jan 2004
Posts: 43

PostPosted: Jan 26th, 2004 09:40 AM    Post subject: Connecting VB6 to Access 2000 - Please Help! Reply with quote

I am pretty new to VB and you will probably find my problem really easy to answer, but i am in desperate need of some help.

I am trying to connect my VB6 proram to an Access 2000 database with the simple 'Data' tool. When i click on the 'DatabaseName' property, it allows me to select my database but when i click on the 'RecordSource' property an error message comes up "Unrecognized database format".

Could it be that i need to save my database in some other format maybe?

The Data Control will connect to Excel files... just not Access!!

I would be VERY grateful if someone could tell me what i am doing wrong. I thought that it might be that VB6 doesnt support Access 2000? But there must be some way around this. Any help would be much appreciated.

Cheers!
Back to top
View user's profile Send private message Send e-mail
Avis
Junior Poster


Joined: 07 Oct 2003
Posts: 510
Location: India

PostPosted: Jan 26th, 2004 09:56 AM    Post subject: Reply with quote

Hi!

The problem is that VB6 was developed before MS Access 2000. So you have to get the service pack released by microsoft for this to work with MS Access 2000.

The service pack is called: Visual Studio 6 Service Pack 5

Just download and apply the patch. This will resolve the issue.

Thanks!
_________________
Code Snippets, Tutorials, Utilities, Controls

Low cost Web Hosting
Hosting starts at as low as $4 per year!


Always follow posting guidelines
Put your VB code in [vb ] your code [ /vb] tags!
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger ICQ Number
Mitesh2004
Freshman


Joined: 26 Jan 2004
Posts: 43

PostPosted: Jan 30th, 2004 08:49 AM    Post subject: Reply with quote

Hello,

I tried downloading this but i cannot understand it as it is in a language foreign to me. Any chance you could give me the english version, or tell me where i could find it?

Your help will be greatly appreciated,

Cheers!
Back to top
View user's profile Send private message Send e-mail
Andir
Centurion


Joined: 21 Dec 2003
Posts: 184
Location: Chicago Area

PostPosted: Jan 30th, 2004 09:20 AM    Post subject: Reply with quote

Visual Studio 6.0 Service Pack 5
_________________
If you happen to see little people sitting on your desk...don't tell anyone or they might think your crazy too.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Visual Basic Forum runs phpBB | Forum Template © iOptional
VB Resources | SSL | Visual Basic