The OP stated "I want to make a report to let user export data from SQL Server database" so why not consider SSRS?

We use the Access runtime on a terminal server as the front end, with a SQL Server back end. Each of the 100 users has their own copy of the...

Can you post the DDL for the table, also the update statement?

Access requires a primary key on any table that you intend to update or delete.

Can you post the DDL for the SQL table, including the keys, indexes, and grants?

Instead of trapping the error when it reaches the database, you should consider adding form-level validation. For example if your field MyText is required, in your OK button click you...

I don't think that requerying the form will fire the Form_Load event, so the open args will always be null. To test that, set a breakpoint at the "If Not...

We also have an application presently using Access with SQL Server. We use the Access runtime on a Windows terminal server, and each user has a folder with their own...

I've never used the Upsizing Wizard, but about 10 years ago I used the SSMA, SQL Server Migration Assistant, which did a fine job of moving the Access tables into...

Here is an article that describes how to create an audit trail in Access:
http://www.wvmitchell.com/tips/Change_Tracking_in_Access.html
HTH

If you are using a saved query for your pass-through, you could do something like this:
CurrentDb.QueryDefs("my_query").SQL = "EXEC StoredProcedureName Parameter1 Parameter2 ..."

Since you also want to export...

One more version, using a "single" select statement 😉

SELECT TOP 100

CASE

...

I used the SSMA back in 2008 to convert an Access 2003 db to SQL Server, it worked quite well.

The only issues were that, typical of an Access app, many...