Please give me at least three (3) reasons why is it that re-compacting and relocation of files should be avoided? How are we going to eliminate fragmentation on a storage device if we will not use re-t25 compaction of the information? Is there another method of file relocation? If so, how? Please explain thoroughly, I want to be clarified on the issue. Thank you.

Whenever I try updating the Pivot Table using the Refresh Data key, I kept on receiving the error message saying “Reference is not valid”. Is there anything I can do to refresh the data?

I hope you can help me. Thank you. 

I am trying to recover or backup a database file from an old 5.25 floppy disc. I really just wanted to see the files. I tried several commands in DOS prompt but I am getting this error; SystemError: Illegal Free 0" or “System Error: Illegal Free with some other number”. Does anyone know what would be the command to backup and restore from an old file stored in a floppy disk? Many thanks.

My subscription does not feed the latest transactions from the publisher. I tried re-initializing it and saw that the snapshot generates for all the articles, the distribution is completed, and the tables are in sync. But then after just a few days, the subscriber would not receive the most recent data. Now, the distribution agent shows no available transactions, and there are no undistributed commands. There are two subscribers, but only one is claiming to have problems. I have checked the SQL server logs and the ms subscriptions, and there are no space issues or inactive subscriptions. What is wrong with the ms subscription?

Is there anyone who has discovered that SQL expressions cannot work with the word “between” for the shape file?

But otherwise it can work if an equivalent is used for example “SELECT*then the variables given. 

What other options should I use?

Anyone with different opinion, please give your helpful tips on this

My sound tracks are recorded in home studio at a sample size of 24 bit. In order to get the best quality, I tried using Microsoft Movie Maker, but it did not play. I want to find a good freeware that will convert my sound track–recorded files to have the best quality. Please give me some ideas and advice. Thank you.

I want to import an Excel file with client information into an MS Access database, but some data were not entered properly as some are in caps or it does start with a capital letter.  Is it possible to format cells automatically in such a way that “LONDON”, for example, becomes “London”?

I wanted to open a form using the Microsoft Access but the response was not good: “Characters found after end of SQL Statement.” What could be the problem behind this? What will I do so that I can open the form? It’s somewhat a rare instance for me to experience something like this. Please give me some advice on what should be my proper action for this kind of problem. Thank you.

Some fields in a form at MS SQL Server are obtaining values after calculating the form in a default value method e.g. DBLookup.

In this method the values are only getting revised during reopening of the form.

Would appreciate if anyone tell me the way to revise the form without reopen.

Thank you.

Can you help me set up database on the number of employees working on a particular day? In addition, it should also indicate the employee’s hiring date and termination date using the format MM/DD/YYYY.