Linking a form to SQL server

[odomene]

Any help will be appreciated. I am try to link a form to the database created in SQL server using ODBC connection string in the form properties. And i cannot figure out why the form is not populating. please help.

 

[SQL_Hell]

Why not link the sql server table? then use the linked table as the forms record source

 

[MSAccessRookie]

Why not link the sql server table? then use the linked table as the forms record source

You can use an SQL server View as the Record Source for the Form as well. You use it the same way that you would use an Access Query.

 

[SQL_Hell]

You can use an SQL server View as the Record Source for the Form as well. You use it the same way that you would use an Access Query.

Yes indeed you can, I am not quite sure what you are saying here?

 

[MSAccessRookie]

Yes indeed you can, I am not quite sure what you are saying here?

Just presenting another option, since most of my Forms have been based on Queries and Views, Not Tables.

 

[SQL_Hell]

Ok no problems, bearing in mind I very rarely use access nowadays...

I always thought in a .mdb that the only way to use a view is to open a ado connection in code and set the forms record source to the view or select * from the view.

Where as a table can just be linked in the linked table manager and the forms record source can be "select * from linkedtable" which is essentially a view anyway.

 

[MSAccessRookie]

Ok no problems, bearing in mind I very rarely use access nowadays...

I always thought in a .mdb that the only way to use a view is to open a ado connection in code and set the forms record source to the view or select * from the view.

Where as a table can just be linked in the linked table manager and the forms record source can be "select * from linkedtable" which is essentially a view anyway.

You can also Link to an SQL Server View The same way that you would link to a Table. Access sees a Table that contains data, and SQL Server sees a View that provides a selection of data from one or more tables. We do it all of the time im my project.

 

[SQL_Hell]

Yeah you're right, you can do that.

I'm sure I remember not being able to do this in the past, oh well maybe I imagined it