Sql server database as source for Access form

[johnpallian]

Can we take sql server database as source for a Access Form on other system on the network?

 

[HiTechCoach]

Yes. It is possible to use Access as a front end form an SQL Server back end.

 

[Vassago]

You can use linked tables and pass-through queries to accomplish everything you need this way.

 

[madEG]

http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx

 

[johnpallian]

Thank you all for the replies, then, Please help me in setting a sql server database as a source to access form ( which is already designed ) using Access VB code.what is the code and syntaxes used to connect for a multi user access application.

 

[HiTechCoach]

There is no code required is you will created liked tables to the MS SQL Server. You can use the linked tables to the SQL server just like any other Access table.

The basic steps to upsize an access database to use SQl Server:

1) split your database into a front end and back end if not already done.
2) upsize the access back end to the MS SQL Server. Using the SSMA will do a lot of the work for you.
3) delete the linked tables to t he Access back end. Create linked table to the MS SQL Server back end.
4) If needed, rename all the linked tables to remove the dbo_ so that they match the original table names.

Your forms, reports, queries, etc will now use the MS SQL server tables.