Re: VB6 Questions

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/28/04 

Date: Tue, 27 Jul 2004 23:51:40 -0400

Hi,

What is your connection string? 

-- 
Val Mazur
Microsoft MVP
"Krishna Prabhu" <KrishnaPrabhu@discussions.microsoft.com> wrote in message 
news:359B8F57-93C5-429B-8D58-EF4DDF966B9D@microsoft.com...
> Thank you for your valuable input.
>
> Especially inputbox function was really of help.
>
> about the main issue...
>
> I have downloaded MDAC 4.0 and have installed it.  I also have SP6 for 
> VStudio6.0
>
> I also have referred to the KB articles.  Have tried all that was 
> mentioned in newsgroups earlier.  But am still not able to get it
>
> I also have confirmed that MDAC is installed successfuly.  However I am 
> not sure if VB is still using the older copy of MDAC.  Is there a way how 
> I know what version of MDAC is being called by VB6.0?
>
> "Val Mazur" wrote:
>
>> Hi,
>>
>> 1. It should work fine. What is your connection string? Are you using Jet
>> 3.51 or Jet 4.0? If you need to connect to Access 200 or newer, then you
>> have to use Jet 4.0 and it does not come as a part of Visual Studio or 
>> MDAC
>> anymore. You would need to install it separately. You could download it 
>> from
>> next link
>>
>> http://www.microsoft.com/downloads/results.aspx?productID=&freetext=jet+4+sp8&DisplayLang=en
>>
>> 2. As I remember there is an Input function, which asks for the value, 
>> but
>> my personal opinion is to create some form. In this case you have more
>> control and could validate the input value, before you close this form. 
>> It
>> is extra coding, but it worth it
>>
>> -- 
>> Val Mazur
>> Microsoft MVP
>>
>>
>> "Krishna Prabhu" <Krishna Prabhu@discussions.microsoft.com> wrote in 
>> message
>> news:9AA97984-C6E6-4412-89BC-47C96882E372@microsoft.com...
>> > Hi,
>> >
>> > I have 2 questions while I am writing a program in VB6.0
>> >
>> > Question 1.
>> > -------------
>> > I have VB6 and Access 2002(XP).  When I try to access MS Access 2002
>> > database from VB code I get an error message that says Run-time error 
>> > 3343
>> > Unrecognized Database Format.  I downloaded the latest JET engine.  I 
>> > also
>> > downloaded the latest Service Pack for VStudio. Nothing changed. 
>> > However,
>> > I opened the database and saved it in Access  97 format and that works.
>> > Is there a way to run the application, while I maintain the DB in 
>> > Access
>> > 2002 format?
>> >
>> > Question 2.
>> > -------------
>> > I want to ask user for an input(eg: Start Date for a report).  I want 
>> > to
>> > pop this question to the user as soon as the user clicks on the report
>> > button.  Is there  a way to avoid a form and ask the question using any 
>> > of
>> > the built-in feature?  In other words, instead of using a form just for
>> > this question, is there a way how I can collect one word answer using a
>> > feature just like MSGBOX function.
>> >
>> > Thanks and advance.
>> >
>> > Regards,
>> > Krishna Prabhu
>> >
>> > Another question
>> >
>> >
>>
>>
>>
Quantcast