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,
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
[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
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
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
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
¿ÿ^:ô[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
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
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
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
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.
11 matches
Mail list logo