.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

vb 2010 64 bit Office 2010 Access

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :WPF
 

I have an application in vb2010 Professional that reads and writes to Access and Excel. It works with Office 2010 32 bit but I have a client who creates huge spreadsheets and would like Office 64 bit.

I think in vb2010 I can target a 64 bit machine. How do I communicate with Access 2010?. My current code is:

Try
            con1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = C:\VB\Test VB RWC.accdb "
            con1.Open()

            StrSql2 = "SELECT * from materials order by materials.name"

            db = New OleDb.OleDbDataAdapter(StrSql2, con1)
            db.Fill(ds1, "MDataSet")

            'txtName.Text = ds1.Tables("MDataSet").Rows(0).Item(1)
            Me.DGV1.DataSource = ds1

etc. etc

I assume once I fill the dataset I manipulate it the same as office 2007.

         I am an engineer programmer s


View Complete Post


More Related Resource Links

Migrate/Upgrade from Office 2003 (Excel, Access...etc) to Office 2010

  

Hello,

We are about to begin a project to upgrade our MS-Office suite from 2003 to Office 2010.  This will include the migration of a large number of excelwork books with macros and access database and forms,   Is there an established (or tried and true) process for conducting the analysis work to determine if the excelwork books require individual attention (evaluation, conversion and testing) or can be converted in bulk?

Are there any know issues?  

Our company have a strong support relation with microsoft, Does any one know the perfect person who did similar kind of work or can help to do this?

Thanks, Vijay

 


Problem using Office 2010 64 bit driver for MS Access

  

I've a 64 bit SSRS 2008 R2 server. My goal is to provide user the capability to create a report against Access 2003. In order to do that I am installed  Office 2010 64 bit driver for MS Access from the following site: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d. The driver got installed just fine, when I try a UDL, I do see the option: Microsoft Office 12.0 Access Database Engine OLE DB Provider. But when I try to create a Data Source in SSRS, I do not see that provider under OLEDB. Can anyone suggest what I should do? 

Thanks!


GBM

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010

  

SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010


Office Services: Merging Word Documents on the Server Side with SharePoint 2010

  

Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010


Usage of Client Access Policy and crossdomain xml for sharepoint 2010>?

  

Hi Folks,

1.What is Clientaccesspolicy.xml in sharepoint ?

2.What is Crossdomain.xml ?

What is usage of wcf service deploy in sharepoint 2010?

Kindly give me some valuable comments ?

 

Thank you

Regards

Immanuel c

 


In sharepoint excel working fine in office 2007 but not in office 2010

  

Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.

 

This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.

 

Can you let me know why is problem is coming and how to resolve this.

 

Thanks

Sanjeev Tiwari

 


Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

  
In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Developer Training: Data Access in Technologies in SharePoint 2010

  
Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

  
The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

Office 2010 Mobile Service Guidelines, Part 1

  
Learn how to build and host Web services for Office 2010 Mobile Service (OMS). This article introduces OMS architecture and the message flow between OMS Web service providers and clients.

Office 2010 Mobile Service Guidelines, Part 2

  
Find guidelines and recommendations for implementing an OMS Web service as you learn to build and host Web services for Office 2010 Mobile Service.

Office 2010 Mobile Service Guidelines, Part 3

  
Learn about the XML schema for data that is passed between Microsoft Office 2010 Mobile Service Web providers and OMS clients in Office 2010.

Creating Web Databases with Access 2010 and Access Services (Visual How To)

  
Watch the video and explore code as you learn how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010.

Sample: Creating Web Databases with Access 2010 and Access Services

  
Explore the code in this visual how-to article as you learn how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010.

Video: Creating Web Databases with Access 2010 and Access Services

  
Create an Access 2010 Web database and publish it to SharePoint Server 2010 by using Access Services. (Length: 7:45)

Sample: Connecting to a .NET Framework Source Using Business Connectivity Services in Office 2010

  
Explore the code in this visual how-to article as you learn to learn how to use Visual Studio 2010 to create a BCS external content type.

Connecting to a .NET Framework Source Using Business Connectivity Services in Office 2010 (Visual Ho

  
Watch the video and explore code as you learn how to use Visual Studio 2010 to create a BCS external content type. The external content type then connects to a .NET Framework assembly that uses XLINQ to provide read-write access to data that is stored in a simple XML data file.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend