 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2005Designing tables
I imported an Excel file into Access and now need to add and extra field to the table, which would be an OLE object. I get an error messagewhen saving that too many fields are defined, followed by errors were detected duringthe save operation file not updated etc .. Any suggestion on how to get extra fields into my tabel Thank you William, Please post some details about your table. How many fields do you have? What kind of data are you storing? How many records do you have? Sprinks > I imported an Excel file into Access and now need to add and extra field to > the table, which would be an OLE object. I get an error messagewhen saving [quoted text clipped - 4 lines] > > Thank you Its not a huge table, 12 Fields with 143 line entries all but the one I am trying to add are text as a data type > William, > [quoted text clipped - 11 lines] > > > > Thank you William, I've never encountered this problem, but start with Tools, Database Utilities, Compact and Repair Database. You also might want to create a parallel empty table in Design view, and attempt an Insert query from the corrupted table to the new one. Hope that helps. Sprinks > Its not a huge table, 12 Fields with 143 line entries all but the one I am > trying to add are text as a data type [quoted text clipped - 14 lines] > > > > > > Thank you Hi and Big THANK YOU I ran the compact and repair, screen came up straight away with my switchboard. I went in and aded the extra OLE field and the pictures come up correct in my form. I was aware of the compactg and reapir option but was relcutant to try it based on a comment made in and access book I once read. Ah well you live and learn have a great weekend and thanks again > William, > [quoted text clipped - 24 lines] > > > > > > > > Thank you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.