Score of 13
How to resolve "You cannot install the 32/64 bit version of Microsoft Access Database Engine because you currently have 64/32 bit Office"
The OP likely prefers installing "ACEDB driver 64-bit" next to the other 64-bit Microsoft program.
In my case, I had "Microsoft 365" 64-bit (Microsoft Offic 365) installed, and I ...
- reputation score 2821
Score of 8
Opening mdb files in Ubuntu
You can use DBeaver. It has "MS Access (UCanAccess)" driver to open .mdb files.
To install:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
sudo dpkg -i dbeaver-ce_latest_amd64.deb
...
- reputation score 139
Score of 7
Accepted
How to resolve "You cannot install the 32/64 bit version of Microsoft Access Database Engine because you currently have 64/32 bit Office"
Are there any workarounds I can try to get one of these to install?
This is a relatively easy problem to solve.
Uninstall Office using the automated tool
Reinstall Office 2016
Run the following ...
- reputation score 44749
Score of 5
Opening mdb files in Ubuntu
On Ubuntu 18.04 I tried installing mdbtools-gmdb but it couldn't find the package. I ended up installing mdbtools with apt install mdbtools.
This package provides libraries to connect to mdb files as ...
- reputation score 331
Score of 4
Access crashes when opening linked table via MySQL ODBC driver
It is a bug in the connector version 8.0.27 which will be fixed in 8.0.28
https://bugs.mysql.com/bug.php?id=105503
As 8.0.28 is not yet released, I downgraded to 8.0.26 which seems not to suffer from ...
- reputation score 1447
Score of 3
Accepted
Adding a filter to an Access Form
Yes, this is possible.
You may find this described in the Microsoft Support article of:
Enable users to find a record by selecting a value from a list.
The article describes how to create a list box ...
- reputation score 503653
Score of 3
Repair an Access database from the command line
You may try these VBA code lines to repair Database in different situations.
Syntax to Auto-Repair:
acCompactRepair "C:\Folder\Database.accdb", True
You may try this also:
Launch Access,
Open the ...
- reputation score 9427
Score of 3
How to fix 'Microsoft Access can't be started. Microsoft Access was unable to initialize the Windows Registry'?
The issue for me was because the Microsoft Access Database Engine 2016 had been installed alongside power BI desktop client or the Power BI Report server automatically (not sure which one), and the ...
- reputation score 131
Score of 3
Accepted
What's the install location for the Microsoft Access Runtime?
What's the install location for the Microsoft Access Runtime?
It depends on 2 things, 32 or 64 bit and the version number.
The default locations are:
32 bit C:\Program Files (x86)\Microsoft Office\...
- reputation score 164469
Score of 3
How to unroll a row in Excel, to have a better view for editing?
Here is how to add a VBA macro that will show a
Data Form
for the current row.
In Excel
Show the Developer tab
Save the workbook as a macro-enabled .xlsm file (not .xlsx)
Go to the Developer tab
...
- reputation score 503653
Score of 2
Accepted
Select cell value not the whole records
With the cursor inside the field, press Home to move the cursor to the start of the data (if it isn't already), then Shift+End to select the entire content.
For fields containing integer data or text ...
- reputation score 937
Score of 2
How to have MS-Access Query Builder return results from multiple "Not Equals" Criteria?
The problem is when you want to use MS Access's Query Builder to perform a search based on multiple 'not equals' values. The solution makes sense, but it seems counter intuitive. Also, I know that ...
- reputation score 31
Score of 2
Accepted
Counting pairwise combinations from many options in Excel
This is quite simple to do in Excel with a formula that operates on your pivot table.
With the two tables set up like this
enter the following formula in J2 and ctrl-enter/copy-paste/fill-down&...
- reputation score 4427
Score of 2
Accepted
Better to use 1 or multiple database tables?
I'd recommend reading up on database normalization. It should shed some light on how you can lay out your database.
For example: a single lake probably always has the same name and coordinates. Why ...
- reputation score 58813
Score of 2
Accepted
Can I connect 64-bit MS Access to a 32-bit ODBC driver?
Is there any way to use a 32-bit ODBC driver with a 64-bit application?
No.
You absolutely cannot mix 32bit application and 64bit driver (or
vice-versa).
Basically, an ODBC driver is, ...
- reputation score 164469
Score of 2
Accepted
Scroll only one section of form in access
You can add forms as sub-forms to other forms. Just drag and drop a form from the navigation pane to the main form being in design view.
Set the properties of the sub-forms Record Selector = No and ...
- reputation score 410
Score of 2
Accepted
MS Access DB Instance getting corrupted when put on shared server
While Access databases are capable of working for multiple concurrent users from a shared drive, this has been known to cause corruption.
Corruption in shared Access databases has been known to be ...
- reputation score 75860
Score of 2
Accepted
Is there a simpler way to input into a multivalue field in Access?
I would strongly suggest avoiding using multivalue fields in MS Access: they go against database normalisation rules and furthermore you cannot easily access or filter the data they hold as you might ...
- reputation score 937
Score of 2
Error: Characters found after SQL Statement
Just drop the SELECT statement. It is of no use here.
INSERT INTO VersionReleases
(CurrentVersionID, PreviousVersionID, ScriptID, ReleaseDate)
VALUES
(555, 556, 1543, 2018);
- reputation score 410
Score of 2
Accepted
Autohotkey to conditionally ignore native keystroke
You can just use SendInput to do what you want here.
A lot of my own keys are setup that way. Capture some keystroke, check a condition and handle it or let the keys "pass through" using SendInput
...
- reputation score 66
Score of 2
How to resolve "You cannot install the 32/64 bit version of Microsoft Access Database Engine because you currently have 64/32 bit Office"
If you have 32-bit version of Office, you need to remove the 64 bit version Click to Run. Do the simialr things if you have 64-bit version of Office.
To uninstall Office 16 Click-to-Run Extensibility ...
- reputation score 757
Score of 2
Accepted
Microsoft Access: Query to delete duplicate data but keep most recent
Not the most elegant, but you can try:
DELETE FROM mytable tb1
WHERE
(Date NOT IN (SELECT MAX(Date) FROM mytable WHERE ID=tb1.ID)) AND
(tb1.ID IN (SELECT DISTINCT id FROM table1));
- reputation score 21097
Score of 2
MS Access keeps stealing focus from VBA
Finally, I've found a solution.
In recent versions of MS Access (my reading indicates at least as far back as 2007) it defaults to refreshing any open forms every 60 seconds. This can be disabled ...
- reputation score 21
Score of 2
How to unroll a row in Excel, to have a better view for editing?
I haven't read any comments mentioning the built in Excel data form on the Data tab, Data Entry group. Alt A Y 2 keys in Windows.
Formulas are read only, cell protection is maintained; however, there'...
- reputation score 276
Score of 2
MS Access replace function is not giving the expected result
Apologies, looking with fresh eyes I noticed an extra space.
stDigitalFolderLocation = replace(stDigitalFolderLocation, "\\ ", "\")
should be:
stDigitalFolderLocation = replace(...
- reputation score 51
Score of 1
Accepted
date without dashes and colons ms access + can date be part of autonumber?
To obtain the date format described in your question, use the Format function with the following arguments:
Format(Date(), "ddmmyyyy")
e.g.:
?Format(Date(), "ddmmyyyy")
08062019
Whilst you can ...
- reputation score 937
Score of 1
Can I connect 64-bit MS Access to a 32-bit ODBC driver?
Yes it is possible to connect using ODBC
I would suggest looking at an ODBC Bridge that would convert the ODBC connection from 32bit to 64bit
but the solution i have seen does cost around £1800
- reputation score 11
Score of 1
Transposing columns and values to a key column Microsoft Access
I don't know the SQL used in Access, but in standard SQL this would look similar to:
select Item, 'Part A', PartA
from Table
union
select Item, 'Part B', PartB
from Table
union
select Item, 'Part C', ...
- reputation score 503653
Score of 1
Accepted
Microsoft Access 2019, One to One relationships (SuperType -> SubType)
You would like to be able to store a row in a dependent table in a
foreign-key integrity constraint and that this will automatically create
the parent row. This cannot work because:
A store in the ...
- reputation score 503653
Score of 1
Power BI data refresh timeout
That seems a redundant architecture which may be the root cause of your timeouts. I would always connect Power BI directly to SQL Server.
In the Query steps, move your Filter, Group By or Remove ...
- reputation score 2632
Only top scored, non community-wiki answers of a minimum length are eligible