--- In [email protected], "shaetal" <[EMAIL PROTECTED]> wrote: > > Hello, > > I am trying to create a linked table in Access 2007 using a form from > AR Remedy application. > > When I run the query I get an ODBC Call Fail error and the following > values show up in the columns "#NAME?". > > Does anyone know what i need to do is to actually pull data values. > > Here's the query that runs > > SELECT [Query].[Client], [Query].[Case_#], [Query].[Assigned_WorkTeam], > [Query].[Date_Time_Created], [Query].[Severity], [Query].[Status] > FROM [Query]; > >
You have to link the table into Access before you can create a query on it. Use the Linked Table Manager. Once you can see the Linked Table in your Tables list, then you can query it from the form. > thanks for all your help in advance > > shaema >
