Creating Database from XSD

[Tom John]

Hi

I am trying to work out how to force an Access database that is
created from XSD to have a field with a set number of decimal places
(in this case 5). Now I am sure the XSD is something like this:

<xs:element name="MyFieldName">
<xs:simpleType>
<xs:restriction base="xs:decimal">
<xs:fractionDigits value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>

Unfortunately this is still creating the field as type Currency with
auto decimal places (which is 4). I have tried to reverse engineer the
XSD by creating the field correctly in Access, then building a dataset
from it and writing out the schema:

<xs:element name="MyFieldName" type="xs:decimal" minOccurs="0" />

As you can see, this is not what I was hoping to see.

Any ideas?

Cheers

Tom

 

[Larry Daugherty]

I've only been perusing this group for about 15 minutes and this post
is the third/sixth I've encountered wherein the poster simply changes
the subject line and re-post her/his issue. That's a great way to
make yourself unwelcome and get none of your posts answered.

Don't post xsd for analysis into an Access newsgroup. Post instead
where they speak xsd.

As to trying to format data in tables; look into Access's Data
Definition Language. If you can achieve your objective in DDL you
have hope. Otherwise, recognize that in Access the tables are simple
repositories of data and that formatting for display is properly done
in Forms and Reports.

HTH

 

[Tom John]

I've only been perusing this group for about 15 minutes and this post
is the third/sixth I've encountered wherein the poster simply changes
the subject line and re-post her/his issue. That's a great way to
make yourself unwelcome and get none of your posts answered.

This is most certainly not the case, I have never posted this message
before.

Don't post xsd for analysis into an Access newsgroup. Post instead
where they speak xsd.

Thought other people using Access may have attempted to create
databases from a schema and therefore may have come across similar, or
have another idea on how to approach this activity as you clearly have
below:

As to trying to format data in tables; look into Access's Data
Definition Language. If you can achieve your objective in DDL you
have hope. Otherwise, recognize that in Access the tables are simple
repositories of data and that formatting for display is properly done
in Forms and Reports.

Thanks, I will investigate this suggestion.

Cheers

Tom