Hi:
I am confused by the concept of "using Linked server for data access". (This is the article I am looking at, I don't know what is exactly trying to accomplish: http://www.aspfree.com/c/a/Microsof...d-Microsoft-Access-Server-on-SQL-2005-Server/ )
My questions are:
1. will the database created be an Access .mdb database? or a database in SQL server?
2. If the created database is .mdb, why we need it link to sql server? Does that mean my other application (ie: myAnotherMSApplication.mdb, or myDotNetWebApp.aspx can access the just created Access .mdb from that SQL server?
Thank you very much.
JT
I am confused by the concept of "using Linked server for data access". (This is the article I am looking at, I don't know what is exactly trying to accomplish: http://www.aspfree.com/c/a/Microsof...d-Microsoft-Access-Server-on-SQL-2005-Server/ )
My questions are:
1. will the database created be an Access .mdb database? or a database in SQL server?
2. If the created database is .mdb, why we need it link to sql server? Does that mean my other application (ie: myAnotherMSApplication.mdb, or myDotNetWebApp.aspx can access the just created Access .mdb from that SQL server?
Thank you very much.
JT