Using Enterprise Manager to mimic Queries in Access 2003

[dnfrantum]

I am using Access 2003 and MS SQL Server 2005. I got the message:
This version of Microsoft Office Access doesn't support design changes with the version of Microsoft SQL Server your Access project is connected to.

I read in another post that Access 2003 isn't fully supported by MS SQL 2005, so I am clear on that front. I still have the need to recreate the environment, so I would like to get some insight from a GURU.

I have a Form and a SubForm. I am able to return all of the rows to the subform as an independent form, but when I try to load the form and subform, I get a syntax error.

I can write a stored proedure or view through the enterprise manager if required, but
A. I am not sure what is required, and
B. if this is required, which would it be and how would I connect it to the form?

I appreciate any insight or guidance offered. If you could suggest an answer or more resources for me to review, I would be grateful.

Thanks in advance,
Donald

 

[ajrimmer]

You need M$ SQL Server Management Studio for SQL Server 2005.

There's an "express" (free) version here: http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

 

[dnfrantum]

Thanks for your reply.

I have SQL Server Management Studio for SQL Server 2005.

My question is, how do I turn the queries in the form and subform into a stored procedure or view or whatever is required here. If I know what is required and how to connect it, I am sure I can do it.

Thanks in advance,
Donald

 

[PWise]

I have a Form and a SubForm. I am able to return all of the rows to the subform as an independent form, but when I try to load the form and subform, I get a syntax error.

What is the error?
what are the row source of the form and the subform what are the link parent link child fields

 

[dnfrantum]

The error I receive is the error above in green:

Here is the row source for both the form and subform as well as the link:

Form Row Source:

[COLOR=blue]SELECT[/color] 
Tbl_Project_List.Project_Id, Tbl_Project_List.Division_ID, Tbl_Project_List.Department_ID, Tbl_Project_List.Protocol_ID 
[COLOR=blue]FROM[/color] 
Tbl_Project_List 
[COLOR=blue]WHERE[/color] 
     ((Tbl_Project_List.Protocol_ID) Like "*CLINPRL*"));

SubForm Row Source:

[COLOR=blue]SELECT[/color] 
Tbl_Protocols_List.Project_ID, Tbl_Protocols_List.Protocol_ID, Tbl_Protocols_List.Protocol_Number, Tbl_Protocols_List.Study_Type_ID, Tbl_Protocols_List.Phase_ID, Tbl_Protocols_List.Compound_ID, Tbl_Protocols_List.TA_ID, Tbl_Protocols_List.Indication_ID, Tbl_Protocols_List.Program_Level_PM_ID, Tbl_Protocols_List.SM_ID, Tbl_Protocols_List.PA_ID, Tbl_Protocols_List.GPL_ID, Tbl_Protocols_List.[Assistant GPL_ID], Tbl_Protocols_List.[Start-Up Year], Tbl_Protocols_List.[Close-Out Year] 
[COLOR=blue]FROM[/color]
Tbl_Protocols_List;

Parent Field Link: Project_Id from the Tbl_Project_List

Child Field Link: Project_ID from the Tbl_Protocols_List



Thanks in advance,
Donald

 

[PWise]

the SqlServer syntex is

WHERE  Tbl_Project_List.Protocol_ID Like '%CLINPRL%';

 

[dnfrantum]

I made that change, but I still got the error and I was not able to save the changes.

Thanks in advance,
Donald