Access 2007 - System Resource Exceeded

cardinal2k

New member
Local time
Yesterday, 16:15
Joined
Aug 10, 2009
Messages
9
Hi all,

Any idea why the following would cause error 3035, System Resource Exceeded? It's not joining more than 16 tables, and doesn't have any kind of where clause, so the KB article on this error doesn't apply. The db isn't more than 2GB, which is where this call has sometimes failed before. I previously ran this in Access 2003, and it was fine.

Code:
dbInput.Execute " ALTER TABLE " & inputTableName & _
                  " ADD COLUMN ROW_ID counter(1,1);", dbFailOnError
 

Users who are viewing this thread

Back
Top Bottom