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
Accessing Base files using Visual Basic 6
-
- Posts: 1
- Joined: Sun May 28, 2017 11:52 pm
Accessing Base files using Visual Basic 6
Open Office 4.1.3 Windows 10
Code: Visual Basic 6.0
Code: Visual Basic 6.0
Re: Accessing Base files using Visual Basic 6
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...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
This search link may provide a couple of pointers.
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
Re: Accessing Base files using Visual Basic 6
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: Accessing Base files using Visual Basic 6
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice