You may need to ask the vendor why and how to. They may set it this way for a reason.

"Noted that the Microsoft OLE DB Provider for Jet, used for Access and Excel databases, is not available in a 64-bit version."

http://technet.microsoft.com/en-us/library/ms141766.aspx

"...native 64-bit applications (such as the 64-bit...

Welcome board! SSC has exactly what you are looking for. Stay with us.

So You're the New DBA

http://www.sqlservercentral.com/articles/Administration/61319/

The DBA Routine

http://www.sqlservercentral.com/articles/Career/61535/

More tips will come as SSC...

I keep learning. But the more I know, the more I know I do not know. What is the logic!

I feel lost while reading your post. Punctuation needed at least.

SQL Server interview questions

http://vyaskn.tripod.com/iq.htm

Check how much you could understand (not memorize). They are some basic questions.

I would like have my laptop get protected/disk encrypted. It is another layer of protection. When DBA loses a laptop, it is more than a laptop. Although...

You need to upgrade 6.5 to 2000 first. Check this KB.

http://support.microsoft.com/kb/322620

.DAT file seems a device file. 6.5 Database sits on devices. Devices are logical files...

Workaround: install SQL2005 + SP2 on your own workstation. Make screenshots there.

Note: SQL Server 2005 Developer Edition and Evaluation Edition have the same feature set as the Enterprise...

Your case is SP2, 3042?

This KB says you may need SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2.

http://support.microsoft.com/kb/942660

Or make a...

It should work using maintenance plan - Maintenance Cleanup Task.

Refer to this post:

http://www.sqlservercentral.com/Forums/Topic432440-357-1.aspx#bm451969

It depends on the data change activities (insert/update/delete), change volume in one single batch, and transaction log backup frequency, reindex in place or not (full recovery mode).

Usually set it 20%...

check this link, search "error: 28".

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

See the early posts:

http://www.sqlservercentral.com/Forums/Topic423386-146-1.aspx

http://www.sqlservercentral.com/Forums/Topic458189-19-1.aspx#bm458208

Overview of 64bit SQL

http://www.sqlservercentral.com/articles/Miscellaneous/overviewof64bitsql/1166/

Thank you for the links. It is interesting to know how the others handle the same topic in different ways.