Jumat, 24 Juli 2015

[MS_AccessPros] Re: Unable to

 

Patty - First of all, turn off AutoCorrect. it does more harm than good. It's under Options>Current Database.


The object not being saved might be the Import Errors table, but there is no way of knowing. Turning off the AutoCorrect might just solve this issue. One way to check your import is to know how many rows are coming in and how many you end up with. If you have the DDL warnings (Confirm Action Queries under Options>Client Settings) turned on you should get a message after the import as to how many records were imported and how many failed for whatever reason.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <pattykf@cox.net> wrote :

I have tried to import a table from an ODBC database

when I import the table (did it a couple of times) I get a AutoCorrect Save Failure- stating it could not save the object.

it appears the table comes in, I have not way to verify that it is complete, it is a large table, with 408051 rows of data., with data showing it was just modified a little while ago.


I am not sure what the error really means, so if anyone can tell me what it means and what I should do about it I would be very grateful

thank you

Patty

 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar