I am working on a membership database based on the one I created in ms-access, front end = libre office base 5.1.2.2, back end is a Mysql (usb)server. I use the native mysql connector
In the mysql server I created the database vtt_leden.
In vtt_leden there are 2 tables, one containing the information about the club & current (sport)season: t_club, one with the memberdata: t_leden
From within the member details form I want to read from the table ât_clubâ the start year of the current sport season (field âclub_seizoenâ). (I will store this value in the field âleden_seizoenâ if the player is participating this season)
For this I use DLookup.
Dim C as integer
C=1 'there is only one record in this table
S = DLookup("[club_seizoen]", â[vtt_leden].[t_club]â, "[club_id]= " & C
When executing the macro I receive a error message:
Error #1510 (DFunction execution failed, SQL=SELECT TOP 1 âclub_seizoenâ AS âTEMP48341â FROM âvtt_ledenâ.ât_clubâ WHERE âclub_idâ= 1) occurred in DLookup
I tested the same script in a lo with embedded database & it works fine
S = DLookup("[club_seizoen]", â[t_club]â, "[club_id]= " & C
So I wounder if access2base can be used with mysql database.
Anyone with access2base experience can tell me more?
(As a temporary solution I execute a Update SQL, but I can not see the result immediatly on screen.)