473,231 Members | 1,672 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Open an existing Access Database with Libre Database

DJRhino1175
221 128KB
Has anyone ever needed to open an access database in one of many open office platforms? My company is talking about moving away from Microsoft Office and going to Libre or even Open Office. I had our IT guy install them an a laptop so I could try it and had no success. It would open but queries, forms and reports were all gone. Not even sure VBA would work on these...

Thanks for your input on your experience.
Sep 1 '21 #1
7 6391
NeoPa
32,554 Expert Mod 16PB
Hi DJ.

I can't say for certain, but I would expect other software to be able to interpret the data at most from an MDB or ACCDB file. Not all third-party software will even do that of course. If you're lucky you may find one that may be able to interpret the SQL of queries - but even that is a specific dialect of SQL supported by Jet/ACE, which doesn't adhere too closely to the actual SQL standards. I've not heard of any non-Microsoft software that supports VBA. VBA is proprietary as far as I know & owned by Microsoft.

If your company is moving away from Microsoft Office then I wish them luck. In some quite rare circumstances that can be done with little or no pain. Opening documents is generally supported well enough. However, anything to do with automation or control (VBA or macros) was a non-starter last I looked & I don't expect that to change any time soon I'm afraid.

Sometimes these decisions are made by people who have determined the likely effects after knowing the sorts of documents that are in use at the company, but that's rare. Usually they're idiot bean counters who see the possibility of saving money - IE They understand the price of everything but the value of nothing and are frequently put in positions where they can make decisions way above their comprehension & competence.

I can't say that's the case where you work. I don't have the details. However, if your company relies on any Access databases that use macros or VBA then you have the option of a free runtime version to run existing projects, but not the software that allows you to update them. I wonder if someone believes that's a viable situation to be left in? I guess it depends on the value they see coming from these projects - which obviously depends on their understanding what value even means of course ;-)
Sep 1 '21 #2
DJRhino1175
221 128KB
Thanks Neopa. Didn't no about the runtime version. When you say updates you don't mean to tables or anything like that, right? I just would be able to do design work of any kind?
Sep 2 '21 #3
isladogs
451 Expert Mod 256MB
PMFJI
Using Runtime allows users to enter or edit data. However, it does not allow users to change the design of forms/reports.

You can simulate runtime in either of these two ways:
1. Open your database using the /runtime switch. See Simulate Access Runtime
2. Temporarily change the file suffix from .accdb to .accdr
Sep 2 '21 #4
NeoPa
32,554 Expert Mod 16PB
IslaDogs:
PMFJI
Using Runtime allows users to enter or edit data. However, it does not allow users to change the design of forms/reports.
Jump in any time. You explained it perfectly.

IslaDogs:
You can simulate runtime in either of these two ways:...
I suspect the point being made there is that you, as a developer with the software, can test out how well using the runtime version would work without making the change or uninstalling your software.
Sep 2 '21 #5
isladogs
451 Expert Mod 256MB
Hi @NeoPa
You understood the purpose of my second paragraph perfectly. Thanks for clarifying
Sep 2 '21 #6
DJRhino1175
221 128KB
Thanks guys. I'm hoping they change their minds on this. From what I'm told its because of a licensing change that Microsoft is doing it will get to expensive for our company :(

Again thanks for the help and explanation.
Sep 3 '21 #7
NeoPa
32,554 Expert Mod 16PB
Bear in mind that, as far as Access goes at least, you only really need the licence for the developer(s). Ordinary users can get away without one.

Best of luck :-)
Sep 3 '21 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: powerrun | last post by:
Help! I have tons of info loaded into an excel spreadsheet that I need to transfer into an existing database in access. There is a specific Query I need the information to transfer to. This...
10
by: vvenk | last post by:
Hello: When I tried to use an Access database, I get the following exception: Server Error in '/WebGrid' Application....
2
by: jennifer | last post by:
All of a sudden, I am getting the following Microsoft Office Access popup when I try to open my database. "The current user account doesn't have permission to convert or enable this database....
3
by: ConfusedMay | last post by:
Hi, I've created an access 2003 database that has a form with button called "open complaint database." This complaint database is also in access 2003. Here is my code to open the complaint...
2
bard777
by: bard777 | last post by:
I am creating a utility database to use to update and maintenance other databases. One of them has an update process that uses 19 queries and as many linked tables. It works, but is complicated...
14
by: SimeonD | last post by:
Hi I have an access database called Sales.Mdb In vb.net 2005, I'd like to open it. Which I can do. What I can't figure out is how to figure out if Sales.Mdb is open already. If so, I want to open...
1
anoble1
by: anoble1 | last post by:
Hi, I recently upgraded 2 of the servers on my MS Access 2007 database. A UA server and a Production server. WHen I converted over to the new severs I just changed the names in code. Also, I had...
7
by: Annerb | last post by:
I have a database containing an average column. I need to add a column of data listing the SD. How to I add this column and make sure each value is matched up with the right site? The averages...
1
by: Stan | last post by:
A user is having problem opening an Access database after installing Office 365. I tried to open my older test copy with Office 365 Access but go the message "You do not have the necessary...
2
by: 5236 | last post by:
Hello guys, I'm new to VBA and trying to create a form for inserting new records into an existing access database, the thing is the database is provided by a third party so I don't have control over...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.