Recent content by Giobbe

Hi @strive4peace, I didn't know. I'll retry with db compiled, thank you Marco

Hi @strive4peace, I didn't compile, the db is under active development However I've created a second database, with a little script that opens and closes the problematic db, transferring one table on every cycle; I'm not proud of it, but it's working :-). I'll face this problem again when I'll...

Hello @arnelgp , I've tried another couple of drivers, but nothing changes, even with a pause (sleep) among transfers. I think I'll create a fake database that opens the problematic database, transfer the first table, close and reopen the database and so on. Very strange problem Thank you

Hi @arnelgp, thank you very much for the code. I've tried it, also in combination with @strive4peace suggestion, but nothing change, first table is transferred to SQL server; subsequent calls fail (table is created on the SQL server, but data is not transferred) But thank to your code, I've...

Hi @strive4peace, thanks for the suggestion; unfortunately I've tried the Sleep sub found in the page, using a sleep of 30 seconds between calls, but nothing changes; there are big tables, but also short; I've tried with short table first and with a medium table first, but the result is the same...

Hi, I need to automate the process: what I'm trying to do is, I suppose, the VBA version of the last operation you suggested (TransferDatabase with acExport and "ODBC Database" parameters). But it works only for one table, after the first transfer I have to close and reopen access database Marco

Hi, just a few tables; and I need to automate the process (for example with a button in a form: when I press that button, some tables are exported to the SQL server using the VBA code) Marco

Hi, I'm trying to transfer some tables from Access 2016 to SQL server; I'm using the following code: ------------------------------------ Public Function exportTable(table As String, destTable As String) DoCmd.TransferDatabase acExport, "ODBC Database", _ "ODBC;DRIVER=ODBC Driver 17...