suddenly my saved import /export page is empty
all of my efforts for years are gone
i can not also save a new import to the database
i tried to open my database in many various versions 2007 - 2010 - 2013 but without any effect
please Help Me
suddenly my saved import /export page is empty
all of my efforts for years are gone
i can not also save a new import to the database
i tried to open my database in many various versions 2007 - 2010 - 2013 but without any effect
please Help Me
one would think the most immediate and expedient idea would be to go back to a prior back up copy of the database.
Thank you for your reply
but i really need to fix that database
any idea ?!!
well while definitely know saved import/exports - I have never heard of "saved import /export page" - so I am not 100% sure we are in sync. I also have never heard of saved imports/exports disappearing - though in a general corruption anything I suppose is possible.
the only 'fix' per se is to do the compact/repair; make a copy first as it can make things worse depending on the situation....
as a sanity check; when one makes a macro - and uses the 'Run Saved Import/Export' - in older versions like 2007 one had to blindly type in the name I think but in the newer versions one is offered the list available - so you would see there if they really exist or not.
but if you have the table data - which it sounds like you do; then one should be able to merge an old/past version of the front end objects with the import/export and the current data without too much work....
Look in your MSysIMEXColumns and MSysIMEXSpecs system tables, you may find info.
But, as NTC said, if you've had some corruption, then anything might have happened.
If you know the layout of the source table and the target table, you should be able to recreate the spec, or a module/function(s) to do the mapping.