Stack Overflow
Stack Overflow

Questions tagged [ms-access-2010]

Microsoft Access 2010 Personal Relational Database Management System.

Microsoft Access 2010, also known as Microsoft Office Access 2010, is a rapid application database development tool.

Office 2010 will reach its end of support on October 13, 2020. If you haven't already begun to upgrade your Office 2010 environment, Microsoft recommend you start now. MS Access is a member of the MS Office suite of applications, included in the current Office 365 edition. Applications built with Microsoft Access 2010 can be distributed to end users with a free runtime version of the application that lets them view databases without needing the full installation of Access.

MS Access 2010 commonly uses the Jet or ACE database engine, but is not limited to these.

Please tag your question ms-access-2010 so others know what version you are using. Tag your question with access-vba if your question involves MS Access VBA.

Office 2010 end of support roadmap

Microsoft Access 2010 Runtime download

6039 questions
56
votes
2 answers

Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb

It has been a good number of years since I did some programming with Classic ASP and Microsoft Access where we used "Microsoft.Jet.Oledb" driver to access and display the data. I have been asked to do some work with accessing MS Excel data using…
RT88
  • 659
  • 2
  • 6
  • 9
43
votes
5 answers

Is it possible to pass parameters programmatically in a Microsoft Access update query?

I have a query that's rather large, joining over a dozen tables, and I want to pull back records based on an id field (e.g.: between nStartID and nEndID). I created two parameters and tested them as criteria and they work fine. The issue is, I need…
Jav
  • 543
  • 1
  • 4
  • 10
23
votes
1 answer

MS-Access Debug Watch value length is limited

I am working in MS-Access 2010 and I am trying to view a variable defined in the VBA code where it has hit a break-point. The problem in the watch window the value text box in the Watches window has a set size, in other words if the value is to long…
Mark C
  • 610
  • 2
  • 5
  • 15
21
votes
7 answers

Access database engine stopped the process because you and another user are attempting to change the same data

We recently Migrated an access database onto a SQL server. Upon completion we began testing the database using the front end access database we had (Our previous setup involved two access files, one for front end and one for back end.) We almost…
ChettDM
  • 325
  • 1
  • 3
  • 10
19
votes
3 answers

How to open Form in Add record

I have a form to input records to a table. I would like it to open on an empty add (New) instead of displaying the first record of the table. To be used by a Navigation Form which opens the input form from a button.
Tom Gross
  • 191
  • 1
  • 1
  • 5
17
votes
3 answers

Access 2010 VBA query a table and iterate through results

I have a query that I want to execute against a table. With the results I want to do something. In my head the pseudo code is: var q = "select * from table where some condition"; var results = db.getResults(q); foreach (row r in results ) do…
Sally
  • 1,749
  • 7
  • 31
  • 39
14
votes
7 answers

How to disable access security notice "A Potential security concern has been identified"

i have a shared access application, i created an accde file for 32-bit machine, when user open the application he/she getting a security warning is there any way to disable this message from appearing to the users thank you
Noora No
  • 309
  • 1
  • 4
  • 10
14
votes
4 answers

Updating an SQLite database via an ODBC linked table in Access

I am having an issue with an SQLite database. I am using the SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ Installed the 64-bit version and created the ODBC with these settings: I open my Access database and link to the datasource. I can…
Herrozerro
  • 1,601
  • 1
  • 22
  • 37
14
votes
5 answers

Import Ms Access Data by programmming

I am in search of an good approach to import data from ms access and bind it to any Model of an MVC pattern Here is the approach which we are thinking to following Approach 1 : Open Ms Access file Open database Open all tables Import data of all…
Swapneel Kondgule
  • 842
  • 8
  • 27
14
votes
1 answer

How do I create a passthrough query in access using a DSN-less connection?

I'm using DSN-less connections to my SQL Server in an Access database. However, whenever I try to write a "Pass-Through" query and run it, a dialog box pops up asking for the DSN.
Brett G
  • 349
  • 2
  • 4
  • 20
13
votes
3 answers

MS Access Link Table With VBA

How can I link a table from one MS Access Database (*.mdb or *.accdb) to another Access database in VBA? Basically I just was to use VBA to replicate what the External Data wizard does. I've googled this and I see many examples of how to update or…
Mark
  • 1,277
  • 3
  • 13
  • 27
13
votes
8 answers

Command Button Wizard doesn't start

I want to create a navigation button on a web form. (I use MS Access 2010 - Web database). I dragged the button on the form (the Control Wizard option is selected) but the Command Button Wizard does not show up I double clicked on the button, but it…
fn27
  • 819
  • 2
  • 10
  • 18
12
votes
2 answers

Access 2010: Syntax error (missing operator) in query expression

I want to have three tables in my sql query but I get an error message. I have this sql code: SELECT warehouse.expiry_date, pharmacy.expiry_date, drugs.active_substance, drugs.strength, drugs.strength_type, drugs.dosage_form,…
zinon
  • 4,427
  • 14
  • 70
  • 112
11
votes
2 answers

FileDialog doesn't work

I've looked quite intensely, but couldn't find a post that directly solves my problem. The following code for a form I created works in Access 2003, which I use at work. Dim FileName As FileDialog Set FileName =…
Emily
  • 145
  • 1
  • 3
  • 9
11
votes
3 answers

How to simulate UNPIVOT in Access?

UNPIVOT is available in MS SQL-Server 2005, but AFAIK not in MS Access 2010. How can it be implemented with on-board means? For example, I have a table ID | A | B | C | Key 1 | Key 2 | Key 3 --------------------------------------- 1 | x | y | z | …
Andreas Spindler
  • 7,568
  • 4
  • 43
  • 34
1
2 3
…
99 100