Recent content by WindSailor

Bee, The 'local' guys here are off on other projects and not available. In regards to having a Null value for a foreign key: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=3&Number=1258379&page=0&view=collapsed&sb=5&o=&fpart=1

Bee, I was wrong about the null value issue in a big way -oh brother-... as soon as I left for work, I realized the dastardly deed was already done... no excuses here. Humility, at least there is a name for it...:o In my little part of designing, I normalize to a higher normal form to...

It was just an observation of what you wrote... and no, originally I didn't look at the example. Looking at it now I can't immediately see the issue. I was going on your statement; when you created a new record in tblServices, you always have a null value for a foreign key. I have always...

Bee, That was a violation of First Normal Form. Or Go back and take a look at the Normalization links or do a search here. There are plenty of examples and tutorials. -------------Edit--------- You are going to have to work through the normal form examples with your template. Set your...

Here are a few links on normalization... http://www.access-programmers.co.uk/forums/showthread.php?t=100211 http://www.utteraccess.com/forums/showflat.php?Cat=&Board=8&Number=1203187&Zf=&Zw=&Zg=0&Zl=b&Main=1203148&Search=true&where=&Zu=85896&Zd=l&Zn=&Zt=24&Zs=&Zy=#Post1203187&Zp= Each link...

Hello Bee, The only suggestion I have is to make sure your tables abide by some level of the Normal Form rules (taking it to 3rd normal form is generally not a bad idea). I think I can generically tell by your design you don’t have any repeating columns, and every column is required… Here are...

Having no more than two foreign keys in a table is more from a *purists* point of view of trying to obtain fifth normal form in your design. This also applies to 'Look-up' tables used in a table, so that will dramatically change your design. I believe taking it to that level really only helps...

http://www.sql-server-performance.com/am_indexing_low_sel_cols.asp ------------------------------------- Techniques for Indexing Low-Selectivity Columns in SQL Server By Merrill Aldrich 9 June 2006 Most of us have probably faced this situation at one time or another: there's a deceptively...

Viewing an email from Code Project, I ran across this article about database corruption and thought it was worth posting here... Be sure and click on the immediate link below to view the latest updates in the discussion area at the bottom of the web page. ----------------------...

Good point Dave... From my understanding this is not an application problem, but a Windows issue (if you put this on a network computer and not on a server). Any (database) application that is not on a server and handles multiple users, the application uses the Windows file system to handle...

Here a while back I thought they changed their mind and made it free from now on... I'll have to go back and check...

VS Express Editions which are totally free... http://msdn.microsoft.com/vstudio/express/default.aspx I like books (something I can have for future reference), especially from Francesco Balena, David Sceppa, Sahil Malik, and / or Rick Dobson, that should give you a good start. Here is another...

Nice link RV... Kruger... Normally I don't reply to various normalization threads simply because I have my own issues with normalizing a database. Long story. Anyway for a learning experience, look at the following links, make a few hundred pots of coffee and try to take your database (if you...

I'll go along with everyone else. To bad there isn't more information on primary keys, indexes etc. strictly for Access. Here is a link geared toward indexes... if anyone can add to it please do. http://www.access-programmers.co.uk/forums/showthread.php?t=103298

Hi Tim, The few links I have on connection pooling I have recently found are: http://msdn2.microsoft.com/en-us/library/ms254502.aspx http://www.ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html http://www.sql-server-performance.com/sk_connection_pooling_myths.asp...