Database Index - SQL Wars - the battle for data

Database Index - SQL Wars - the battle for data

DATE: January 14th 2013
Walnut Creek CA-Knowing which database to choose is just as hard as choosing a database programmer or developer.  The leaders are Microsoft SQL Server, Oracle, IBM, SYBASE, Progress and then on down to smaller niche solutions. 

SQL Server 2012 is now a mature product - seasoned, tested but in use by the millions while tightly linked the dreaded Microsoft Licensing Model which requires a great of finesse to manage.  


To be continued .....  

Read More

Visual Studio Tools for Office

Microsoft Visual Studio Tools for the Microsoft Office System can help you take advantage of the productivity enhancements in the Microsoft .NET Framework version to extend applications in Microsoft Office.  

Below are links to all three versions VSTO 

Office 2013 and Office 2012 
You can extend Office 2013 and Office 2010 by using Office developer tools in Visual Studio. You can build two types of solutions: solutions that focus on web integration and solutions that target the .NET Framework and are more deeply integrated with the Office object model.

What's new for Office 2013 developers

Learn about the features and technologies of Office 2013 that are of interest to developers.

Applies to: apps for Office | apps for SharePoint | Office 2013 | Office 365 | SharePoint Foundation 2013 | SharePoint Server 2013  more

Read More

MS Access: ListBox Tricks

Contact Pete's Team 925-399-1082

MS Access Listbox Tricks and Traps
Code Link: Coming soon
Published: 10/01/2012



Simple List

Dropbox Folder Free Files

Read More

MSACC: Dir Paths and ShortCuts

Subject: finding the paths of an MS Access Project
Posted Under: Files, Directories and Path

Borrowed in part but extended from this posting:

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

Option Compare Database
Function g_GetFullName()
   'Returns full path including file to currently opened MDB or ADP
   g_GetFullPath = CurrentProject.FullName
End Function
Function g_GetPath()
   'Returns the path to currently opened MDB or ADP
   g_GetPath = CurrentProject.Path
End Function
Function g_GetFullConnection()
   'Returns the filename of the currently opened MDB or ADP
   g_GetFullConnection = CurrentProject.Connection
End Function
Function g_GetName()
   'Returns the name of of the currently opened MDB or ADP : returns "my app name.accdb"
   g_GetName = CurrentProject.name
  
End Function
' save time run all in one call
Function GetAll()
Debug.Print "con: "; g_GetFullConnection; vbCrLf
Debug.Print "PATH:  "; g_GetPath; vbCrLf
Debug.Print "name:   "; g_GetName; vbCrLf
Debug.Print "Full Path:   "; g_GetFullPath; vbCrLf

End Function

Read More