Please be more specific. See Rule #2.

Can you tell us exactly what you mean by "it allows 10 fields"?

- Are you using the SQL Server Migration Assistant (SSMA), the Linked Table Manager, ODBC, or something else?
- Does the table in SQL Server already exist, or are you trying to create it from Access?
- Are only the first 10 fields showing up, or do you get an error when adding the remaining 5?
- If there's an error message, please post the exact text (or a screenshot).
- What are the data types of the five fields that won't link? (Lookup, Attachment, Multi-Value, Calculated, Hyperlink, etc.)
- Which versions of Microsoft Access and SQL Server are you using?

The more details you can provide, the easier it will be to figure out what's happening.

I think it is ok know, when i try to link my table sql to MS Access, when i use the file datasources, My SQL server is Microsoft SQL Server Standard Developer (64-bit), i have Microsoft Office Professionnel Plus 2019 with Microsof 365 annual susbrcription, my first language is frensh, but this cours helps me to manage my database using MS Access as a frontend, i installed the express edition.

Okay, glad you got it figured out. Usually, getting access connected to SQL Server and making sure SQL Server is set up properly is the most difficult part, and that's why I spend so much time on setup. In the future, just remember, if you need help, we need more details. You can't just say it's not working. I need to know exactly what you tried, what you did, and what it says, all those things. And you're doing fine with your English, trust me. Your English is way better than my French, lol.

Thank you everything is ok, when i have a problem i will send you the message for help, your courses are very usefull, i can manage the database using sql server and postggresql, but i have more difficulties to buil forms for entering the data for the end user in my office, i think i will do it for following your courses Access user/SQL Server.