Search results

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. ----------------------...

Hello, In VS 2003 you more or less manually opened, closed all of your connections. In VS 2005 (going with the very basic idea of dragging a dataset from the Data Source tab onto a blank new form) I didn’t have to manually open the connection, and the connection is there for my data source…...

http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&displaylang=en Starting with the April 2006 update of SQL Server 2005 Books Online, a separate Books Online for SQL Server Express is no longer available. SQL Server 2005 Books Online is the primary...

I found an article on the internet on how to stop this, but for the life of me I can't remember it or find it. The article stated that even though you were limiting your returned set of data from SQL Server by using a 'Where' clause etc. JET still pulled all of the data. The solution has to...

Oracle Express Edition, DB2 Express Edition-C, and SQL Server Express Edition. Which one would you develop for / work with if you had a choice (SQL Server, Oracle, or DB2)? I am thinking of making a database application with one of the above and the criteria is: Great support, community Rock...

Free Visual Basic 2005 eBook for Developers MSI Installer: http://download.microsoft.com/download/5/B/3/5B348407-ABCE-4C4B-8EA7-0DEC753354B1/Introducing%20Visual%20Basic%202005%20for%20Developers_6-2058-X.msi PDF Version: http://msdn.microsoft.com/vbasic/learning/introtovb2005/Intro2005-C8.pdf...

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...

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...

Here are some requests for Access 12, I hope it isn't too late. ) Make sure that the runtime (all runtimes) that are installed on various computers can be detected and updated through Microsoft Updates. ) Please go through and check compatibility of the keyword 'Distinct' using SQL statements...

Hi all, Lately I have been having problems with SQL statements using the ‘Distinct’ keyword. The following code below in the SQLText2 statement has fictitious Table and Column names but the structure is the same. Dim db1 As DAO.Database Dim rst00 As DAO.Recordset Dim db12 As DAO.Database Dim...

If you had a choice of using either an ActiveX or a DLL object in an application that is used on various systems, what would you choose? This is going on a .MDE project and my main concern is stability or compatibility. I am more interested in general practices of what you would use (either an...

When will Access support the .Net framework? Will Microsoft ever consider making another RAD program similar to Access that supports the .Net framework? Just think of an IDE of a RAD program similar to Access that has a full set of toolbox items already built in .Net that supports all of the...

Congratulations! I see you are a Microsoft Access MVP. About time... :) Now if we can just get you to write that book...

This should be a simple one, but right now I just can't get it. How do I get a Bookmark to pick up on the entry that I chose from in a combo box when there are multiple entries for the same item I want to chose from (ID - primary key is unique, just not the name of the item - 'FullP', and that...

I used Access 2003 developer extensions to create an application with the runtime included to distribute my program and really haven't had a problem until now. To uninstall the program you need to have the installation disc which contains the msi file. OK. A friend of mine installed the program...

I ran into this the other day and thought that I would post it here if anyone is interested. CodeLib is an application that helps you to easily find and information gathering. Support Notes, Code, Files, Pictures, Web, URL save. 6 in 1 Utility. A database for all your information. * A...

I just ran across this and found it interesting enough to post here for those who are interested. R' ------------------------------------------------------------------------ For years the company has been toying with the idea of taking the data store from SQL Server and porting it to...

I am considering playing music media files that can be used for presentations or stage appearances etc. The player used might have to be installed etc. on users machines, play the desired music and still have enough resources for Access to work correctly... any opinions? Thanks, Rick

This was thrown my way a little while ago... and actually it is old news :eek: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mdacsdk/htm/mdac_deprecated.asp When you go to the web page: In the left hand column: click on "Deprecated Components" Deprecated Components Each...