Use of Access for Server Side Programming

[krish]

Hi folks,

I am new to Access programming. I read in some web page on googling that Access is for developing Desktop database. Books inform that Access projects can connect to Server database.

I would like to know if Access can also be use for Server side programming.

- Krish

 

[WayneRyan]

Krish,

In the simplest sense, Access can use Linked Tables to make SQL Server
tables appear as if they're local Access tables.

But, "Server Side Programming" is a pretty vague statement. The "programming"
on the SQL Server side consists of the Stored Procedures, table Triggers, and
Views that run natively on the server. It's beneficial to have the data AND
most of the logic controlling it reside on the Server.

Using an ADO connection:

Access can create these things.
Access can modify these things.
Access can invoke these things.

hth,
Wayne

 

[krish]

Thanks Wayne.

- krish