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

Show quoteHide quote

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


Show quoteHide quote

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/default.asp?url=/library/en-us/tsqlref/ts_create_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

Show quoteHide quote

I smell a big, fat compiler bug
How do you rate this script
SET ROWCOUNT!
Table scan on 0 record temp table?
Parsing a TEXT column in an SP or trigger (SQL SERVER 2000)