M
Moulder Glen
<CROSS-POSTED FROM ACCESS.CONVERSION LIST>
Ho, all,
Got a big snag here. I'm converting text tables into
Access with VBA/SQL. Pseudocode:
loopstart
read record layout of text table
generate SQL statement to create table in Access
execute SQL statement
refresh the Access tabledefs
go loopstart
I need to create 78 tables, only 45 get created. I've
sprinkled debug.print throughout the code, looks like
everything's working, but nearly half of the tables aren't
created. I've run a distribution analysis of which tables
in my list aren't created, there's no discernible
pattern. Sometimes 1 table is skipped, sometimes 2,
sometimes none, randomly. Does Access need a pause of
some kind between SQL table adds?
Any ideas?
Glen
Ho, all,
Got a big snag here. I'm converting text tables into
Access with VBA/SQL. Pseudocode:
loopstart
read record layout of text table
generate SQL statement to create table in Access
execute SQL statement
refresh the Access tabledefs
go loopstart
I need to create 78 tables, only 45 get created. I've
sprinkled debug.print throughout the code, looks like
everything's working, but nearly half of the tables aren't
created. I've run a distribution analysis of which tables
in my list aren't created, there's no discernible
pattern. Sometimes 1 table is skipped, sometimes 2,
sometimes none, randomly. Does Access need a pause of
some kind between SQL table adds?
Any ideas?
Glen