InfoPath Dev

 I am new to this, so please bare with me.

Want to:

1. Create a from in infopath to person to fill out, where some of the information is then stored in MS Access predefined tables.
2. Bring up form (later) in Infopath, where some of the fields are filled in by previous input from data stored in MS Access.
3. Convert information in a certain format to a PDF file from either Infopath or MS Access - which ever is easier.

Got so far: I created a table (MEDICATION) in MS Access with these columns - MED_ID, MED_CLASS, MED_G_NAME, MED_VEN, MED_P_NAME

I then opened Infopath and linked it to database in MS Access; I picked from the available tuples an inserted into form, then saved.

I then opened form to fill in data. but when I hit submit, I get error that access is denied.

What am I doing wrong?

Thanks

Hello,

Are you trying to submit the in network machine or local machine? Do you have permissions to access that machine and database? Check once user permissions to that database?

 Hi Shiva,

 I am creating this on my PC. Signed on as Admin. Should have permission and all access to everything, so I am not sure why I get this error. I got this error on both my laptop (WIN XP Pro sp3) and Main (Vista Business sp1).

I am just trying this out, so the database is local in access and I see the colums I created there, and able to pick and drap/drop into Infopath. But when I try to fill the form and submit - error.