Re: MySQL and Ms Access - a better description of the problem

2004-04-02 Thread Daniel Kasak
Patrick Kirk wrote: Hi all, I've installed the latest MDAC and Jet service packs on Windows 2000. On Linux I've the latest MySQL and MyODBC3.51. Using the ODBC Administrator I've set up a connection and made sure to check Don't Optimize columns width, Return Matching Rows, Allow BIG Results,

Re: MySQL and Ms Access - a better description of the problem

2004-04-02 Thread Patrick Kirk
Daniel Kasak wrote: Patrick Kirk wrote: [...] CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment, snipped That's your problem there. You can't have a bigint() column as a primary key when Access is being used. In fact you probably shouldn't have any bigints at all if

RE: MySQL or MS Access ?

2002-06-06 Thread Jay Blanchard
[snip] Lastly only a few people will be able to use you application before MS Access fails... Therefore limiting access to your mission critical applicaiton I do not really think MS Access is for Mission-Critical databases...but I guess that depends on ther definition of mission critical. Most

Re: MySQL or MS Access ?

2002-06-05 Thread Christopher Thompson
On Wednesday 05 June 2002 4:28 pm, Jay Liew wrote: Hello everyone, I am new to database operations, and I was wondering if there were any advantages or using MS Access to MySQL. Don't get me wrong, but I would prefer Open Source over proprietary, but this is a mission-critical

RE: MySQL or MS Access ?

2002-06-05 Thread Jeremy P. McKay
MS Access MS Office Based. It is has more graphic tools. Possibly more people will be able to manipulate the database since Access has very little security, this is not usually an advantage. Lastly only a few people will be able to use you application before MS Access fails... Therefore limiting

Re: MySQL or MS Access ?

2002-06-05 Thread Christopher Thompson
On Wednesday 05 June 2002 4:54 pm, Jeremy P. McKay wrote: I do not really think MS Access is for Mission-Critical databases...but I guess that depends on ther definition of mission critical. Most MCP will agree that MS Access does not scale well and offers little advantages for

Re: MySQL to MS' Access '97

2001-11-04 Thread sreedhar
¿ÿ^˜:ˆô[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

RE: MySQL to MS' Access '97

2001-11-03 Thread Todd Williamsen
I have done Access to mySQL, but not the other way around... I guess you would need to export the table to a CSV file then import it into Access. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: MySQL to MS' Access '97

2001-11-03 Thread Todd Williamsen
You can use phpadmin to control the database and there is an option to view dump into a CSV file either in MS Excel format or standard CSV file. Once you dumped it, you can then import it into Access Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original

RE: MySQL to MS' Access '97

2001-11-03 Thread Peter Lovatt
November 2001 14:05 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MySQL to MS' Access '97 You can use phpadmin to control the database and there is an option to view dump into a CSV file either in MS Excel format or standard CSV file. Once you dumped it, you can then import

RE: Mysql and MS Access

2001-04-02 Thread JHDrexler
Verify that you have a primary key and a DateTime Stamp field for your table. I do this with a Serial field {Serial int(11) not null Primary Key auto_increment} as the first field and {DateChanged (TimeStamp)} as the second field for each table that I intend on accessing from MSAccess.