The Access Wizard Upsizing worked great. It converted the tables, forms and most of the queries. I have one big problem and one minor issue.

Problem: When I use the newly created application I cannot change or add records to my new SQL tables. I get a message on the Access form that the table cannot be changed. I don't know whether this is on the Access or SQL side.

Minor Issue: Not all of the queries were converted. Where and how do I address that issue?

Oh, I almost forgot. I know very little about Access, but am more comfortable with SQL queries.

You'll need to make sure, on SQL Server, that the user that is reading the tables has read/write access to those tables or database. This isn't because of access, its something you would have needed to do anyways. Give that a shot, and if it still doesn't work let me know. If you are unsure hot to set permissions, either submit a support ticket, or come back here for some help.

Jason,

We set up the security for the SQL db, but same result. The error I am getting on the Access form is "this recordset is not updateable".

I hope we're getting closer.

Not sure I understand, are you sure you are querying the SQL server data source, and not the access data source? That error doesn't sound like an SQL Server type error. Sounds to me like you are still hitting the access data source which is why its throwing an access-like error.

Jason,

I forced some values into the SQL table. Then went back to the Access app. I am getting the SQL table data, but a funny Access error still.

Still searching ??????

Do you have a link where we can see the error? or post some code of the page causing the error?

Jason,

I hate to sound so basic, but how do I see the code behind the form?

You might try checking you SQL Statements. Try adding the Primary key of the main table to the statements (if you can). Access some times needs it to make a record set updatable.

If that does not work check to see if the Access ldb file is still on the server when there is no activity. The ldb file is the weak link for Access tables, especially on a web site. Access was really designed as a file sharing database, not client / server. You may need a routine to delete ldb files.

The error you are getting is a common Access error. It's caused by incorrect permissions on the folder containing the database file. You will need to contact support to have them assign the appropriate permissions (write access for the web server user). Once that's done you should be good to go.