I had some better links but I lost them (see below)...

If you have any of the Microsoft Admin Books, they describe the process.

You can also Goggle and get plenty of...

I'm sorry but I'm having difficulty understanding you problem.

Are you simply trying to link a SQL Server Tabler using a DSN?

If that is the case then how does the Linked...

The maximum Database Size for SQL Server 2008 is 524,272 terabytes.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Why are you using the SA Account in your .NET Code? You are asking for trouble...

Why are you using a DSN Connection?

I'm sure that you could find numerous examples; on...

If you are going to continue to use Access as the Front-End you may want to consider an Access Data Project as opposed to a regular Access Database.

http://www.fabalou.com/Access/Tutorials/ADP_UserManagement.asp

http://articles.techrepublic.com.com/5100-10878_11-5065669.html

http://www.pcapps.com/application-services/conversions-and-migrations/scorecards/ms-access-dataproject-scorecard.aspx

I converted some Accounting Applications from Access to SQL Server several years ago for a Fortune 100 Company.

If you don't create a Primary Key or at least a Unique Index...

I'm sorry but I do not understand how I can help you.

Perhaps the brightest members of this forum can assist you with the information that you have provided.

What output are you expecting this DB application?

I agree with CozyRoc's suggestion.

I had to import data from a Sybase daily using DTS but unfortunately I do not have currently have access to a Sybase Database that I...

I'm not sure at this point what the outcome will be.

I have no issues with Dell. They were very nice people.

This was not a Dell employee that was pushing the Blades.

I was just suggesting to this Network Admin that thinks...

Well thank you for the information.

I did not mean to come across as arrogant but the guy that wanted the blades was using low temperature as one of the justifications...

Paul,

Have the issues with Heat been resolved?

That's a bit ironic because the person that was pushing for he blades was responsible for the blades and we has extemley high tempetures...

Gail,

Thank you for mentioning that.

I had forgotten all about the switch archive capability withy Partitioned Tables.

Thanks for correcting me.

I no longer have the code that I wrote to Archive Data but basically it consisted of a Stored Procedure with a WHile Loop

This SP refereed a Control table that...