Search results

Found this: Windows Installer CleanUp Utility http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 The Windows Installer CleanUp Utility is provided "as is" to help resolve installation problems for programs that use Microsoft Windows Installer. If you use this utility, you may have...

This is more of a simplistic approach to what I believe you are describing, but maybe this type / concept of an application will help with ideas on how you want your product to work… http://www.codeproject.com/tools/ToDoList2.asp Edit----- This guy has done wonders with this gem... Hope this...

Thanks Pat, Here is more information on Non-clustered indexes... http://www.sql-server-performance.com/nonclustered_indexes.asp Non-clustered indexes are best for queries: • That return few rows (including just one row) and where the index has good selectivity (generally above 95%). • That...

The following information is from this site: http://www.sql-server-performance.com/clustered_indexes.asp As a rule of thumb, every table should have a clustered index. Generally, but not always, the clustered index should be on a column that monotonically increases--such as an identity column...

I haven't used this but maybe either... BindingManagerBase.Current Property or CurrencyManager.Current Property will help. I take it you have tried George Shepherd's site: http://www.syncfusion.com/FAQ/WindowsForms/Default.aspx

Non Clustered Indexes There is not a whole lot of information on creating / using Indexes for Access. I believe Access does not have clustered indexes (A clustered index physically orders the data in a table based on a single or composite column - I don’t think ‘Autonumber’ would apply) and...

https://www.microsoftelearning.com/sqlserver2005/ Get Ready for SQL Server 2005 with Free* Microsoft E-Learning Courses. Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and...

Try this: http://www.access-programmers.co.uk/forums/showthread.php?t=100211 I think you will find this thread helpfull...

I am too looking into this... and this is going to be a quick reply and hopefully Kodo or someone else will expand on this for us. I have found a few resources on this and one quick one is here: http://ssw.com.au/ssw/Events/2005AccessToSQLServerAndNET/resources.aspx Take a look at "How to...

I don't think this is exactly what you were talking about (this is a blank database in which you save your snippets, not an existing code repository with samples - Or a browse - explore coding example like ghydson's example - Just re-read your question and I will leave this here anyway, oops.)...

I have some experience with DataSets, usually when I try a SQL string I 'preview' it with Access in a 'test' query to see if I can get the desired results and then port it over to .Net. Bind a datagrid to your dataset and see if you get your desired results.

True. Especially when I find I have code bouncing around modules, forms etc. and filtering the loaded form using the ‘OnCurrent’ event. I believe it is easy to over-complicate an idea with code and blow everything out of the water. It seems there are 1000+ ways to do things, some are more...

Two excerpts from the links above that made an obvious distinct impression upon me about ‘Normalizing a Database’ of which are on opposite sides of the spectrum as far as ‘Normal Forms’ is concerned are: 1) With a properly normalized database, changes to data over time are easily handled with...

Database Normalization Tips http://www.fmsinc.com/tpapers/genaccess/databasenorm.html http://www.fmsinc.com/tpapers/datanorm/index.html Examples of going 3NF and beyond to include Fifth Normal Form on some of the links below: http://www.curlingstone.com/Normalization2.html...

I checked “Access 2002 Developers Handbook” and their point of view was that all of that extra effort to achieve Boyce/Codd, Fourth and Fifth Normal form gave you little added value over 3NF. They went on to quote C. J. Date, on the principles of database design: “nothing more than formalized...

From the book "Special Edition Using MS Access 2003" by Roger Jennings... Third Normal Form: Requires that data in all non-key fields of the table be fully dependent on the value of the primary key and describe only the object that the table represents. In other words, make sure that the table...

I think that this is a GREAT idea, and a very important subject. The subject 'Normalizing a Database' is a HUGE issue, even if you develop database programs outside of Access. Will I use it? Absolutely! A lot of people like myself are self taught in Access and sometimes develop bad habits...

Here are a few more links that will hopefully help. Whether to choose Access or VB... http://www.utteraccess.com/forums/showflat.php?Cat=&Board=8&Number=1071725&page=3&view=collapsed&sb=5&o=&fpart=1 Considerations about installing the runtime...

When either choosing the Custom Startup Wizard or the Package Wizard, there is an "Add..." button toward the bottom of the page. Click the "Add..." button and it should take you to the default folder for either Wizard. It should be: C:\Documents and Settings\YourLogInName\Application...

Well if you are using Access 2003... All you would have to do is highlight the query and right-click and choose 'Object Dependencies'. An Object Dependencies Task Pane will open up. From there you have two radio buttons in which to choose: Objects that depend on me. Objects that I depend on...