How to reduce Microsoft Office Access Database size?

I have found a great easy  way to reduce MS Access MDB file size:

MS Access doesn't free up space used by records even after they are deleted. You can free the space manually when you need to or automatically each time you close the application.

To do it manually, use the Compact and Repair utility:

1. Backup your database, as there is a bug in Access 2007 that may delete your database
   during the compacting procedure.

2. If you are compacting a multiuser (shared) database that is
   located on a server or shared folder, make sure that no one else has it
   open.

3. On the Tools menu, point to Database Utilities, and then click
   Compact and Repair Database.
   

To do it automatically when you close the application:

1. Open the database that you want MS Access to compact
   automatically.

2. On the Tools menu, click Options, and then choose the General
   tab.

3. Select the Compact On Close check box.

After deleting the data and compacting the database don't be surprised if is still larger than 100 KB. There is a certain amount of overhead that cannot be removed after you add data the first time.

Click here to read the original article on http://StackOverflow.com

Dynamically Obtain a SQL Server’s IP Address in T-SQL Code

Do you want to obtain SQL Server IP address in your trigger or table?

Click here to get some knowledge on this topic.

Is the above link useful to you? Let us know your feedback, it will help us to improve our posting(s). or You can send your feedback to linkOblast.

Connection String

Developing database driven application and forgot text for connection string.....

dont worry !

To get sample for connection string for any database click here

or

here > http://www.connectionstrings.com/



Is the above link useful to you? Let us know your feedback, it will
help us to improve our posting(s). or You can send your feedback linkOblast.