Hi, From Control panel> Administrative Tools>Data Sources (ODBC) Add a new System DSN and select MS Access Driver. Cheers
On 11/15/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Ok really stupid question from a lowly consultant but how do I setup > OLE-DB using Access?? > > > AX 4.0 in written in Unicode, try OLE-DB instead of ODBC. > > > > > > > > > >>From: [EMAIL PROTECTED] <cfidler%40bs3.co.za> > >>Reply-To: > >>Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com> > >>To: > >>Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com> > >>Subject: [Axapta-Knowledge-Village] odbc > >>Date: Wed, 14 Nov 2007 13:15:37 +0200 (SAST) > >> > >>Hi All, > >> > >>I am using Ax4 SP2. on SQL 2005 SP2. > >> > >>Using Access Office 2007. Using the ODBC link I link Ax tables into > >>Access, however certain of my tables I am not able to see the data. > >> > >>Anyone come across this problem or know how to solve it? > >> > >>Regards > >> > > > > > > > > > -- Arijit Basu [Non-text portions of this message have been removed]