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, ran the test and
all appears well. I then link to the MySQL tables from Access and again
all appears well. Until I open the table and see that all data is
marked "#DELETED".
To test, I run a few queries which should bring back one record. They
all work.
So Access sees the data but cannot dispaly it. The table does have a
primary key and timestamp - its SQL follows:
CREATE TABLE `tblContacts` (
`p_ID` bigint(11) NOT NULL auto_increment,
`p_Company` int(11) default '2',
`p_FirstName` varchar(255) default NULL,
`p_LastName` varchar(255) default NULL,
`p_JobTitle` varchar(255) default NULL,
`p_DirectLine` varchar(255) default NULL,
`p_Mobile` varchar(255) default NULL,
`p_HomeNumber` varchar(255) default NULL,
`p_WorkEmail` varchar(255) default NULL,
`p_PrivateEmail ` varchar(255) default NULL,
`p_Notes` varchar(255) default NULL,
`p_CandidateCV` mediumblob NOT NULL,
`p_EHR_CV` mediumblob NOT NULL,
`p_Grouping` enum('None','Ma nager','Develop er','Producer') NOT NULL
default 'Developer',
`p_CoreSkill` enum('None','C+ +','C#') NOT NULL default 'C++',
`c_timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`p_ID`)
) TYPE=MyISAM AUTO_INCREMENT= 60 ;
Can anyone suggest why Access is not displaying the data correctly? 3 1604
Patrick wrote: Hi all, CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment,
Access can't display BIGINT - a simple change to mediumint fixed the
problem.
Thanks to all who gave this some thought.
Patrick wrote: Hi all, CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment,
Access can't display BIGINT - a simple change to mediumint fixed the
problem.
Thanks to all who gave this some thought.
Patrick wrote: Hi all, CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment,
Access can't display BIGINT - a simple change to mediumint fixed the
problem.
Thanks to all who gave this some thought. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.
I'd like to give her the facility to export the information in her local
Access application to the shared...
|
by: Wolfgang Kaml |
last post by:
Hello All,
I have been working on this for almost a week now and I haven't anything up
my sleeves anymore that I could test in addition or change....
Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue,
I am posting this on all of the three newsgroups.
That's the setup:
Windows 2003 Server with IIS and ASP.NET...
|
by: Patrick |
last post by:
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, ran the test and
all appears well. I then link to the MySQL tables from Access and again
all appears well. Until I open the table and see that all data is...
|
by: totierne |
last post by:
comp.databases.ms-access,
I want to know how to use Oracle views with session variables in
Access.
The parameterised views in access, are migrated to views with per
session
variables.
The open questions:
How to display a resultset
|
by: dubing |
last post by:
Hello,
Here is what we need to do. On a Linux Apache server, we need to
write PHP or Perl scripts to pull the data directly from the Access
database and display extracted data on the web. Anybody have done that
and would like to share how?
I've looked dbmtools. But it seems to be a command line based tool.
Also it's good for...
| |
by: somersbar |
last post by:
im trying to get a basic ASP.NET application running. im trying to
display data from a microsoft access database on my web form. im trying
to bind the data to a data-grid. but i get the following error wen i
try and run it:
ERROR Data source name not
found and no default driver specified
Description: An unhandled exception occurred...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never...
|
by: Greg Strong |
last post by:
Hello All,
The short questions are
1 Do you know how to make DSN connection close in Access to Oracle 10g
Express Edition?
&/or
2 Do you know how to make a DSN-less pass-through query work from
|
by: amritranjan |
last post by:
How to retrive image file from MS access database and display this in another JSPpage
--------------------------------------------------------------------------------
This is my Jsp code for image upload in database:
-----------Upload.jsp----------------
<html>
<head>
<title>Account Details </title>
|
by: Luting |
last post by:
Hi,
Is it possible to update oracle via Access forms?
I am thinking maybe I could make a link table connnected with oracle
database. And the form could be based on the link table. Does this
sound feasible?
Any better ways?
Thank you.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |