Questions tagged [ms-access-2016]

Microsoft Access 2016 is a database management system and application development tool.

Microsoft Access 2016 is a database management system and application development tool. It is included in some versions of "Microsoft Office 2016" and "Microsoft Office 365".

For more information on Microsoft Access, see http://en.wikipedia.org/wiki/Microsoft_Access

For more information on new features in Microsoft Access 2016, see: https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496

Access Development - MSDN - Microsoft: https://msdn.microsoft.com/en-us/library/office/fp179695.aspx

1477 questions
-3
votes
1 answer

How to store/download a Microsoft Access file in/from a server, with vba in another MS Access program

I have a Microsoft Access Database connected to a SQL back-end. At the moment the Access program checks it's version (saved as const variables) against the latest in a SQL table called Versions, and wont open unless it's the right version. To update…
Tristan King
  • 438
  • 4
  • 17
-4
votes
2 answers

Where is code I get in MS ACCESS in MDB or MDE file extension

I m newly to the MS access, I didn’t getting where is the code see and edit. So I can login to my application. When try open the my application in .MDE in MSAccess I am getting authorisation error-> your login is unauthorised please try again…
-4
votes
2 answers

Compact the current database

Compact the current database, without closing it? Access 2016. VBA. As a friend said, you need to press to compress or restore database on the tape.
Makine
  • 1
  • 2
-5
votes
2 answers

MS Access query required

I have data in a table "customer" like ID NAME CITY 11 John A 12 Peter B 13 Robin A 14 Steve C 15 Methew D 16 Matt C 17 Nancy C 18 Oliver D I want the query that only shows the data for every 2…
Kashan N
  • 7
  • 4
-5
votes
1 answer

System.Data.OleDb.OleDbException: 'Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.' in my Accounting Project

I'm making an Accounting project in C# Visual Studio 2017 and I have three forms: Login Main Product Entry 1st and 2nd form work properly, but when I clicked the button of Product Entry (3rd form), project doesn't go to 3rd form and it shows this…
R.Soomro
  • 1
  • 5
-6
votes
1 answer

Multiple table update design in Access

I have learned more, and was compelled to find the solutions, mind changed. PS dear experts, your help is appreciated in the time-saving nature of having forums and discussion in the first place, and also is mined for usefulness, not street cred.…
1 2 3
98
99