After Learning Microsoft Access and VBA for the past 3 years, now I have decided to link via ODBC to an SQL server database for better performance. I am new to SQL and I have a strong desire to learn it quite fast...
I have 2 questions:
First: I want a field named "Société" in a table named "FactureMERCURYToutes" to have as a default value, the field "Société" from the table "Corporation"
I read that a trigger could be best way to achieve that, can someone give me how the fields mentioned above could be written, it does not need to be a trigger.
Second: My first goal when I have decided to link to an SQL server database is that many of my customers which to have 3 to 10 users to create orders simultaneoulsy, Access security is not as stong as an SQL database also.
However, I try to connect 2 computers and create 2 orders at the same time and I received this message:
Do I have to set something in SQL Server 2012 Express to allow multiples connexions?
Thank you all for your time