Others

Prevent Unicode Question Marks in Microsoft Access ADO Updates

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

Preserve Unicode text when Microsoft Access updates SQL Server data through ADO.

Prevent Unicode Question Marks in Microsoft Access ADO Updates
Product
Microsoft Access, ADO, and SQL Server
Device & OS
not provided
Scenario
An Access application builds an UPDATE statement from recordset values and executes it against SQL Server.
Observed behavior
Unicode characters are saved as question marks during the ADO update, although inserts and updates through a bound form preserve them.
Before you start

Identify the Access code that builds the UPDATE statement and check the SQL Server destination column's data type and length. Confirm that the text still contains the expected characters before the update runs.

Solution 1Recommended

Use Unicode parameters for the ADO update

Use a parameterized ADO command to send text without concatenating it into the SQL statement.

1
Check the destination column

In SQL Server Management Studio, inspect the table's column definition. Use a Unicode type such as nvarchar or nchar with sufficient length for the text.

2
Create an ADO command

In the Access VBA editor, replace the concatenated UPDATE and cnn.Execute call with an ADODB.Command using the existing SQL Server connection. Set CommandText to an UPDATE with placeholders, such as UPDATE dbo.YourTable SET YourText = ? WHERE YourID = ?.

3
Add parameters in placeholder order

Use Command.CreateParameter and Parameters.Append to add the text as adVarWChar with adParamInput and an appropriate size. Then append the ID parameter with the matching SQL data type, such as adInteger for an integer ID. Execute the command with Command.Execute.

4
Test the saved value

Run the update with representative Unicode text, then query the row in SQL Server Management Studio. If it still contains question marks, inspect the value before execution and check any conversions or triggers involved in the update.

Use Unicode parameters for the ADO update
Stored procedures also need Unicode parameters: If you use a stored procedure, declare its text parameter as nvarchar or nchar and pass it from ADO as a Unicode parameter. A stored procedure cannot restore characters that were already converted to question marks.
Free Microsoft Office alternative

Work with Office documents in WPS Office

WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations, with a familiar interface and Office format compatibility to make migration easier. It does not replace Access or fix ADO updates to SQL Server.

Edit spreadsheet data in a familiar interfaceOpen and save common Microsoft Office formats, including DOCX, XLSX, and PPTXUse a free, lightweight office suiteMove everyday document work from Microsoft Office more easily
microsoft office alternative - wps office

Frequently Asked Questions

Why does the bound form preserve Unicode when my ADO update does not?

The two update paths can send text differently. A concatenated SQL statement may convert characters before SQL Server stores them; use an ADO Unicode parameter and verify the destination column type.

Which ADO parameter type should I use for SQL Server nvarchar text?

Use adVarWChar with adParamInput and a suitable size when calling Command.CreateParameter. Append parameters in the same order as the placeholders in the UPDATE statement.

Why does a stored procedure still save question marks?

The text may already have been converted before the procedure receives it, or the procedure parameter or destination column may not use a Unicode type. Check the value in Access, the ADO parameter type, and the SQL Server nvarchar or nchar definitions.

Can I recover characters already stored as question marks?

Question marks do not retain the original characters. After correcting the update path, restore or reenter the original text from a source that still contains it.