MDB Admin Activity
A complete tool for creating and managing MSAccess databases.
Brought to you by:
marcieldeg
Activity for MDB Admin
-
Francois Masse posted a comment on discussion General Discussion
Is it possible to have a Table with a Text-based column/field setup so that the values are referenced from another single-column Table and is presented to the user as a drop-down list of values? A way to restrain the possible values for that column. I am using an old MDB file I used to work with using MS Access, and I think it had that feature.
-
Anonymous created ticket #148
Error: Access violation at address CFB08D00. Read of address CFB08D00
-
Anonymous created ticket #147
Error: Access violation at address CFB08D00. Read of address CFB08D00
-
Marciel Degasperi modified ticket #140
Error: Access violation at address 76E47859 in module 'ucrtbase.dll'. Write of address 123BC000
-
I was unable to reproduce this issue. Please note that while you mentioned a Windows 11 update, MDB Admin is running on Windows 7 Ultimate, likely within a virtual machine. In this setup, updates to the host operating system do not affect the virtual environment. If the problem persists, please open a new ticket with additional details, preferably including your database file.
-
Data
-
Error: Item cannot be found in the collection corresponding to the requested name or ordinal
-
This issue occurs because Microsoft Access does not support the FULL JOIN clause. Unfortunately, the current error message is generated by the database driver itself, so I cannot modify it to be more user-friendly. You will need to rewrite your SQL query using supported clauses. You can find the list of compatible commands in the official Microsoft documentation at https://learn.microsoft.com/en-us/office/vba/access/concepts/structured-query-language/perform-joins-using-access-sql.
-
Anonymous posted a comment on ticket #146
the code is working but the problem is its always saving on procedures instead of views
-
You can use the F9 key to run a query. Unfortunately, I don't yet have documentation for MDB Admin, but you can send your questions here and I'll be happy to help.
-
Anonymous created ticket #146
Error: Item cannot be found in the collection corresponding to the requested name or ordinal
-
toptee posted a comment on discussion General Discussion
Are there any shortcuts e.g. to run a query (F5, Ctrl+R or alt+R would be obvious)? Any documentation somewhere, could't find any.
-
MDB Admin released /No longer supported/MDBDump.zip
-
Improvements to the "View/Edit Data" mode.
-
-
-
There are three easy ways to see the information inside your tables. Choose the one that feels most comfortable for you: 1. The Quick View (Best for Beginners) If you aren't familiar with coding, this is the easiest method. It opens the table just like a spreadsheet. How to do it: Right-click on your table name and select "View/Edit Data". 2. Use a Custom Search (SQL) If you want to filter your data or see specific parts of it, you can use a "Query" window. The Manual Way: Go to the File menu ->...
-
Anonymous created ticket #145
Data
-
Upgrade keywords list
-
Error: Unspecified error
-
123
-
Hi, The file you sent is not a valid MDB file.
-
Hi, This error occurs because "position" is a reserved word in the MSAccess dialect. Try constructing the SQL query using square brackets: SELECT staffNo, fName, lName, [position], salary FROM StaffTable WHERE branchNo = 'Fatui001' You can see the complete list of reserved words at this link: https://support.microsoft.com/en-us/office/sql-reserved-words-b899948b-0e1c-4b56-9622-a03f8f07cfc8
-
Hi, This error occurs because "position" is a reserved word in the MSAccess dialect. Try constructing the SQL query using square brackets: SELECT staffNo, fName, lName, [position], salary FROM StaffTable WHERE branchNo = 'Fatui001' You can see the complete list at this link: https://support.microsoft.com/en-us/office/sql-reserved-words-b899948b-0e1c-4b56-9622-a03f8f07cfc8
-
Error: Unspecified error
-
Duplicated ticket.
-
Hi, This error occurs because "position" is a reserved word in the MSAccess dialect. Try constructing the SQL query using square brackets: SELECT staffNo, fName, lName, [position], salary FROM StaffTable WHERE branchNo = 'Fatui001'
-
Anonymous created ticket #144
Error: Unspecified error
-
Anonymous created ticket #143
Error: Unspecified error
-
Anonymous created ticket #142
123
-
Error: Access violation at address 76E47859 in module 'ucrtbase.dll'. Write of address 123BC000
-
Thank you for reporting. It seems there is a specific problem with this MDB file, as the ADOX component is unable to load the primary and unique key columns. I've created a workaround to make it possible to open the file, and I will investigate the root cause further.
-
-
-
Workaround error loading key columns - ticket #141
-
Error: Object or provider is not capable of performing requested operation
-
Anonymous created ticket #141
Error: Object or provider is not capable of performing requested operation
-
Anonymous created ticket #140
Error: Access violation at address 76E47859 in module 'ucrtbase.dll'. Write of address 123BC000
-
Thanks for reporting, I'm investigating. I uploaded the installer to virustotal.com but nothing was detected.
-
Ian Eales posted a comment on discussion General Discussion
Hello, Malwarebytes detects Malware.AI.2782206 in the 25/12/06 release of MDBAdmin_Installer. There is NO malware in the Zip -- - Ian
-
-
-
Add menu option "Describe" to tables;
-
Error: Az argumentumok nem megfelelő típusúak, az elfogadható tartományon kívül esnek vagy ellentmondásosak
-
Closed due lack of information.
-
Error: Ölçüt ifadesinde veri türü uyuşmazlığı
-
I can't reproduce this error. Please open a new ticket, attaching your database file and/or your sql code.
-
Error: Field 'field1' not found
-
I can't reproduce this error. Please open a new ticket, attaching your database file.
-
Anonymous created ticket #139
Error: Field 'field1' not found
-
Anonymous created ticket #138
Error: Ölçüt ifadesinde veri türü uyuşmazlığı
-
Error: Tanınmayan veritabanı biçimi 'C:\Users\sudea\OneDrive\Belgeler\veresiye - Kopya.mdb'
-
Closed due lack of information.
-
Error: Az argumentumok nem megfelelő típusúak, az elfogadható tartományon kívül esnek vagy ellentmondásosak
-
Thanks for reporting. I was unable to reproduce this issue. Can you send me your mdb/mdw files to simulate your exact problem?
-
Anonymous created ticket #137
Error: Az argumentumok nem megfelelő típusúak, az elfogadható tartományon kívül esnek vagy ellentmondásosak
-
Error: Несоответствие типов данных в выражении условия отбора
-
Thanks for reporting. To perform queries with DATE data in Access, you need to delimit it with the character #, as follows: SELECT [НомерАК], [препарат], [дата] FROM [Анализы_2] WHERE [дата] > #2024-10-01#
-
64 bit support
-
Thanks for reporting. The main focus of MDB Admin is to allow access to older versions of Access. These versions prior to 97 can only be opened by the jet driver, and this driver does not have 64bit versions. Therefore, it is not possible to develop a 64bit version without losing the main functionality of the application. An alternative for your specific situation is to install two close versions of the ACE driver. For example, you can install the 2010 32bit version, to work with MDB Admin, and the...
-
Error: Tanınmayan veritabanı biçimi 'C:\Users\sudea\OneDrive\Belgeler\veresiye - Kopya.mdb'
-
Thanks for reporting. Apparently your database file is corrupt. If possible, please send the MDB file for me to check.
-
Anonymous created ticket #136
Error: Несоответствие типов данных в выражении условия отбора
-
Anonymous created ticket #135
64 bit support
-
Anonymous created ticket #134
Error: Tanınmayan veritabanı biçimi 'C:\Users\sudea\OneDrive\Belgeler\veresiye - Kopya.mdb'
-
Small bugfixes.
-
-
-
How to add BMP image in OLE field
-
Hi, Thanks for reporting. Unfortunately, there is currently no way to upload an image with MDB Admin. There is very few documentation about the OLE format, so I haven't found ways to create the necessary file headers. Either way, I'll keep this ticket open and do further research at this point.
-
Anonymous created ticket #133
How to add BMP image in OLE field
-
DBPROP_JETOLEDB_COL_COMPRESSED not set w Add Column
-
I tried several ways, but each time an error occurred when trying to change this property via ADOX. I think it's a bug in this library, but the equivalent property ("Jet OLEDB:Compressed UNICODE Strings") cannot be set. The only way to add a command to configure this option would be to use some resource external to ADOX, such as an SQL command. However, this adds a layer of complexity to the application, which I intend to avoid until more similar functionality is needed. Alternatively, you have a...
-
conversione mdb
-
Grazie per la segnalazione. Per effettuare la conversione è necessario installare il "Microsoft Access Database Engine Redistributable 32bits". Puoi ottenerlo dalla pagina ufficiale di Microsoft o dai collegamenti disponibili con il progetto.
-
Anonymous created ticket #132
conversione mdb
-
-
-
Microsoft Access Database Engine Redistributable 32-bit is no longer available
-
Thanks for reporting. You can use the 2016 version without any problems. Enter the link below and select the 32-bit version when prompted: https://www.microsoft.com/EN-US/DOWNLOAD/confirmation.aspx?id=54920 I will update the main link.
-
Templayer created ticket #131
Microsoft Access Database Engine Redistributable 32-bit is no longer available
-
New option "Copy All" in properties window.
-
Ok, I got it. I'm going to do some tests, but I believe it is not possible to change this property, as well as others properties. MDB Admin uses ADOX, and this has some limitations. If it is possible, I will add the option to the columns "Edit" menu. Meanwhile, you can create columns with the instruction below: ALTER Table Movies ADD Column COUNTRY3 TEXT(60) WITH COMPRESSION
-
DBPROP_JETOLEDB_COL_COMPRESSED not set w Add Column
-
I use FlySpeed SQL Query to maintain and query the data. I added a Column w MDB_Admin to a JET database I've used for about 20 years. ALTER Table Movies ADD Column Country TEXT(60) The column is created with the DBPROP_JETOLEDB_COL_COMPRESSED flag set to FALSE and there is no way to change it in the MDB_Admin EDIT page.
-
DBPROP_JETOLEDB_COL_COMPRESSED not set w Add Column
-
Thanks for reporting. I am unable to reproduce the problem. In my tests, columns created by the table creation wizard or the column creation wizard were generated with the mentioned option. Please detail step by step how you encountered the problem. If possible, send a database file with a test case.
-
DBPROP_JETOLEDB_COL_COMPRESSED not set w Add Column
-
DBPROP_JETOLEDB_COL_COMPRESSED not set w Add Column
-
Add inno setup config files.
-
Minor fixes in translation
-
Anonymous posted a comment on ticket #129
Oh, I see, thank you. I'll give it a try.
-
Can't save
-
Corrections and optimization when exporting tables.
-
I got it. You are using "View/Edit Data" option to create the SQL code. Using this option, you cannot change or save the generated SQL, as this is a feature designed only to view table data. You can use the "Template"->"SELECT" option to create a basic SQL from the table, which can be edited and saved as needed. You can also drag the table to the editing area, and a menu with templates will be displayed. Note that the Save option saves the SQL code as a file. To save edits to the table data, use...
-
Anonymous posted a comment on ticket #129
Here are a couple screenshots. No idea why the save buttons would be greyed out, and I don't really know if there's anything that I'm doing wrong.
-
I got it. You are using "View/Edit Data" option to create the SQL code. Using this option, you cannot change or save the generated SQL, as this is a feature designed only to view table data. You can use the "Template"->"SELECT" option to create a basic SQL from the table, which can be edited and saved as needed. You can also drag the table to the editing area, and a menu with templates will be displayed.
-
I got it. You are using "View/Edit Data" option to create the SQL code. Using this option, you cannot change or save the generated SQL, as this is a feature designed only to view table data. You can use the "Template"->"SELECT" option to create a basic SQL from the table, which can be edited and saved as needed.
-
Can't save
-
Thanks for reporting. Could you please send a screenshot of this problem? In my tests I was unable to reproduce what you reported. See image below. However, I identified another issue when saving edited SQL files, which was fixed in version 2.5.11.830.
1 >
