How to create mdb in sql server

How to create access mdb file in sql server?Hi
I think you are referring to access mdb.if tht is the case, sql server can
be connected to access
1) having mdb and linking mdb with sql tables
2) using adp, and putting data in sql server with access front end(Best)
3) Pass through queries
see access help fro connection to sql server( very simple like file> link
table > )
r.d
"Cogo" wrote:

> How to create access mdb file in sql server?
>
>|||Hi,
Both Access and SQL Server are seperate databases and have lots of
architectural diffirences. From SQL Server you can create only SQL Server
databases.
Create Access database (MDB) from MS Access.
For accessing Access database from SQL Server you could create a Linked
server between SQL Server and Access.
Thanks
Hari
SQL Server Mvp
"Cogo" <cogohan@.gmail.com> wrote in message
news:Orbx7HxnFHA.1968@.TK2MSFTNGP14.phx.gbl...
> How to create access mdb file in sql server?
>
>|||Do you mean how do I create a database in SQL Server? If so then look
up CREATE DATABASE in SQL Books Online
(http://msdn.microsoft.com/library/d... />
e_1up1.asp).
MDB is the typical extension of an MSAccess data file. Microsoft SQL
Server is structured completely differently to MSAccess (it's a true
RDBMS - relational database management system). The closest concept is
the data files & log files underlying the physical database. These
normally have extensions of MDF & NDF for primary & secondary data files
respectively, and LDF for log files, but they can be anything you decide
when you create the database with the CREATE DATABASE T-SQL statement.
HTH
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Cogo wrote:

>How to create access mdb file in sql server?
>
>
>sql