Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 6.0.061
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol 3.0.061
  HXTT DBF 6.0.064
  HXTT Excel 5.0.064
  HXTT Paradox 6.0.061
  HXTT Text(CSV) 6.0.062
  HXTT XML 2.0.061
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Beijing City (abbr, HXTT)

HXTT ACCESS
CREATE TABLE access 97
Jonatan Medina
2018-04-10 04:37:08.0
Could you help me?
I am creating a table with CREATE TABLE in access 97 and when I am going to open this table with MSOffice 97 it gives me the error Invalid argument

Regards
Re:CREATE TABLE access 97
HXTT Support
2018-04-10 05:42:34.0
What's your create table sql? Maybe it contains the unsupported data type in MS Access 97?

You can send us your database sample.
Re:Re:CREATE TABLE access 97
Jonatan Medina
2018-04-10 05:54:31.0
If the sql statement is:
CREATE TABLE linea1 (ID INTEGER, Surname VARCHAR (20), phone VARCHAR (10), Email VARCHAR (50))

I send you the database by email
Re:Re:CREATE TABLE access 97
Jonatan Medina
2018-04-10 05:55:51.0
The error occurs when creating fields of type varchar with non-numeric fields
Re:Re:Re:Re:CREATE TABLE access 97
HXTT Support
2018-04-10 06:51:04.0
Tried versionNumber=JET3

CREATE DATABASE ABC;
CREATE TABLE ABC.linea1 (ID INTEGER, Surname VARCHAR (20), phone VARCHAR (10), Email VARCHAR (50))

No issue. What's your error message?
Re:Re:Re:Re:Re:CREATE TABLE access 97
Jonatan Medina
2018-04-10 23:27:10.0
The error message it gives when I try to open the created table is an invalid argument.
If I do not add fields varchar works correctly
Re:Re:Re:Re:Re:Re:CREATE TABLE access 97
Jonatan Medina
2018-04-11 23:10:33.0
Could you give me an example to create an access97 database, with SQL?
In the documentation is only by URL, I would like on a unit for example c:
Re:Re:Re:Re:Re:Re:Re:CREATE TABLE access 97
HXTT Support
2018-04-12 00:05:54.0
For instance,
jdbc url: jdbc:access:///d:/test/access/issue3/?versionNumber=JET3

Then
select * from dia.linea1 /* seems normal for your sample */


CREATE DATABASE ABC;
CREATE TABLE ABC.linea1 (ID INTEGER, Surname VARCHAR (20), phone VARCHAR (10), Email VARCHAR (50)) /* Both of abc.mdb and dia.mdb can be opened by MS Access 97*/

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 1999-2017 Heng Xing Tian Tai Lab of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap