02-13-2007, 02:41 AM #2 KenHigg Registered User Join Date: Jun 2004 Posts: 13,295 Thanks: 7 Thanked 155 Tools > Database Utilities > Compact And Repair Database My database has 109 separate tables. Access Cannot Open Database Aggregate Type Join & Ask a Question Need Help in Real-Time?

A “connection” includes things like combo boxes, recordsets, queries, etc…..and these add up faster than one might think. http://ngogeeks.com/cannot-open/access-query-error-cannot-open-database.php The total number of records is not many – maybe 50 max. Go to Solution 7 Comments LVL 6 Overall: Level 6 MS Access 1 Message Expert Comment by:Chad Franks2014-08-18 what version of Access? 0 LVL 56 Overall: Level 56 MS If you open it, close it. 2. Access 2gb Limit

This error will occur if you are trying to add data (e.g. Connect with top rated Experts 13 Experts available now in Live! What more could my users want? my review here Is the DB an MDB or an ACCDB? 3.

Can you post the sql of this query? The Search Key Was Not Found In Any Record Thanks. It may not be a database that your application recognizes, or the file may be corrupt.

Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

Thanks again. The system returned: (22) Invalid argument The remote host or network may be down. With the help of this “Customers” table you will be able to view both the data and column information. Sql Server Express Login.

Join UsClose Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. All rights reserved. http://ngogeeks.com/cannot-open/access-query-cannot-open-database.php thanks 0 LVL 119 Overall: Level 119 MS Access 119 Message Active today Expert Comment by:Rey Obrero2012-06-14 1.

Solution This problem occurs because of one of Microsoft Access' top features - it's 2 GB limit (as of June 2012). Affiliate Disclosure | Contact Us | Privacy Policy | Terms of Use | XML Sitemap | HTML Sitemap Scamell Tech A problems and answers blog! My initial priority was adding the content. Insert the results from your unions into temp tables and then use those to limit the number of tables per query.

If it does not help I can always remove them. RE: Error 3049 when opening append query TheAceMan1 (Programmer) 24 Apr 11 13:23 How are ya TimPen . . .Don't you think we need to see the culprit SQL?Your Thoughts? . c. One of the SQL Server objects that you can interact with from within Micr… MS Access MS SQL Server Email Servers MS Access – Working with Relationships Video by: Jim With

it may not be a database that your application recognizes Posted on 2012-06-14 MS Access 1 Verified Solution 5 Comments 727 Views Last Modified: 2012-06-18 have seen this problem but no It is always worth keeping copious backups when working in Access to give you options to revert to a known working status for any object that may be corrupted beyond repairing