I have done some tweaking by creating a blank database and tried to replicate the scenario.

Its all about the linked tables, the password was not saved. I deleted and relinked,...

Hi Wendell, Thanks for your response.

I keep getting the DSN Sql Server Login prompt, attached screenshot. I have to cancel this 3 times then it goes to form_Current event. Here...

Thank you Wendell and William for valuable inputs..

Even before conversion I made the application split, each of our users have Accde file on thier desktops.

I will first convert the master...

How can this be associated with Ms Access form record source?

Check this.. I use this when the DB is corrupted..

Before running, make a backup of the DB..

"C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" "C:\AccessDB.accdb" /decompile

Thanks for the inputs..

I have Master form with lot of controls, the record source for this form is a query which returns single record and this data is fed to...

Thank you for your valuable inputs..

The record source query has more than 10 table to join but returns single record, the number of columns are around 100+ which are fed...

Ok, I could figure it out..

I went to Source OLEDB, Advanced Editor and Input and Output parameters.

There I have compared the length of the column in External Columns and Output...

Before Executing the Package:

[Source FCM File [1]] Warning: Truncation may occur due to retrieving data from database column "Client_Short_Name" with a length of 100 to data flow column "Client_Short_Name" with...

Yes, cannot modify in destination..

Hi Koen,

Thanks for responding..

Yes I know the column name on which erroris occurring.

the datatype for this column nd length are matching.. I have tried fixing column length, like increasing as...

Thanks Jeff for your thoughts.

Scott, thank you. I am following you :). Unfortunately I am not the decision maker here. I have been giving all the information you are sharing...

Thanks Scott, for your valuable inputs and thoughts.

However I haven't got the answer yet, when exactly do we need to go for Table Partition and Page compression. If this is...

I guess this is not possible in my case. We need a primary key, if that's treated as unique row identifier. that acts as a clustered index.

Ideally the other index...

So the question why are we doing a Partition.

Before answering this question, since I am newbie and want to understand from you when exactly we need a partition on any...