Version 2302 Build 16130.20306 bug (1 Viewer)

[md79]

There is a bug with the latest version.

Using DAO - setting DefaultValue with certain non alphanumeric characters fails.

For example this line of code fails.

pclDB.TableDefs("Tenants").Fields("URMulti").DefaultValue = "."

It fails with Error 3320 - Syntax error (missing operator) in table-level validation expression.

 

[theDBguy]

Hi. Welcome to AWF!

Here's the actual error message I got when I gave it a try. Not sure if that helps.

 

[sonic8]

For example this line of code fails.

pclDB.TableDefs("Tenants").Fields("URMulti").DefaultValue = "."

I'm afraid the bug is in your code, not in Access.

The correct syntax for setting the default value is:

pclDB.TableDefs("Tenants").Fields("URMulti").DefaultValue = """."""

The value of DefaultValue is an expression, so any string literals in that property must be enclosed in string delimiters.
With some, non-ambiguous expressions Access also accepts your incorrect syntax omitting the delimiters for a character literal.

 

[md79]

Thanks, that worked.

But it's worth noting that this change is limited to the latest build. This code does not break on other versions and builds.

 

[sonic8]

But it's worth noting that this change is limited to the latest build. This code does not break on other versions and builds.

Are you sure? I recommend you double check.
I get the very same error message in Access 2010 already.
I remember getting the same error in similar situations multiple times over the years. I strongly doubt, this worked in any version ever.

 

[Josef P.]

Just tested (v 2208): via code it was possible to set only the point (without "), with manual change in the table design the " were set.

 

[md79]

Are you sure? I recommend you double check.
I get the very same error message in Access 2010 already.
I remember getting the same error in similar situations multiple times over the years. I strongly doubt, this worked in any version ever.

Yes, we have multiple users installing our latest update, this only failed on the latest build.