Hi,
In my app, i have a databse with 2 tables.
I write to the 2 tables, and save the db.
I know that is OK, because (a) i get no errors and
(b) i use vba to read the db and convert the 2 tables into xml files that are sent elsewhere.
Problem: the sqlite.db is then read on a PC using vb.net, which worked fine 6 months ago.
Today i tested again, and vb.net cannot find the tables any more.
Dim dt As DataTable = SQLconnect.GetSchema("Tables") ... dt.rows.count = 0
Did anything change in the last few months on the VBA side to cause vb.net not to see
the tables any more, although they are present. (No name mismatch, no upper/under case problems..
Just asking,
Paul
In my app, i have a databse with 2 tables.
I write to the 2 tables, and save the db.
I know that is OK, because (a) i get no errors and
(b) i use vba to read the db and convert the 2 tables into xml files that are sent elsewhere.
Problem: the sqlite.db is then read on a PC using vb.net, which worked fine 6 months ago.
Today i tested again, and vb.net cannot find the tables any more.
Dim dt As DataTable = SQLconnect.GetSchema("Tables") ... dt.rows.count = 0
Did anything change in the last few months on the VBA side to cause vb.net not to see
the tables any more, although they are present. (No name mismatch, no upper/under case problems..
Just asking,
Paul