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
 General SQL Server Forums
 New to SQL Server Programming
 How to link a form field in access to a db in sql

Author  Topic 

tkatende
Starting Member

8 Posts

Posted - 2011-11-08 : 15:49:36
Hello there,
How possible is it to point the source control of a form field in access to a table in sql server. e.g. client id field on
a form picking up records in a client id table in a sql database.
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-09 : 01:14:47
use a connection string where you specify server and db to connect to

see

http://blogs.msdn.com/b/ishabib/archive/2007/09/10/connecting-access-forms-and-reports-to-sql-server-2005.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -