×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Using Enterprise Manager to mimic Queries in Access 2003

Using Enterprise Manager to mimic Queries in Access 2003

Using Enterprise Manager to mimic Queries in Access 2003

(OP)
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

RE: Using Enterprise Manager to mimic Queries in Access 2003

(OP)
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

RE: Using Enterprise Manager to mimic Queries in Access 2003

Quote (Donald ):

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

RE: Using Enterprise Manager to mimic Queries in Access 2003

(OP)
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:  

CODE

SELECT
Tbl_Project_List.Project_Id, Tbl_Project_List.Division_ID, Tbl_Project_List.Department_ID, Tbl_Project_List.Protocol_ID
FROM
Tbl_Project_List
WHERE
     ((Tbl_Project_List.Protocol_ID) Like "*CLINPRL*"));

 

SubForm Row Source:

CODE

SELECT
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]
FROM
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

RE: Using Enterprise Manager to mimic Queries in Access 2003

the SqlServer syntex is

CODE

WHERE  Tbl_Project_List.Protocol_ID Like '%CLINPRL%';

RE: Using Enterprise Manager to mimic Queries in Access 2003

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

Thanks in advance,
Donald

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close