Search found 8 matches

by basementjack
Fri Oct 08, 2010 6:35 am
Forum: General
Topic: automation not working in logged out server state
Replies: 0
Views: 45838

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,...
by basementjack
Fri Oct 08, 2010 6:32 am
Forum: General
Topic: update not insert?
Replies: 0
Views: 45052

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...
by basementjack
Fri Oct 08, 2010 6:25 am
Forum: General
Topic: Create table statement missing Primary Key
Replies: 2
Views: 76015

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...
by basementjack
Sun May 30, 2010 1:43 am
Forum: General
Topic: Can the script sql file created be used with Phpmyadmin?
Replies: 0
Views: 12259

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...
by basementjack
Sun May 30, 2010 1:21 am
Forum: General
Topic: Date fields with default = now() in MS Access fail on MYSQL
Replies: 2
Views: 22566

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 ...
by basementjack
Sun May 30, 2010 1:16 am
Forum: Installation
Topic: Convert Access without license for Access
Replies: 0
Views: 42367

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...
by basementjack
Tue Mar 30, 2010 8:57 pm
Forum: General
Topic: Donation Amount
Replies: 1
Views: 10786

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
by basementjack
Tue Mar 30, 2010 8:55 pm
Forum: General
Topic: Can the script sql file created be used with Phpmyadmin?
Replies: 0
Views: 12259

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