Ideas why Application.SetOption "Default File Format", 0 doesn't w

[Guest]

For Marshall (and any else who can answer this quetiion):

I posted a question on 21 Jul why the method
'application.ConvertAccessDatatase' didn't work on another machine, but
worked perfect on mine. Well, I found the reason why the code didn't work:
The target database was already an Access 2000 file format, so the code
barfed. Diggigng deeper into this, I found a flaw/loophole MS Access, and it
is this:

If you set the 'Default File Format' (in the "Options","Adavanced" tab) to a
version less than what you are currently using (example "Access 2000") and
your current version is Access 2002 or better, MS Access doesn't care and
converts the targeted tables to the new datatabase in Access 2000 file
format.

The good thing is, that, you can continue to use your Access 2003 (or
better) databases without any error. You'll never know the difference.

Thus, the code line 'application.ConvertAccessDatatase' is mostly useless.

Here is the question

For this particular SetOption, why this doesn't work. The option is a list
box,

Application.SetOption "Default File Format", 0

(Under Access 2003, Listbox tem 0 is "Access 2000"). The coded line is
doesn't work.

Any ideas?

(e-mail address removed)

 

[RoyVidar]

For Marshall (and any else who can answer this quetiion):

I posted a question on 21 Jul why the method
'application.ConvertAccessDatatase' didn't work on another machine,
but worked perfect on mine. Well, I found the reason why the code
didn't work: The target database was already an Access 2000 file
format, so the code barfed. Diggigng deeper into this, I found a
flaw/loophole MS Access, and it is this:

If you set the 'Default File Format' (in the "Options","Adavanced"
tab) to a version less than what you are currently using (example
"Access 2000") and your current version is Access 2002 or better, MS
Access doesn't care and converts the targeted tables to the new
datatabase in Access 2000 file format.

The good thing is, that, you can continue to use your Access 2003 (or
better) databases without any error. You'll never know the
difference.

Thus, the code line 'application.ConvertAccessDatatase' is mostly
useless.

Here is the question

For this particular SetOption, why this doesn't work. The option is
a list box,

Application.SetOption "Default File Format", 0

(Under Access 2003, Listbox tem 0 is "Access 2000"). The coded line
is doesn't work.

Any ideas?

(e-mail address removed)

On my 2003 and 2002 setups,

?Application.GetOption("Default File Format")

returns 10 for 2002-2003 and 9 for 2000. I can also use 9 and 10 with
SetOption respectively to alter the settings.

 

[Guest]

Hey, thanks much! Value 9 worked great! But why is this so contrary to the
"official" definition that the value be the list box item position, in this
case 0, for an Accesss 2000 file format?

Anyhoo, thanks for the insight.

 

[RoyVidar]

Hey, thanks much! Value 9 worked great! But why is this so contrary
to the "official" definition that the value be the list box item
position, in this case 0, for an Accesss 2000 file format?

Anyhoo, thanks for the insight.

I guess it might be because there are more than one way of referencing
Access versions - then it kind of makes sence to me - but, who says I'm
normal ;-)

97 - 8.0
2000 - 9.0
2002 - 10.0
2003 - 11.0

and check out the header here
http://blogs.msdn.com/access/

Then - to denote the 2002/2003 format, I guess 10.0 is OK, since it
works on both versions/is the same format?

 

[Guest]

Normal or not (who really cares when you dealing with Access), the info saved
me from having a massive headache!

Simple value of "9" worked perfectly. Thanks again.