Mayb the question i ask is stupid. But i really dunno... LOL

1. How to create *.mdf for SQlServer? and How to open it (using wat kind of programs, prehaps) ?

2. My company is using SQL Server, can i use Access as my database of my pages? and How to do the connection string with the server?

Thanks.

1) To create database - using TSQL
http://msdn.microsoft.com/library/de...reate_1up1.asp

You can use Enterprise manager to open the database even to create that.
Enterprise Manager(EM)--> expand your "Server" --> expand "Database", you will find your database there(If created). Else right click and click "New database"... and proceed from there.

2) It depends up on your requirements and limitations to go with ACCESS or SQL Server. It is your call anyways.
for connection strings you can check http://www.connectionstrings.com

Hope that helps
Cheers!

-Vijay G

That mean, however my company server is SQL, but i still can use Access database to ceate my data. It all depend on wat is my connection string. Right?

Thanks for help

I am not sure, why you wanted to use ACCESS when your company is using SQL server.

May be dont have permissions to work with SQL server, but remember that SQL statements that you use for ACCESS databse is not always the same with that you could use for SQL server. There needs to be some slight changes done to the SQL statements in case you wish to you port your data from ACCESS to SQL server in future.

Yes, you are right, depending on the connection string you can get connected to either SQL or ACCESS.

Hope that helps.
Cheers!

-Vijay G