MS access language

Hi

What is the name of the language used to program Microsoft Access?

I know SQL server uses SQL but from what I remember Access used a different syntax and structure.  

thanks
CITS_UserAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupCommented:
Visual Basic For Applications (VBA)

and JET SQL for queries in access.
0
mbizupCommented:
The SQL in Access is indeed somewhat different from that used in SQL Server, but the most commonly used commands are the same or very similar.
0
CITS_UserAuthor Commented:
Thanks guys, so if I was telling someone the name of the Microsoft Access programming language would I say it was SQl or JET SQL or anotehr name?

If the terms and syntax are not identical to SQL Server surely it must have a different official name.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

mbizupCommented:
JET SQL for Access versions up to 2007.

I believe it is ACE SQL for 2010

But I would simply say "Access SQL" to make sure they understood you are specifically talking about Access.
0
mbizupCommented:
Here you go - if you want a more 'official' reference to the name:

http://msdn.microsoft.com/en-us/library/aa140011(v=office.10).aspx

This was written for Access 2000 - but JET applies up to Access 2007.

I was mistaken in my earlier comment - ACE was released with Access 2007.


The SQL is fully compatible between all versions of Access, and a summary of the history can be found here:

http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine


But to avoid confusion - simply "Access SQL" gets the point across.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
<so if I was telling someone the name of the Microsoft Access programming language would I say it was SQl or JET SQL or anotehr name?>
I would say:
MS Access uses VBA for automation, and JET SQL for queries...
0
Jeffrey CoachmanMIS LiasonCommented:
...In your question you say "Programming", which to some would imply (vba, vb6, .net, ...et al)
...but you reference SQL, which some would not consider a "Programming" language per se... (although Wikipedia does: http://en.wikipedia.org/wiki/SQL)
Another definition of SQL is a "Data Definition language".
But this subtle distinction in terms in not my strong point...
mbizup could go into this in more detail...

Just to clarify that you just said "Program" and were not specific.

JeffCoachman
0
CITS_UserAuthor Commented:
Thanks guys.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.