Super User Stack Exchange
Super User Stack Exchange

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.

764 questions
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
  • 1
  • 2
  • 6
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
  • 723
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
  • 228,104
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,119
  • 2
  • 12
  • 33
5
votes
4 answers

How to make database accessible for multiple users?

I have database for my desktop application, a billing application. I want that database shared so it can be opened by multiple users, but I currently get an error message like "database has been opened exclusively by another user or you not have…
Yusan Susandi
4
votes
1 answer

Why do "yes/no" values in Microsoft Access map to -1 and 0?

The use of -1 puzzles me. I would have expected the values to be: NO --> 0 YES --> +1 Is there an historical reason behind the use of -1 instead of +1?
Ale
  • 756
3
votes
1 answer

In MS Access, how can a form provide a drop-down populated with data from a related form?

In my MS Access database, I want to create a form to fill out a new order. I have a table Customers and a table Orders **Customers** => (id, firstname, lastname, address) ^ | **Orders** => (customer, product,…
CodyBugstein
  • 1,575
3
votes
1 answer

Microsoft Access force override table row ID

I have a table with a missing record, when I recreate it (18) the new id is 127 because it's autoincrement. When I go to change the row id to 18 (and there is obviously no row with the id 18) it doesn't allow me to change it. I've attempted to…
user312854
3
votes
2 answers

How do I add a link to a macro to the Quick Access Toolbar

I am trying to add a button to run a macro in Access 2007 to my Quick Access Toolbar (QAT). In Excel 2007, I have never had an issue. In the Customize Quick Access Toolbar window I can select Macros from Choose Commands From and then all my…
thornomad
  • 136
  • 6
3
votes
1 answer

One page per record

I am trying to print each report on just a single page but have no idea as to how should I proceed. Let me explain:- As seen from the report, Allan and Danny is now appearing in a single page but my requirement is only for one individual to appear…
Chris
  • 123
3
votes
1 answer

Format text to 5 chars from a number

In Access, I used a query to sum some numbers and appended the answer to another table (table 2). Now I need to export the number as string with five positions, but I can't seem to get it to hard code all five positions. I have it formatted as text,…
Wheelersg
  • 31
3
votes
1 answer

MS Access or MS Excel many to one

I have a data sheet that looks like: Name Field1 Field2 Field3 Field4 John Doe AAA BBB CCC DDD John Doe AAA BBB CCC EEE John Doe AAA BBB CCC FFF I want it to look like: Name Field1 Field2 John…
Kelli
  • 31
3
votes
3 answers

How do I delete the contents of a selection of cells in Access 2010?

In Access 2010, if I select a subset of the cells in a column, the Delete key does nothing, and there is no Delete item on the context menu. Is there some trick to clearing the contents of a selection of cells in Access 2010, or is this a glaring…
raven
  • 5,365
3
votes
1 answer

How do I link data from an Access query into Excel?

I have a large amount of data that I want Access to query and not bring everything into Excel. How do I save the query from Access so that Excel will recognize it as an external source?
user48102
  • 31
1
2 3
…
14 15