Nowadays, if you see in job advert, you will see a common requirement is "Must be Strong in .Net (VB or C#) or java or etc..
Some might think that Access is a outdated programming.
For me, it is still good enough to run small business.
Let me share an error when I developed a access frontend linking to SQL backend.
Error
"The multi-part identifier "A....." could not be bound"
I checked table field and found nothing wrong.
If so, why?
I use alias for tables.
How to solve?
If your query is in Access 2003, just add single quote like '...'
If your query is in SQL, just add square bracket like [...]
Some might think that Access is a outdated programming.
For me, it is still good enough to run small business.
Let me share an error when I developed a access frontend linking to SQL backend.
Error
"The multi-part identifier "A....." could not be bound"
I checked table field and found nothing wrong.
If so, why?
I use alias for tables.
How to solve?
If your query is in Access 2003, just add single quote like '...'
If your query is in SQL, just add square bracket like [...]
