access connections

[Wendy Elizabeth]

I want to setup access that will have 'screens' where users can enter car
loan application information. I want this information to be saved in access
once the save button has been hit. I want this data to connect to a .net WCF
server and/or a service broker application that is hosted on a sql server
2005 database.
Can you tell me if this feature is available in access? Would this be like
a 'hyperlink'? If this feature is available in access, can you tell me how to
accomplish this task?

Also if this kind of a feature is available, can I email an access
database that has the above functions listed to a user that may or may not
have (some version of access) on their workstation? Would e-mail servers
allow this type of access database be e-mailed to users without removing the
access database?
Thanks!

 

[Klatuu]

You can connect to an SQL Server database. It is not done with a hyperlinks.
It is done with an ODBC driver. As to the data being available to another
application, you would have to know the data structure of that application to
be able to provide it data.

An Access application required either a full installation of Access or the
Access runtime which is available in the Visual Studio for Office product.