Accessing Base files using Visual Basic 6

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
TexasComputerMan
Posts: 1
Joined: Sun May 28, 2017 11:52 pm

Accessing Base files using Visual Basic 6

Post by TexasComputerMan »

Some years ago I wrote my own checkbook system using VB6.
I use SQL to read and write the tables in an M/S access data base.
I have converted the M/S database to Open Org Base file.
Is there a way to access this converted file using VB6?
TCM
Open Office 4.1.3 Windows 10
Code: Visual Basic 6.0
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Accessing Base files using Visual Basic 6

Post by keme »

TexasComputerMan wrote:Some years ago I wrote my own checkbook system using VB6.
I use SQL to read and write the tables in an M/S access data base.
I have converted the M/S database to Open Org Base file.
Is there a way to access this converted file using VB6?
TCM
There probably is. The API (object models etc) are different, so major changes will be required in your code. Also, some have commented that the compatibility between VB and AOO is less than excellent...

This search link may provide a couple of pointers.
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
JeJe
Volunteer
Posts: 2764
Joined: Wed Mar 09, 2016 2:40 pm

Re: Accessing Base files using Visual Basic 6

Post by JeJe »

Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Accessing Base files using Visual Basic 6

Post by Villeroy »

You may be able to use your VB program and the new office suite independently from each other. But then you should not convert the database. Instead you connect a Base document to the the original database and let your program keep on working with the DAO objects. Access objects require Access being installed.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply