07-11-2005, 08:15 AM #3 Geoff tenOever Guest

Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find you could try here share|improve this answer answered Jan 16 '09 at 17:27 BIBD 9,3592063106 add a comment| up vote 0 down vote I'm not an MVP, but Google found these. Compact the database to get rid of any reference to the problem table: In Access 2010, Compact and Repair Database on the Database Tools ribbon. It violently breaks some rules of normalization, but is otherwise fine for this small application.

I cannot alter the target database (database B), as it is generated and consumed by a vendor's tool that we use to export and import data from their application. his comment is here Join the community Back I agree My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsBooksbooks.google.com - Broadband is a key enabler of the information society, increasing productivity and competitiveness across all sectors of share|improve this answer answered Jun 25 '12 at 13:51 Fionnuala 78.9k669115 I just copied my data over and switched the fields to 'memo' instead of 'text.' I am getting I am under the limit of 256.

Select the table in the Database window (Access 95 - 2003) or Nav Pane (Access 2007 and later.) Copy and Paste, supplying a new name, and choosing Structure Only. The trick is getting it all written into a policy that Sr. But I'd try to rescue the Access app first. http://pentagramweb.com/solved-can/solved-can-it-be-done-in-access.html More generally, there has been debate about whether the current industry structure has enhanced social welfare or served a detrimental role....https://books.google.com/books/about/The_Social_Value_of_the_Financial_Sector.html?id=nKK6CgAAQBAJ&utm_source=gb-gplus-shareThe Social Value of the Financial SectorMy libraryHelpAdvanced Book SearchView eBookGet

Successful databases evolve over time. As you have noticed, there is no external indication of memory problems when this happens. What does the title "Gone in 60 Seconds" mean?

It is hard for IT to be the sole voice in the wilderness shouting that "you MUST manage the size of your inbox".  It is so much easier if there is

We have a separate email archive solution - GFI Mail Archiver. Import the tables, or link them if the database is split. However, it's easy to move some or all the tables into a separate .mdb file and then link to those tables. I had the below snippet bookmarked from a long time ago when I was doing access work.

Open a command prompt, and enter something like this. Not the answer you're looking for? By Susan Harkins | in 10 Things, July 24, 2008, 5:44 AM PST RSS Comments Facebook Linkedin Twitter More Email Print Reddit Delicious Digg Pinterest Stumbleupon Google Plus Microsoft Access may navigate here The organization depends on these solutions and they're usually complex and expensive to develop and maintain.

share|improve this answer answered Oct 15 '09 at 23:31 Tony Toews 7,11511324 Hi Tony: the app is small. Each new file the same2012Creating a memory leak with Java4IIF query using OR operators not working0Effect of subdatasheet property in Access database on the performance3How to use ISNULL function in ms-access1Databound This occurs when JET is unable to determine the data type of the query field, and is triggered by lots of situations. You will see the name of the object that has not been imported, and you can then try the import again, skipping the bad form(s)/report(s).

Text Quote Post |Replace Attachment Add link Text to display: Where should this link go? First, Access is a huge application. I tell my users if they really need to keep the body of a message but don't need the attachment, just remove it and leave the message in place.   3 This will clean out any crud that accumulates during regular development.

The debate goes on, but many IT pros simply won't support Access because of its vulnerability to corruption. Secondly, there is no surprise here. Symptom: " Isn't an Index in This Table" This corruption of the MSysObjects table occurs in Jet 3.x (Acc 95 or 97). Unfortunately, that drastic step doesn't benefit end users.

With a bit of luck, you may be able to import these from a previous backup. ken You dont learn to walk by following rules. If one form or report is corrupt, the process will cease at step 5.