EzDevInfo.com

What interfaces besides MS Access are available to manipulate MDB files

A few years ago I was developing a .NET application for a client that used Microsoft Access. Regardless of the merits of this technical decision, I ended up writing my own query editor for Microsft Access and SQLite files.

I have since found out I was not the only one to do so.

Please, one program per answer.

Undelete records in Microsoft Access

About 600 records in a Microsoft Access File (.mdb) have been deleted. The .mdb file size hasn't changed, being around 20 MB.

AccessFIX (Demo) shows the exact number and contents of the deleted records in its own viewer. Unfortunately the full version (which would undelete/save the records) costs around 180€.

Is there any free way to undelete deleted records?

I have already tried, with no luck in properly (if ever) undeleting the records:

• Recovery Data Access
• Stellar Phoenix Access Recovery
• Mdb Recovery
• SysTools Access Recovery
• Advanced Access Repair
• Advanced Office Repair

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?

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 named exactly the same as are the column headers.

While each file is structured the same, the information within sheet 1 and 2 (for example) is different. So it can’t be combined into one file with everything in one sheet!

I've never used VBA before and I'm wondering where I might start this task!

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.

Lining controls up very precisely

i have about 50 labels that are each just barely big enough to fit the letter x in them. the labels are on a report. i need to align all the labels very precisely.

is there an easier way to do this than trusting my eyes?

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?

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?

Why won't Access 2013 open an .mdb file?

Please not that I hardly ever use Access, so I might be missing something very obvious here, but a quick Google revealed little.

I am trying to open an .mdb file used by an in-house application, using Access 2013 Preview. This tells me "Cannot open a database created with a previous version of your application."

I have trouble just accepting that Access 2013 cannot open Access files from before Access 2007, so I suspect something else is amiss here. What could cause this issue?

The database file is not corrupt, as the VB6 application can open, read, and update it just fine.

MySQL query builder? (like Access has in Design View) [closed]

Is there any free tools that would let me build queries like one can in Access?

Should I use MS Excel or MS Access? [closed]

I want to store my students' information such as marks, etc. And I need a way to make calculations on this information. I also want the application to make it easy to fill students' information (in the beginning of the term) and to publish their marks online later on.

Should I use MS Excel or MS Access? When should I use one of them over the other?

Does MS Access 2003 contain a general purpose SQL console

I know you can open an SQL console in Access when creating a query or a view, but is there an 'all purpose' console that would allow me to execute statements like:

CREATE TABLE Foo
(
Foo_Id int NOT NULL,
Name varchar(255) NOT NULL,
CONSTRAINT pk_FooID PRIMARY KEY (Foo_Id,Name)
)

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 permission".

What should I do to resolve this?

How can I open a .mdb with a password in OpenOffice?

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open this file using Base?

How to avoid rounding numbers in MS Access 2007-2013?

I have an MS Access 2007-2013 database (.accdb format) which I open in MS Access 2013. It has just one table with several columns

Lat          Long       PositionDate    
-54.82045   -68.33834   20130825    
-54.82018   -68.33854   20130827    
-54.81958   -68.33004   20130102    

My goal is to convert this MS Access table to a text file in comma separating format. I go to External data tab > Export section > Text file. I don't specify any export options and click OK. I choose the file to be Delimited > click Next > Choose Comma > click Finish.

However, in the result .txt file I get the lat and long fields rounded to two decimals. I have looked over cell settings in Access but with no success. How do I avoid this rounding?

-54.82,-68.33,"20130825"    
-54.82,-68.33,"20130827"    
-54.81,-68.33,"20130102"    
-54.81,-68.33,"20130202"