Skip to main content

SQL Server 2005 and Access 2003

Our flagship app, ParaPlan, has been running on SQL 2000 for over 2 years now. Before we re-design everything in .NET, I wanted to see if I could get it to work with SQL 2005 (as is). My attempts thus far have led to the following: 05 has many more INFORMATION tables and SYS tables associated with each database. I have MUCH MUCH more to learn, but I know that I could get an 05 SQL db attached to an Access front end, but I am having trouble with permissions (to the best of my knowledge). So as I learn more and/or hear from someone, stay tuned.

Comments

Popular posts from this blog

The Ole Village Greens Golf Course

Peez took me out to one of our old college favorites 2 weekends ago.  The course is called THE VILLAGE GREENS and it resides in lovely Ozawkie, KS near Perry Lake.  We played this course quite a bit in our later days in college because it was cheap and fun.  All we had was Alvamar when we were at KU and she’s a little pricey for college kids.  Anyway, it was humid and hot but good times.  After, we stopped in Oskaloosa to watch the final round of the PGA at some local ‘downtown’ bar called Angie’s?

File Sharing Lock Count Exceeded

When processing large transactions within a Microsoft 'split-database' application, you may receive the above error.  The MS 'split-db' in Access is not a true client-server solution, it is a file-server solution that can lead to this error/issue. To avoid this issue you need to manually change a registry setting for MS Jet 4.0.  Set the value to at least 1,000,000,000 and follow the Method 1 instructions linked to here:  http://support.microsoft.com/kb/815281

Google Play (Music) Keyboard Shortcuts

Space bar : play or pause music. Right/left arrows : next/previous songs. Shift+ right/left arrows : seek forward and backward S In the current song. /  :  search box Delete : delete track. p : create a new playlist. i -:make an instant mix from the current song. = : Increase the player volume. - : Decrease the player volume. Alt+= : thumbs up. Alt+- : thumbs down. s : Toggle shuffle on or off. r : Toggle repeat between off, all, and one. e : Edits the currently selected songs.