🚀 go-pugleaf

Try save these strings into test.js file and execute it:

//--------------------
var connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;";

var cat = new ActiveXObject("ADOX.Catalog");
cat.Create(connStr);
cat = null;

var conn = new ActiveXObject("ADODB.Connection");
conn.Open(connStr);

conn.Execute("Create table [MyTable] ([Field1] Float, [Field2] Float)");
//---------------------

If it does not work, update your MDAC (http://www.microsoft.com/downloads/)
and Jet SP (http://www.microsoft.com/data/).

For help on MS Jet (MS Access) SQL look for file jsetsql40.chm if you have
MS Office installed. It may be located at: "C:\Program Files\Common
Files\Microsoft Shared\Office10\XXXX\JETSQL40.CHM", where XXXX is language
id, 1033 for US English.

//----------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)



"Daniel" <admin@netcomm.com> �������/�������� � �������� ���������:
news:3f9321e3$1@newsgroups.borland.com...
> Thanks for your help Viatcheslav,
>
> but unfortunately the data_type 'Float' doesn't work when using it with a
MS
> Access database.  I have been searching endlessly to find documentation
for
> this, but can't seem to find anywhere where it clarifies the data_types
> available when operating with a MS Access database.
>
> the data_types I have been using so far (unsucessfully) are: Float,
Double,
> Decimal(n,m), Long Integer, LongInt, Long.
>
> I have a feeling that I have to first set the field to Integer than
somehow
> change it the type of integer to be a Double, but I can't seem to work out
> whether this theory is correct.
>
> If anyone is a wiz with MS Access and/or know of a book or web site that
may
> assist in this area than I would more than greatful.
>
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:3f8fafca@newsgroups.borland.com...
> > CREATE TABLE myTable(Field1 Float, Field2 Float)
> >
> > You may find info on column types in documentation for your DBMS.
> >
> > //----------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> >
> > "Daniel" <admin@netcomm.com> �������/�������� � �������� ���������:
> > news:3f8f3925$1@newsgroups.borland.com...
> > > Does anyone know how to create a table with a Number of type Double as
a
> > > field.
> > >
> > > CREATE TABLE mytable (Field1 data_type, Field2 data_type)
> > >
> > > what is the data_type for creating a field of type Double?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>