Access does not have linked tables with windows authentication.

If I am correct, Access will link to SQL server using one SQL Server login where the credentials are stored when...

That makes sense. I am liking the stored procedures.

thanks for the help.

so does that code not update the fields in the DB table if the parameter sent to the stored procedure coming from the web form is blank? if so, ...

The reason I wanted to use dynamic SQL was to avoid making and running up to 14 seperate updates depending on which fields were completed on the web form. With...

I'm moving the code from front end to backend as stored procedure. I'm building these strings but they will not be vulnerable to SQL injection because the are parameterized.

what...

Fantastic. I'll toggle the setting and be on my way. Thanks for the assistance.

The problem with not having a save button on each page is that of the 12 pages multiple people may fill out the information. For Instance:

Person 1 - fills pages...

OK, So I was wrong about stored Procedures. They sound very much like the thing to use. How though do I code them if queries require parameters from the front...

Andrew,

That is what I'm planning to do. I'm moving my data from access to the SQL server used by sharepoint. I'm then going to build my web applications using vb.net...

SSC Rookie,

Does that hold true if I'm accessing the SQL server from a .net application? I would think that I'd need to specify a connection string for each server and...

Your right I could redesign some of the backend structure but then I might give the DBA a nightmare of a redesign with regards to the forms, queries and reports...

I guess I've been lucky. I've been using Access Since 1997 and have yet to find a request for data that I couldn't handle with Access's query builder.

Thanks Andrew. I am learning to use SSMS and find it managable, but coming over from Access, there is a bit of a learning curve as I shift my thinking...

What I was looking for was a visual interface much like visual studio is to .net. Sure I can write sql if I have to... but why do it if...

The one cavait to creating a better structured DB in SQL server is that the Access databases contain many years worth of historical data which I do not want to...