Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SQL and MS Access

Author  Topic 

tomislavg
Yak Posting Veteran

51 Posts

Posted - 2009-11-18 : 08:36:02
Dear guys, I would need your help.

I designed (or am in the process of) a db in SQL but I want MS Access to be frontend.
I already created some tables and linked them to SQL thru ODBC and it works great.

Just few questions I have:
- if I create a relationship in SQL will it be shown in Access (I mean data for data filtering? I tried to create a form in Access but also I had to create another (same) relationship in Access to be able to get linked data to a form.

- How do I run stored procedures, functions etc from Access. I know how to create them in SQL but programming in VB is my week side.

I hope I will get some answers.

All the best,
Tomislav
   

- Advertisement -