I just need something cleared up.
In web pages can connect to a sqlserver database, i do this all the time and have now problem with that.
you can also connect to the .mdf file. This is where i am confused. can you connect to the mdf file in the same way you would connect to a access(mdb) file or do you still need sql server running on the machine where the mdf is.
I am not really looking for a connection string, I'm looking for a clear explaination of what is going on and the reasons or different uses for this.
And no, Access does not use SqlServer, it uses a database server embedded by microsoft