O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting Data Services in Access

Now that you have a usable BDC model definition XML file, let’s import it into Access. As we discussed previously, Access understands how to expose Read List Operations or Default Finder of a BCS Entity. Behind the scenes, Access loads a small managed Dynamic Link Library (DLL), which is the BCS client. Access sends the BCS client the BDC model file and asks for the Finder method. The BCS handles the communications, authentication, and authorization with the remote data source, all according to the specifications in the BDC model file.

Let’s take a look at how Access creates these linked lists from a BDC model file in a new Access database file. Start Access, click Blank Database on the New tab of the Backstage ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required