Guest_imported
New member
- Jan 1, 1970
- 0
Hi Everyone,
I'm kind of having a problem with converting and Access database properties into MySQL.
In Access I have tables that have 'autoref numbers', 'default values', 'Date/Time default values i.e. Now()' - But when uploading the table through MyODBC into MySQL all those formats are now missing. The default values aren't working and the autonumber fields have become 'number' fields, plus my Primary Key has dissapered!
As I am trying to get a new server and a stabler database going I would appreciate any responses on the matter. Thanks.
I'm kind of having a problem with converting and Access database properties into MySQL.
In Access I have tables that have 'autoref numbers', 'default values', 'Date/Time default values i.e. Now()' - But when uploading the table through MyODBC into MySQL all those formats are now missing. The default values aren't working and the autonumber fields have become 'number' fields, plus my Primary Key has dissapered!
As I am trying to get a new server and a stabler database going I would appreciate any responses on the matter. Thanks.