10-01-2012, 02:55 PM #5 EDDY20XX Newly Registered User Join Date: Apr 2012 Location: New York Posts: 7 Thanks: 0 Thanked Beside this your database will run fast and you can also make changes to the front-end while still using live data. running an append query, make table query) to the database which would push it over the 2GB file limit. TO REVIEW Online research shows this message could also occur under the following conditions: http://support.microsoft.com/kb/310937 Share this:ShareFacebookLinkedInTwitterEmail Posted: 06|19|12 at 15:10.

So, these are some common factors that can damage or corrupt the MS Access database file, However, minor corruption can be fixed with built-in compact and repair utility but for severe How are you linking and from what are you linking? And it gives me this error. (Cannot open database". Please try the request again.

CuriousGeorge General 10 03-23-2011 08:48 AM possible to add a "select none" option to a combobox drop menu?? Well in that case the last and most powerful solution left with you is to use third party tool. A virus could also transmit from exterior media or contaminated website could imitate in background and makes changes in file traits, formats or removes file from PC. for anyone looking, the vba code to do that is very simple: Sub exportQuery2Text() DoCmd.TransferText acExportDelim, "", "mapProducts2Bills",_ "[filepath].txt", True End Sub I hope this is helpful Cheers share|improve this answer

Step 5: Now you will the preview of database query. 4688 Total Views 10 Views Today Posted in MS Access Errors Repair Tagged Access Cannot open database, Access Cannot open database Can I get a dual entry schengen visa for tourism purpose for me and my wife? And if I close access and reopen it , sometimes it works fine then but sometime it gives error again. Also when I do a RUN without creating a table and just selecting and displaying the data it does not give me any issues.

Jet Database Engine problem – If several noncompatible Jet Database Engines runs on one network then it may result in an error and can leave the database files damaged.