Ana içeriğe atla

SharePoint 2010 - Access 2007 with Office 14

I hit a bug last night which was due to mixing some ADO and DAO code within a VB form inside an Access 2007 database. This had been working well until I moved it on to a laptop that had SharePoint Designer 2010 and SharePoint 2010 in Development mode installed. The operating system is Windows 7 ultimate 64 Bit but SharePoint designer and all of My office 2007 components are 32 bit.

The error is simply that Access crashed (no error message just your database is being restarted) on a line in code where I was creating a new ado recordset.

Comparing the references to a to a working version of the database on a similar machine which has no Office 14 components I noticed that the DAO or ACE reference was set to Microsoft Office 14 Access Database Engine Object Library on the working machine it was set to Microsoft Office 12 Access Database Engine Object Library. No problem I thought I would reset the reference to the 12 version. I navigated to the ‘C:\Program Files (x86)\Common Files\microsoft shared\OFFICE12\acedao.dll’ and it seemed to accept it but when I look at the references it has referenced 14 again. 

Mixing dao (ace) and ado isn’t wise so I removed the ado code and the database is now working on the laptop with SharePoint Designer installed.To be sure I have removed all ado code I simply removed the reference to the Microsoft ActiveX data objects library ran a debug compile and fixed the errors by replacing ado with dao code.

Yorumlar

Bu blogdaki popüler yayınlar

SharePoint 2010 - Content Query for Blog Posts

I hope this post will help many of you feel comfortable with using the Content Query Web Part. In this post I will walk you through the process of creating a content query web part and configuring it to show custom field types. I will also give details on how to use XSLT to stylize and format the data being pulled. I will be using the following scenario as an example. Say that you had a site collection with a top level publishing site. This publishing site would display a the most recent blog posts from all blog sites within its own site collection. To solve this problem we will use a Content Query Web Part and a customized ItemStyle.xsl using XSLT. Please note that the “SharePoint Server Publishing Infrastructure” needs to be enabled at the site collection to display the content query web part. Step 1: Add a Content Query Web Part to Page Navigate to the site that you want the blog posts to show up and click on edit page. Under Editing Tools in the Ribb

.Net 3.5 SP1 – Full Install Packages (Tam Kurulum)

.Net Framework 3.5 SP1 ‘i bilgisayarınıza kurmak istediğinizde normal şartlar altında Microsoft ‘un sitesinde 2.7 mb ‘lik bir dosya indirir ve kurulum işlemlerinizi bu dosya üzerinden yaparsınız. Ancak bu indirmiş oluğunuz dosya yaklaşık 220 mb ‘lik veriyi internetten indirerek kurulum yapmaktadır. İnternet çıkışına izin verilmeyen kurumlar ve kuruluşlar için bu durum bir sıkıntı oluşturmaktadır. Bu sebepten ötürü aşağıdaki link yardımı ile tam yükleme paketini indirdikten sonra hiç internet ihtiyacınız olmadan .Net 3.5 SP1 ‘i kurabilmeniz mümkün olacaktır. Link

Microsoft .Net Framework 3.0 & 3.5 Full Download

.Net ile yazılım geliştiricilerin özelliklede Framework 3.x ile geliştirenlerin başlıca sorunu kurulum dosyası hazırladıklarında .Net Framework ‘ü kurmak için internete bağlanmalarıdır. Çünkü kurulum dosyaları 2-3 MB arasıdır. Yavaş internet kullanıcılarında ve kurumsal şirketlerde projelerin çok ama çok geç kurulmasına sebep olmaktadır. Bu sebepten ötürü sizlere .Net 3.x Framework ‘lerin tam kurulabilir paketlerinin linklerini sizlere sunuyorum. Umarım yararlı olur. Microsoft .NET Framework 3.5 Setup 32-bit version (Boyut(Size): ~200MB Microsoft .NET Framework 3.0 Setup 32-bit Version (Boyut(Size): ~50MB) 64-bit Version (Boyut(Size): ~90MB) Herkese iyi çalışmalar, kolay kurumlar diliyorum. :)