DAO 3.6

DAO 3.6

Post by Dipak Goya » Thu, 21 Mar 2002 19:10:22



Even after installing the Jet DAO 3.6, the vbdataform wizard gives an error
"Unrecognized database format". I'm want to retrieve data from  vb6.0 with
office 2000.

Any suggestions

dipak

 
 
 

DAO 3.6

Post by Kevin Williams » Fri, 22 Mar 2002 01:43:19


Dipak,

Check out the following KB article:
Q242010 - FIX: The Data Form Wizard May Not Open an Access 2000 Database

To find a KB article you can type "MSKB articlenum" into Internet
Explorer's Address Bar (without the quotes) or you can go to
http://support.microsoft.com.

Kevin Williamson - Microsoft Visual Basic Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

--------------------


| Subject: DAO 3.6
| Date: Wed, 20 Mar 2002 15:40:22 +0530
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.00.2615.200
| X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200

| Newsgroups: microsoft.public.vb.database
| NNTP-Posting-Host: ptil-196-151-hyd.primus-india.net 203.196.151.196
| Path: cpmsftngxa07!tkmsftngp01!tkmsftngp02
| Xref: cpmsftngxa07 microsoft.public.vb.database:80857
| X-Tomcat-NG: microsoft.public.vb.database
|
| Even after installing the Jet DAO 3.6, the vbdataform wizard gives an
error
| "Unrecognized database format". I'm want to retrieve data from  vb6.0 with
| office 2000.
|
| Any suggestions
|
| dipak
|
|
|

 
 
 

DAO 3.6

Post by Buky » Fri, 22 Mar 2002 15:00:35


Use SP 5 for VB


Quote:> Even after installing the Jet DAO 3.6, the vbdataform wizard gives an
error
> "Unrecognized database format". I'm want to retrieve data from  vb6.0 with
> office 2000.

> Any suggestions

> dipak

 
 
 

DAO 3.6

Post by Anders Gr?ndah » Sat, 23 Mar 2002 00:11:30


Hello Kevin.
What about us poor people still using VB 5, is there any help to get from
you on the subject.
Regards
Anders



> Dipak,

> Check out the following KB article:
> Q242010 - FIX: The Data Form Wizard May Not Open an Access 2000 Database

> To find a KB article you can type "MSKB articlenum" into Internet
> Explorer's Address Bar (without the quotes) or you can go to
> http://support.microsoft.com.

> Kevin Williamson - Microsoft Visual Basic Developer Support
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
> reserved.

> --------------------


> | Subject: DAO 3.6
> | Date: Wed, 20 Mar 2002 15:40:22 +0530
> | Lines: 9
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 5.00.2615.200
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200

> | Newsgroups: microsoft.public.vb.database
> | NNTP-Posting-Host: ptil-196-151-hyd.primus-india.net 203.196.151.196
> | Path: cpmsftngxa07!tkmsftngp01!tkmsftngp02
> | Xref: cpmsftngxa07 microsoft.public.vb.database:80857
> | X-Tomcat-NG: microsoft.public.vb.database
> |
> | Even after installing the Jet DAO 3.6, the vbdataform wizard gives an
> error
> | "Unrecognized database format". I'm want to retrieve data from  vb6.0
with
> | office 2000.
> |
> | Any suggestions
> |
> | dipak
> |
> |
> |

 
 
 

DAO 3.6

Post by Kevin Williams » Sat, 23 Mar 2002 02:21:55


Anders,

I don't have VB5 handy to test with, but I would think that the 2
workarounds mentioned in the article would also work for VB5.  Have you
tried them both?  Are you still having a problem?

Kevin Williamson - Microsoft Visual Basic Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

--------------------


| Subject: Re: DAO 3.6
| Date: Thu, 21 Mar 2002 16:11:30 +0100
| Lines: 55
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

