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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 04 Oct 2006 22:18 GMT

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?

Reply to this Message

Adrian - 05 Oct 2006 00:54 GMT

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

> 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?

Reply to this Message

S.Y.M. Wong-A-Ton - 05 Oct 2006 07:00 GMT

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.
---
S.Y.M. Wong-A-Ton

> Hi ... I am new at InfoPath but have 8 years experience programming and
> building MS-Access backends.
[quoted text clipped - 8 lines]
>
> Is there any way to generate the MS-Access db using the info from InfoPath?

Reply to this Message

Tom - 09 Oct 2006 14:49 GMT

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?

Reply to this Message

Tom - 09 Oct 2006 14:53 GMT

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

Reply to this Message