Super User
Super User

Questions tagged [microsoft-access]

Microsoft Access is a rapid application database development tool.

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server and MySQL, can also be used as a database server back end for Access applications. Access also has a Visual BASIC for Applications programming language (VBA) Questions involving coding with VBA should be asked on stackoverflow.

773 questions
33
votes
6 answers

Opening mdb files in Ubuntu

I have an MDB document that I need to view on my Ubuntu machine, I downloaded MDB viewer and when opening the file with it the application closes. Also OpenOffice DB viewer does not want to work. Are there any other applications that I can use?
Elitmiar
  • 3,272
19
votes
2 answers

Connect to an MS Access Database from SQL Management Studio

I want to connect to an MS Access 2003 DB from SQL Management Studio 2005 so I can run queries on the Access DB from SQL Management Studio.
John Oxley
  • 737
15
votes
5 answers

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The corresponding worksheets from each Excel file are…
lalabeans
  • 153
11
votes
2 answers

Remove the password from Microsoft Access file

I have an mdb file on my computer, but unfortunately I have forgotten my password, so I can not open it now. Is there any way to remove this password or some other way to open this file?
kamiar3001
  • 113
11
votes
4 answers

MS Access vs MS SQL Server

These are two offerings from Microsoft - MS Access and MS SQL Server. What type of users/uses is Access meant for? Apart from the degree of usage (in terms of number of users), are these two products the same?
Moeb
  • 834
11
votes
3 answers

How to resolve "You cannot install the 32/64 bit version of Microsoft Access Database Engine because you currently have 64/32 bit Office"

Got a bit of chicken and egg here; if I try to install Access Database driver 64-bit version, I see: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office products installed. If you…
Caius Jard
  • 494
10
votes
12 answers

Why does Access report it can't receive a command to its program?

I just upgraded to Windows 7, and when after reinstalling my MS Office, I have an interesting error. When I click on a database, I get a popup message "There was a problem sending the command to the program", but the file application will still…
Noah
  • 2,657
10
votes
3 answers

Open SQLite db in Microsoft Access?

Are there any tools to allow using sqlite databases from Microsoft Access? Of course full access is preferred, being able to edit records, add tables & fields, etc. but read-only browsing would helpful too. I'm using Access 2007 x64.
matt wilkie
  • 5,324
9
votes
3 answers

Compare two Microsoft Access databases

I have two Access databases that I need to compare but I don't know how I can do this. I'm trying to compare the differences between both the structure and content (possibly limiting the comparison to tables and queries). Is this possible?
Toc
  • 1,821
9
votes
1 answer

How do I view system tables for a `.MDB` in Access 2010?

How do I view system tables for a .MDB in Access 2010?
H.Lam
  • 95
9
votes
7 answers

ms-access: is it possible to zoom in design view?

does anyone know if there is an option to zoom in design view in access 2007
Alex Gordon
  • 743
7
votes
3 answers

What is the easiest way to edit an Access database online?

Problem: In our office we have an Access customer database that is about 20MB big. People mostly use it from within the office's LAN, but some other team members are external and they currently have the following workflow: Ask somebody in the…
slhck
  • 235,242
5
votes
1 answer

MS Access 2010 compacts on close. How to prevent?

I have an Access 2010 application that runs on a busy network (separate front/back ends, same version of Access). Lately when I close it, the compaction utility runs. It's just as if the option was checked for "compact on close." But that option…
Smandoli
  • 157
5
votes
1 answer

Get date from a datetime in access

In access query ,I only need to get the date 01/01/2012 for example from the following : 01/01/2012 9:18:35 AM how can this be done?
Scorpion99
  • 1,149
  • 3
  • 12
  • 33
5
votes
4 answers

Active content security warning in all files

Every time I open a *.mdb or *.accdb file I get the yellow Message Bar with a text in Spanish that translates as: Security Warning: Some active content has been disabled. Click for more details. ... and a button labelled «Enable Content». Here's a…
Álvaro González
  • 1,573
1
2 3
…
51 52