InfoPath Dev

Well, It looks like I have solved my own problem. I changed the ID field in SQL server to be an 'identity' field. This meant that both primary and foreign keys were optional_int type. It now works fine. Seems that the import from Access to SQL server is not as effective as it could be. -- Jay Whittaker --

Another update, I created an entirely new form linked to the database. It seemed to work when adding a totally new item (ID field is auto-generated), however when adding a new item to a list of items that already exist, the ID field remains blank. I checked this on the SQL server and the ID field does not auto generate. I cannot change the ...

I am not sure what you mean by roundtrip. But it is mentioned in the Microsoft developer network that Infopath has a limitation. It only likes text (char) field up to 255 characters. Nothing more. It didn't seem access specific. -- Jay Whittaker --

I have now changed my source database and remade the database connection, however the field attributes still show as Optional_int. I would think that this is ok, but its worth a try. I find it strange that two microsoft products are so different. SQL server changes the data types of the original access database and infopath needs its own rules and ...

I tried that (go to next error) to get more detail. It tells me that in the ID fields (the fields that I use to link the tables) that only integers are allowed. The data type in the connection is recorded as optional_int, the type in the database source is int (length 4). This should work. I am not sure where this is coming from. I had it working ...

I have a form with a data connection (to an Access database with 7 tables). I cannot submit the form if I add an item with fields that are not in the 'main'/'primary' table. I can change and submit data from the main table (any time), and in fields that link to other tables - (if there is data already there). However when I add a new item (new ...

No details. Just says an unspecified error has occured and that infopath only supports Microsoft SQL server and access databases. You might be able to tell that I am feeling my way a little bit with this. So since this problem I have been trialling a workaround where I put the database on Microisoft SQL server and create a custom page in ...

Just want to clarify. The web server is a windows sharepoint server, the document is stored in a document library. I thought it should be possible that if I am submitting forms to a sharepoint form library, I should also be able to populate and submit data in those forms to a database stored within sharepoint. -- Jay Whittaker --

I get an 'unspecified' error when trying to create a data connection to a file on a web server. -I get to the window where I can select the database file to connect to. -I enter the address:http://[server]/[folder]/[filename].mdb -It opens the a window that allows me to select a table to connect to -When the table is selected it gives me the ...

Yes, I am doing a similar thing. Info path can allow users to fill out a form, submit it and automatically forward to management for approval. The manager approves it and the form is sent to a database (or sharepoint form lirary) on submission. The dynamic web site can then display the data. Different views can be achieved by having different ...