Workaround for Access Error 3047

I get error 3047 in MS Access 2007 importing a large amount of data (beware of users with free text fields). I found online that this is due to a 2Kb limit for access records. Is there a way to overcome this limit without normalizing the table (and rewrite all the code)?

+3
source share
2 answers

Storage and OLE fields are not considered part of the write restrictions.

+3
source

You can avoid re-writing large code, but you can normalize.

, , "-" , ( , ). , , , .

+2

Source: https://habr.com/ru/post/1756586/


All Articles