.

That was supposed to be a compliment.

No offense but I like your code. 🙂

On another note. Have you ever seen Paul White SQL Programming Style? 😎

Hey, I'm glad that you got it to work.

Are the two programs that you are referring to Microsoft Forms, Queries, VBA Modules & Macros?

If not do you have connection strings...

Jeff,

I should have been more clear and I agree with you. 🙂

I never setup a maintenance task to shrink a Data or Log File. I would monitor and shrink on...

Just an FYI, when I saw this post there were no replies. I was working on my reply concurrently as the other forum member.

I was not trying to upstage anyone.

I...

If you define an Index on an int column it tasks 4 bytes of storage.

If you define an Index on a CHAR(30) it would take 30 bytes of Storage.

This has...

There are maintenance Task to Shrink the Database or DBCC SHRINK DATABASE Statement.

There are also maintenance Task and corresponding DBCC REORG, DBCC REINDEX, and a Task to update Statistics.

When you...

What documentation did you use to configure Access as a the Linked Server?

I know that it is in the Implementation & Maintenance Microsoft Press Book but it does not go...

I have listed some articles that pertain to the format file and it use with the BCP Utility:

http://www.sqlservercentral.com/Forums/Topic273875-8-1.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35526

http://www.developerfusion.com/code/5357/bulk-insert-from-flat-file-using-transactsql/

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

http://www.issociate.de/board/post/180881/BCP_Format_File.html

You may want to consider an alternative approach that does not rely on MAPI and an outlook client.

Have you considered SMTP?

Please reference the following links in which there is information...

Check out these links:

http://forums.iis.net/t/1159401.aspx

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/988ab9e3-26ce-48da-ad61-c458f5c9c539

It the security model of the Linked Server or of the configuration settings.

If you create an Access Database on your local machine are you able to Link to a Access...

Well thank you for your input. 🙂

The exam 70-432 is the Implementation & Maintenance Exam.

I was wrong, this Exam does not help you get certified as a MCTS or MCITP...

When you talk about tables, relationships, etc you are referring to relational modeling which are used in OLTP Databases (Transactional).

All relational Databases are based in the same concept.

http://en.wikipedia.org/wiki/Relational_model

http://www.siue.edu/~dbock/cmis450/6-relationalmodel.htm

The other type...