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.