[dba-SQLServer] Imported data not seen

Darryl Collins Darryl.Collins at coles.com.au
Tue Nov 25 20:51:17 CST 2008

HI Jean-Paul,

Using a SQL Server Back and MS Access FE I have had this issue before when the table linked to the FE either hasn't got a KEYID or the KEYID type is not "int".

As for learning stuff, I have found the following book to be very helpful, although I don't think SQL Server is something you can learn overnight though...


good luck.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Sent: Wednesday, 26 November 2008 1:25 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Imported data not seen

Hi all,I'm stumped here , i have imported data into table (successfully) but when I open the application (GP in this case) I do not see the recordsI know I'm pretty new to SQL but if I see the record in the table,  shouldnt I see it in the app?ON another note-  does anyone know any GOOD  Crash course SQL books?          Jean-Paul Natola

Color coding for safety: Windows Live Hotmail alerts you to suspicious email. Sign up today.
Color coding for safety: Windows Live Hotmail alerts you to suspicious email.
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.

More information about the dba-SQLServer mailing list