[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...

http://www.amazon.com/Microsoft-Access-Developers-Guide-Server/dp/0672319446/ref=sr_1_1?ie=UTF8&s=books&qid=1227667773&sr=8-1

good luck.

Cheers
Darryl.



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
jean-paul
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.
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_safety_112008
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.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