Sorry, One more question: The input for the records are done from the queries. If I do a link to the sql server, could it work that way. Can the input still be done in the query part of access and not in the adp? "Dee" wrote: Michel, Thank you. You have been of great help. I will forward this information to my manager so we can decide which way to go. If I have

Another questions: Can more then one person work on the database from Access and how does it update the SQL database with the new records in Access? Thanks Dee "Dee" wrote: Hopefully only one more question. When I click on the upsizing wizzard, choose my tables, then choose validate, etc., then choose link SQL server tables to existing application. When this is complete which

If I upsize using the link option in Access 2003, when I input new data into the database where is this done from Access or SQL? Thank you Dee "Michel Walsh" wrote: I don't know how they do it from the web, so I cannot pronounce myself on any web-part or involving the web, sorry, but from an Access application, yes. Access can store data in an mdb or in other (updateable) data

Thank Michel. I had tried that and it seems to work with no errors. In this manner the web content people will not have to learn anything different is that so? Again Thank you Dee "Michel Walsh" wrote: Basically, yes, the front end can still be in Access with a back end not another mdb file, but MS SQL Server. I am not sure about Access-Web thing, though, but as far as 'plain'

Are you stating to upsize the database using the link option? Will this still have the access front end, because we do not want to train the web content developers sql. We would like for them to view and populate the tables and queries the same way they do now. Thank you Dee "Michel Walsh" wrote: Update only the data portion. In your Access application, as an-mdb, not as an