Cheers for that! Looking forward for the solution!
Sent you a pm...
Ok, thx. I'm still confused, if the linked table can be opened in the Design View, how come I can't do getProperties? The Design View will show the columns when offline, so no connection.
When hitting normal Access table, we are getting the table name, structure and the caption all fine. However, not so for a linked one, ie getProperties() wont work. In Access, it is still possible to open Design View and see the structure. Thx
Hi James, thanks again for your wonderful contribution to Open Source. I was wondering, is it possible to get the structure of Access linked tables to ie MSSQL, similar to table.getColumns() ? Cheers, D.
Thanks James! Sorry about the delay tho. Would you be interested in some paid work? I am after someone helping me with converting DB to sqlite, which already works, however the Description is not implemented. Cheers
Hi there is there any way to get the Description from the Column ? Cheers D.
Hi guys, So setting PRAGMA synchronous = OFF and PRAGMA journal_mode = MEMORY makes this: Output file: caa68efe4b4d5a4fb0bc3771cce4c4bf.sqlite3 Log file: caa68efe4b4d5a4fb0bc3771cce4c4bf.log.json real 17m37.635s user 0m33.128s sys 0m27.339s . . Output file: caa68efe4b4d5a4fb0bc3771cce4c4bf.sqlite3 Log file: caa68efe4b4d5a4fb0bc3771cce4c4bf.log.json real 0m12.932s user 0m22.987s sys 0m1.302s From 17 minutes to 12 seconds! That fixed it!