Search found 8 matches
- Fri Oct 08, 2010 6:35 am
- Forum: General
- Topic: automation not working in logged out server state
- Replies: 0
- Views: 76838
Re: automation not working in logged out server state
not a quick reply, but most of the scheduling type problems are caused by permissions. I would start by verifying that your job is running as the user you think it is. it may be running as a system account that doesn't have rights. aslo be aware that it likely won't have access to any mapped drives,...
- Fri Oct 08, 2010 6:32 am
- Forum: General
- Topic: update not insert?
- Replies: 0
- Views: 75732
Re: update not insert?
This is more of a programming issue. for example bullzip won't know what data you have so it would not know what records to update vs insert. You might be better off importing the whole table into a temp area in mysql, then doing an update query from the temp to the production. using this method, yo...
- Fri Oct 08, 2010 6:25 am
- Forum: General
- Topic: Create table statement missing Primary Key
- Replies: 2
- Views: 114653
Create table statement missing Primary Key
Hi, I have an access database with a field used as a counter in Access it's defined as a primary key, type=autoNumber when I run Bullzip Access to mysql, it comes across as CREATE TABLE `PaperDocumentTracking` ( `Counter` INTEGER NOT NULL AUTO_INCREMENT, ) ENGINE=myisam DEFAULT CHARSET=utf8; When it...
- Sun May 30, 2010 1:43 am
- Forum: General
- Topic: Can the script sql file created be used with Phpmyadmin?
- Replies: 0
- Views: 17147
Re: Can the script sql file created be used with Phpmyadmin?
I'll answer my own question with the hope that it'll help someone else. Yes, it can be if it's small enough. Use the phpMyAdmin 'Import' feature - please note that depending on the options selected in Bullzip's Access to MySql, it's likely to drop the database and recreate it. so backup first. If th...
- Sun May 30, 2010 1:21 am
- Forum: General
- Topic: Date fields with default = now() in MS Access fail on MYSQL
- Replies: 2
- Views: 27320
Date fields with default = now() in MS Access fail on MYSQL
I came across a situation when trying to convert my Access database. The create tables generated had statements like Create table xxxx ( entrydate DATETIME NOT NULL DEFAULT 'now()', xxx xxx ) The create table statement fails, because the default value is invalid. Is it possible to have an option to ...
- Sun May 30, 2010 1:16 am
- Forum: Installation
- Topic: Convert Access without license for Access
- Replies: 0
- Views: 78084
Re: Convert Access without license for Access
I don't know how the converter was written so I can't say for sure, but... Years ago, Access's database format was the default for Microsoft Developers. They Distributed components such as DAO (Data Access Objects) which were able to read/write access .mdb files. It might be possible to uninstall Ac...
- Tue Mar 30, 2010 8:57 pm
- Forum: General
- Topic: Donation Amount
- Replies: 1
- Views: 14792
Donation Amount
Hi,
This is an awesome little tool.
I wonder if there's a suggested donation amount?
I have a number in mind, but I don't want it to be an insult to the developers.
- Jack
This is an awesome little tool.
I wonder if there's a suggested donation amount?
I have a number in mind, but I don't want it to be an insult to the developers.
- Jack
- Tue Mar 30, 2010 8:55 pm
- Forum: General
- Topic: Can the script sql file created be used with Phpmyadmin?
- Replies: 0
- Views: 17147
Can the script sql file created be used with Phpmyadmin?
Hi Sorry for the noob question,
I don't have direct access to the MYSQL install.
I used Access to MySQL to create a nice .sql file that has all the create table statements as well as insert statements. VERY AWESOME!
I'm wondering if there's a way to use this in phpMyAdmin ?
Thanks,
-Jack
I don't have direct access to the MYSQL install.
I used Access to MySQL to create a nice .sql file that has all the create table statements as well as insert statements. VERY AWESOME!
I'm wondering if there's a way to use this in phpMyAdmin ?
Thanks,
-Jack