| Newsgroups: microsoft.public.vb.database
| NNTP-Posting-Host: 80.202.12.101
| Path: cpmsftngxa09!cpmsftngxa07!tkmsftngp01!tkmsftngp07
| Xref: cpmsftngxa09 microsoft.public.vb.database:80410
| X-Tomcat-NG: microsoft.public.vb.database
|
| Hello Kevin.
| What about us poor people still using VB 5, is there any help to get from
| you on the subject.
| Regards
| Anders
|


| > Dipak,
| >
| > Check out the following KB article:
| > Q242010 - FIX: The Data Form Wizard May Not Open an Access 2000 Database
| >
| > To find a KB article you can type "MSKB articlenum" into Internet
| > Explorer's Address Bar (without the quotes) or you can go to
| > http://support.microsoft.com.
| >
| > Kevin Williamson - Microsoft Visual Basic Developer Support
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| > You assume all risk for your use. ? 2001 Microsoft Corporation. All
rights
| > reserved.
| >
| > --------------------


| > | Subject: DAO 3.6
| > | Date: Wed, 20 Mar 2002 15:40:22 +0530
| > | Lines: 9
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 5.00.2615.200
| > | X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200

| > | Newsgroups: microsoft.public.vb.database
| > | NNTP-Posting-Host: ptil-196-151-hyd.primus-india.net 203.196.151.196
| > | Path: cpmsftngxa07!tkmsftngp01!tkmsftngp02
| > | Xref: cpmsftngxa07 microsoft.public.vb.database:80857
| > | X-Tomcat-NG: microsoft.public.vb.database
| > |
| > | Even after installing the Jet DAO 3.6, the vbdataform wizard gives an
| > error
| > | "Unrecognized database format". I'm want to retrieve data from  vb6.0
| with
| > | office 2000.
| > |
| > | Any suggestions
| > |
| > | dipak
| > |
| > |
| > |
| >
|
|
|

 
 
 

1. Security problem DAO 3.51 --> DAO 3.6

I have a VB6 program that uses DAO for accessing a Access database which is
secured with a MDW file. For that i use the following lines of code:

DBEngine.SystemDB = "MyFile.MDW"
DBEngine.DefaultUser = "MyUser"
DBEngine.DefaultPassword = "MyPassword"

SET dbMyDataBase = Workspaces(0).OpenDataBase("MyDataBase.MDB")
etc.

When i use DAO 3.51 and Access97 it works fine, but when i use DAO 3.6 and
Access2000 i get the following error when i try to open the database:

"Run-time error '3033'

You do not have the necessary permissions to use the 'MyDataBase.MDB'
object. Have your system administrator or the person who created this object
establish the appropriate permissions for you."

When i look at the current systemdb this is correct, but when i look at the
username from the workspace it is 'admin' and not 'MyUser'. I use VB6 with
servicepack 3 and both the database and security-file are upgraded to
Access2000. I can access the database using the security-file by starting
access on the 'run-prompt'.

I wan't to upgrade to Access2000 because an Access2000 database can allocate
2 Gb of space in stead of Access97 which can only allocate 1 Gb. For
technological reasons i cannot use SQL7.0 for this application and i cannot
use ADO because ADO has on this moment not the possibilitys which has DAO.

Can someone help me?

2. multiple CPUs

3. Error 3146 with DAO 3.6 (ok with DAO 3.5)

4. SQL 2000 hangs on install

5. HELP PLS--DAO 3.51 OK, DAO 3.6 NOT WORKING

6. Installing on Windows 95

7. DAO 3.6 vs DAO 3.5 openrecordset

8. Right trimming data from a field

9. VB6 SP5 DAO 3.51 or DAO 3.6 with SQL 7.0

10. DAO 3.5 lost functionality with DAO 3.6/4.0

11. Dao 3.51, Dao 3.6 and SQL different Formats??????????

12. Dao 3.6 Problem Versus Dao 3.51

13. How to go from DAO 3.5 to DAO 3.6