Bug 53080 - FILEOPEN: MS Access Template 'Unrecognized database format'
Summary: FILEOPEN: MS Access Template 'Unrecognized database format'
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.0.0.0.alpha0+ Master
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Database-MS_Access
  Show dependency tree / graph
 
Reported: 2012-08-03 04:39 UTC by John Smith
Modified: 2017-10-23 21:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Microsft Access Templates (1.94 MB, application/zip)
2012-08-03 04:40 UTC, John Smith 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description John Smith 2012-08-03 04:39:18 UTC 
Problem description: When opening the attached Microsoft Access templates, you get the error message: 'Unrecognized database format'.

Steps to reproduce:
1. Start LibreOffice
2. Click on 'Database'
3. Select 'connect to an existing database.
4. select MS Access 2007
5. Click 'next'
6. Click 'Browse'
7. In the 'file name' field, type *.* and press 'enter'
8. Select the template
9. Click on 'Next'
10. Click 'Finish'
11. Click 'Save'


Current behavior:
When opening the attached database, LibreOffice gives the following error :

The connection to the data source "New Database" could not be established.
SQL Status: 3343
Error code: -2147467259
Unrecognized database format 'C:\TS001225351.accdt'.


Expected behavior:
The database is opened for editing.


Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 6.0; rv:14.0) Gecko/20100101 Firefox/14.0.1
Comment 1 John Smith 2012-08-03 04:40:40 UTC 
Created attachment 65069 [details]
Microsft Access Templates
Comment 2 Jochen 2012-08-29 19:09:12 UTC 
@Regina

Please: can you have a look at this bugreport. What is your opinion?
Comment 3 Regina Henschel 2012-08-29 20:07:41 UTC 
That is a template for a database and not a database file. AFAIK, LibreOffice is not able to generate a database from such a template. So this would be a feature request.

If you generate a database from it with Microsoft Access 2007, then using LO 3.6.1 to connect to it via driver "MS Access 2007" the wizard hangs in step "Save". That has been reported in bug 53070.
Comment 4 Jochen 2012-08-29 20:15:12 UTC 
Changed status to "NEW". IMHO no questions overtly respectively no further discussion necessary.
Comment 5 John Smith 2014-04-03 09:35:59 UTC 
(In reply to comment #3)
> That is a template for a database and not a database file. AFAIK,
> LibreOffice is not able to generate a database from such a template. So this
> would be a feature request.
> 
If this is the case, then it should indeed be a feature request instead of this bug report. Please advise on best way to close this bug report.
Comment 6 Alex Thurgood 2015-01-03 17:38:25 UTC Comment hidden (no-value)