No announcements
Found 1916583 threads
-
0 VotesCompact and Repair Access Databases
I am looking for some sample code to use in VB2008, in order to compact and repair Microsoft Access MDB files and ACCDB files.Answered | 1 Replies | 3415 Views | Created by Leonard Ansin - Friday, October 22, 2010 12:30 PM | Last reply by pvdg42 - Friday, October 22, 2010 2:32 PM
-
1 Votes
Compact and Repair Database using VBA
Just select 'Compact on Close' in Access Options | Current Database | Application Options, no need for VBA.Answered | 2 Replies | 14054 Views | Created by Jeanne B - Sunday, October 24, 2010 2:00 AM | Last reply by Malcolm C Dixon - Tuesday, October 26, 2010 9:42 AM -
0 Votes
What is compact and repair SQL database
You must be thinking of the Access "Compact and Repair" "feature".Answered | 3 Replies | 16834 Views | Created by NewProgammer - Saturday, August 8, 2009 6:02 AM | Last reply by - Wednesday, December 14, 2016 7:04 AM -
0 Votes
Access 2007 deleted database on Compact/Repair
Unfortunately there is not a current forum to post the question you are asking so I would recommend that you post you question to one of the Access Database design ...Answered | 1 Replies | 9644 Views | Created by mabrown49 - Monday, April 6, 2009 3:56 PM | Last reply by sudarshans1 - Monday, April 6, 2009 4:16 PM -
1 Votes
compact access 2007 database
¿Are there another way of compact .accdb database protected with password?Answered | 43 Replies | 43774 Views | Created by AdrianP07 - Thursday, January 25, 2007 12:26 PM | Last reply by Prasoon Pathak - Wednesday, August 15, 2012 9:55 PM -
0 Votes
MS ACCESS COMPACT AND REPAIR IN C# PROGRAMMATICALLY
Exclusive use is required in order to compact an Access database.Answered | 3 Replies | 2731 Views | Created by Brinda Arumugam - Thursday, October 22, 2015 2:14 PM | Last reply by Paul P Clement IV - Friday, October 23, 2015 5:23 PM -
0 Votes
SQL server equivalent to Access Compact Repair Tool?
A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts.Answered | 7 Replies | 5704 Views | Created by MarkWest009 - Monday, April 13, 2015 12:20 PM | Last reply by Jason_Clark03 - Monday, March 21, 2016 12:08 PM -
0 Votes
How to stop a compact/repair?
Microsoft Access MVPAnswered | 4 Replies | 1044 Views | Created by AllTheGoodNamesWereTaken - Tuesday, September 15, 2015 3:39 PM | Last reply by msdnPublicIdentity - Wednesday, September 16, 2015 4:13 PM -
0 Votes
MS Access Database Repair
Make a backup of your BE and then perform a Compact and Repair on your database.Answered | 4 Replies | 1459 Views | Created by MorganPa232 - Friday, March 27, 2015 10:59 AM | Last reply by Daniel Pineault (MVP) - Thursday, July 28, 2016 11:34 AM -
0 Votes
Compact and Repair Creates a new file
This is how Compact and Repair works: Creates a new file (db1.mdb) Copies all objects and data to new database Deletes original mdb Renames new ...Answered | 1 Replies | 5802 Views | Created by TheMeanFiddler - Tuesday, August 3, 2010 2:09 PM | Last reply by Roger Carlson Access MVP - Tuesday, August 3, 2010 2:27 PM -
0 Votes
Microsoft Access automatic repair and compact with database password
Not sure why you need to regularly compact and repair your database but you should be able to modifyAnswered | 1 Replies | 2301 Views | Created by wirejp - Saturday, February 27, 2016 1:53 PM | Last reply by .theDBguy - Saturday, February 27, 2016 3:21 PM -
0 Votes
Compact Database with Password in Visual Studio
Drop the quotes around the password.Answered | 9 Replies | 6047 Views | Created by J-Bal - Tuesday, September 13, 2011 1:32 PM | Last reply by Cleber RibeiroG - Saturday, March 24, 2018 2:45 AM -
0 Votes
compact sql server corrupt password
No, you must know the password used when password protectting the database.Answered | 2 Replies | 7139 Views | Created by RockinRon399 - Tuesday, September 13, 2011 7:52 PM | Last reply by RockinRon399 - Wednesday, September 14, 2011 7:50 AM -
1 Votes
SQL Server Compact Edition Database Password Recovery / Reset
We found this tiny company that handled our case exactly like we ...Answered | 7 Replies | 31454 Views | Created by Brian P. Hamachek - Sunday, April 18, 2010 9:01 PM | Last reply by SvenHanson - Thursday, December 26, 2019 10:58 PM -
2 Votes
Compacting the Front End of a Split Database Without Compacting the Backend
Can't explain why you're seeing size variation during the compact of the front end, but Compact on Close definitely only works on the current database (i.e.: the front-end ...Answered | 7 Replies | 5808 Views | Created by Avan_Madisen - Friday, June 8, 2012 2:58 PM | Last reply by Douglas J Steele, MVP - Monday, June 11, 2012 2:38 PM -
1 Votes
What is the vba command equivalent of the Compact btn on the Database Tools ribbon?
1) Access in fact closes the database during the process of compacting.Answered | 12 Replies | 5941 Views | Created by kqke - Friday, January 3, 2014 2:51 PM | Last reply by kqke - Friday, January 17, 2014 2:20 PM -
1 Votes
compact and repair with jet engine
My database is mdb format In that case, remove Microsoft Jet and Replication Objects (JRO) from the References of your project, delete the JRO.Interop.dll file from the bin ...Answered | 14 Replies | 3196 Views | Created by Ashkan209 - Tuesday, February 13, 2018 7:43 AM | Last reply by Ashkan209 - Sunday, February 25, 2018 10:20 AM -
0 Votes
Can't compact Access 2010 database in a shared folder after the migration process
You said that you could compact a database use a different account using Access.Answered | 12 Replies | 777 Views | Created by Kupriyanov - Thursday, May 24, 2018 9:04 AM | Last reply by Kupriyanov - Wednesday, August 29, 2018 7:16 AM -
0 Votes
SQL Server Compact 3.5 and Access Database Synchronizer
I am currently using ADS wizard and am being forced by VS2008 to upgrade the db to sql 3.5, otherwise I appear to be stuck without a way to alter the database.Answered | 2 Replies | 9207 Views | Created by Wolfgang Roeckelein - Tuesday, January 20, 2009 3:11 PM | Last reply by PattiB - Wednesday, January 27, 2010 10:05 PM -
0 Votes
Microsoft Access Databases and Security
Assign a password to your backend.Answered | 12 Replies | 1181 Views | Created by Kristen182 - Monday, July 24, 2017 7:40 PM | Last reply by Daniel Pineault (MVP) - Wednesday, August 9, 2017 6:27 PM - Items 1 to 20 of 1916583 Next ›
No announcements
