Newbie --- Have InfoPath, now can I create MS-Access db repository

[Tom]

Hi ... I am new at InfoPath but have 8 years experience programming and
building MS-Access backends.

I just built an InfoPath form, renamed all the fields (unique names),
assigned fields to groups in a hierarchical (sp?) configuration, now I want
to build the MS-Access database. It seemed logical that since InforPath was
tracking the fields and hierarchy that maybe one could get it to go one step
farther, so ...

Is there any way to print out the "schema" I just built in InfoPath?

Is there any way to generate the MS-Access db using the info from InfoPath?

 

[Adrian]

Hi Tom,

I'm also somewhat new to InfoPath, and I've never tried what you're doing
there, but - an "xsn" file (which InfoPath files are) is basically just a
collection of files, like a zip archive. From memory, if you change the
extension to .rar (I just tried it with .rar and it unzipped fine) you can
unzip the files and access them individually.

I'm not sure which file you'd want - myschema.xsd maybe? I don't play with
the individual files myself, that's for the deep InfoPath guru's!

HTH,
Adrian

:

 

[S.Y.M. Wong-A-Ton]

You've worked the other way around. It is much easier to first create
your Access database and then bind it to a new form (using "New from Data
Connection"). InfoPath will generate the schema automatically for you.

To view the schema, use "File > Extract Form Files..." and look at the .xsd
files.

It might be possible to create an Access database from an InfoPath schema,
but you'll have to build your own tool to do this.

 

[Tom]

I probably was not clear in my original question. I was trying to get several
questions answered with one post.

The most important question I had, aside from trying to re-create the schema
in MS-Access, was trying to figure out how to "link" the InfoPath to
MS-Access. Any ideas?

 

[Tom]

I forgot to add that the MS-Access database is located in a folder
(directory) in which I have read/write access and I have "admin" rights to
the database