mdf file

[basti42]

hello!
i am using .mdf file does anybody knows
what is the max. file size in .mdf? in access database it has a limit up to 2GB.
anonther info. i attached the .mdf in the prgram the same as using in access database

con = @"data source...\databse.dbf... ===> access
con = @"Data Source=.\SQLEXPRESS;AttachDbFilename=\database.mdf ==> mdf

tnx much

[basti42]

another is i want to connect it in crystal report
i use this in saving, edit, delete and insert and ti works fine
X:\CMQSTest\bin\Debug\CMQSTest.mdf
but in crystal report how?

tnx

[jmcilhinney]

SQL Server Express imposes a 4GB limit on databases, but MDF files can be much larger when accesses through SQL Server.

[basti42]

how about the question below?

i am using .mdf file, you can see this in adding in c# IDE(right click then new item then choose SQL database)
i use this in saving, edit, delete and insert and it works fine
X:\CMQSTest\bin\Debug\CMQSTest.mdf

but in crystal report how to connect the .mdf file?
under the field explorer of crystal report
i chose new Create New Connection in Database expert
i only using MS Jet 4.0 OLE DB (using access) in this .MDF file how?

note:
crystal report and SQL database (.mdf) both created in C# IDE

tnx