469,599 Members | 2,866 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,599 developers. It's quick & easy.

Access 97 On WXP Refuses to create MDE on OpenDatabase line

Spent hours till I pinned down that on an XP machine the OpenDatabase
method causes MDE creation to fail while a compile produces no error.

A reference in a Google reference pointed me to replacing reference to
MS DAO 3.51 to 3.6 and this seems to solve the problem.

Checking on a W2000 it too has 3.6 installed.

Does anyone know if I will have problems with W98 users if I change all
references to 3.6?

Thanks.
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #1
5 1352
Try putting the DBEngine in front of it and you will not have to make the
change.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Les Desser" <Ne*******@dessergroup.com> wrote in message
news:x0**************@dessergroup.com...
Spent hours till I pinned down that on an XP machine the OpenDatabase
method causes MDE creation to fail while a compile produces no error.

A reference in a Google reference pointed me to replacing reference to
MS DAO 3.51 to 3.6 and this seems to solve the problem.

Checking on a W2000 it too has 3.6 installed.

Does anyone know if I will have problems with W98 users if I change all
references to 3.6?

Thanks.
--
Les Desser
(The Reply-to address IS valid)

Nov 13 '05 #2
In article <41********@news.microsoft.com>, "Michael (michka) Kaplan
[MS]" <mi*****@online.microsoft.com> Fri, 3 Dec 2004 08:39:10 writes
Try putting the DBEngine in front of it and you will not have to make
the change.


Thanks. I am away at the moment but will try it on my return.

Do you have a sample of the syntax handy?
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #3

"Les Desser" <Ne*******@dessergroup.com> wrote in message
news:Wg**************@dessergroup.com...
In article <41********@news.microsoft.com>, "Michael (michka) Kaplan
[MS]" <mi*****@online.microsoft.com> Fri, 3 Dec 2004 08:39:10 writes
Try putting the DBEngine in front of it and you will not have to make
the change.


Thanks. I am away at the moment but will try it on my return.

Do you have a sample of the syntax handy?
--
Les Desser


Michka helped me with this once a long time ago. You can add the DbEngine
prefix for common operations such as:

DBEngine.OpenDatabase(strDbPath)
DBEngine.Idle dbRefreshCache
DBEngine.CreateDatabase

The Mdb may compile and work without the prefix, but fail to compile to
..Mde.

- Steve


Nov 13 '05 #4
In article <31*************@individual.net>, Stephen K. Young
<s@k.y.invalid> Sat, 4 Dec 2004 12:59:56 writes

"Les Desser" <Ne*******@dessergroup.com> wrote in message
news:Wg**************@dessergroup.com...
In article <41********@news.microsoft.com>, "Michael (michka) Kaplan
[MS]" <mi*****@online.microsoft.com> Fri, 3 Dec 2004 08:39:10 writes
>Try putting the DBEngine in front of it and you will not have to make
>the change.


Thanks. I am away at the moment but will try it on my return.

Do you have a sample of the syntax handy?
--
Les Desser


Michka helped me with this once a long time ago. You can add the DbEngine
prefix for common operations such as:

DBEngine.OpenDatabase(strDbPath)
DBEngine.Idle dbRefreshCache
DBEngine.CreateDatabase

The Mdb may compile and work without the prefix, but fail to compile to
.Mde.

Thanks - much appreciated.
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #5
In article <31*************@individual.net>, Stephen K. Young
<s@k.y.invalid> Sat, 4 Dec 2004 12:59:56 writes

"Les Desser" <Ne*******@dessergroup.com> wrote in message
news:Wg**************@dessergroup.com...
In article <41********@news.microsoft.com>, "Michael (michka) Kaplan
[MS]" <mi*****@online.microsoft.com> Fri, 3 Dec 2004 08:39:10 writes
>Try putting the DBEngine in front of it and you will not have to make
>the change.


Thanks. I am away at the moment but will try it on my return.

Do you have a sample of the syntax handy?
--
Les Desser


Michka helped me with this once a long time ago. You can add the DbEngine
prefix for common operations such as:

DBEngine.OpenDatabase(strDbPath)
DBEngine.Idle dbRefreshCache
DBEngine.CreateDatabase

The Mdb may compile and work without the prefix, but fail to compile to
.Mde.

Just tried it and it did the trick - thanks to Michka and yourself for
the help.
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Jon Ole Hedne | last post: by
7 posts views Thread by Paul T. Rong | last post: by
92 posts views Thread by Jeffrey P via AccessMonster.com | last post: by
17 posts views Thread by rdemyan via AccessMonster.com | last post: by
2 posts views Thread by geoff.agnew | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.