quote:

---

Originally posted by sunny_10

Hi

I am creating table like this but
It is giving me error on Windows 8 Basic "The Create Database Statement failed . The primary file must be atleast 3 MB to accomodate a copy of the model database

str = "CREATE DATABASE " & mydatabase & " ON PRIMARY " & _
"(NAME = " & "WeighBridge" & Mid(fyear, 1, 2) & "_" & Mid(fyear, 4, 2) & "_Data" & ", " & _
" FILENAME = '" & m_path & "Data\" & "WeighBridge" & Mid(fyear, 1, 2) & "_" & Mid(fyear, 4, 2) & ".mdf' , " & _
" SIZE = 2MB, " & _
" MAXSIZE = 20MB, " & _
" FILEGROWTH = 10%) " & _
" LOG ON " & _
"(NAME = " & "WeighBridge" & Mid(fyear, 1, 2) & "_" & Mid(fyear, 4, 2) & "_Log" & ", " & _
" FILENAME = '" & m_path & "Data\" & "WeighBridge" & Mid(fyear, 1, 2) & "_" & Mid(fyear, 4, 2) & ".ldf ', " & _
" SIZE = 1MB, " & _
" MAXSIZE = 10MB, " & _
" FILEGROWTH = 10%) "
confind.Execute (str)


Thanks

---