MDF to MDB

[Hakan Fatih YILDIRIM]

Ý have an mdf file with size of 11 gb. But i cannot attach mdf file
to
Sql server. beacuse my licence is limited on 4.096 mb. Ýs tthere a
way
to attach db? is tthere any tool to convert mdf file to mdb? so i can
delete some records on it and then try to attach again?

Best Regards
Hakan Fatih YILDIRIM

[Paul Shapiro]

An mdb won't help because it's limited to 2 GB. And you would need the mdf
running under some kind of SQL Server for Access to be able to extract any
data.

Maybe it's worth buying a copy of SQL Server Developer Edition, which cost
about $50 last time I looked? That version is licensed for development, but
has all the features of the Enterprise Edition. It's limited to a single
connection at a time, but it would let you work with your 11GB mdf. All SQL
2005 versions except the free Express version have unlimited db size.
Paul Shapiro

"Hakan Fatih YILDIRIM" <hf*********@gmail.comwrote in message
news:49**********************************@s13g2000 prd.googlegroups.com...
Ý have an mdf file with size of 11 gb. But i cannot attach mdf file
to Sql server. beacuse my licence is limited on 4.096 mb. Ýs tthere a
way to attach db? is tthere any tool to convert mdf file to mdb? so i can
delete some records on it and then try to attach again?

Best Regards
Hakan Fatih YILDIRIM

[Rad [Visual C# MVP]]

On Thu, 13 Mar 2008 11:47:56 -0700 (PDT), Hakan Fatih YILDIRIM wrote:

Ý have an mdf file with size of 11 gb. But i cannot attach mdf file
to
Sql server. beacuse my licence is limited on 4.096 mb. Ýs tthere a
way
to attach db? is tthere any tool to convert mdf file to mdb? so i can
delete some records on it and then try to attach again?

Best Regards
Hakan Fatih YILDIRIM

You could also download an evaluation versin of SQL Server and use that to
access your data. Although I ery much doubt that access can handle data of
that size
--
http://www.thinkersroom.com/bytes