Darryl Collins
Darryl.Collins at coles.com.au
Thu Jun 26 18:53:41 CDT 2008
Thanks Susan and Liz, Due to client restrictions (and they are a massive client - no wriggle room on this) it is SQL Server 2000 backend and Access 2000 Front End. I can live with ID numbers only - At least I now not to dig too hard to find a 'solution' when there isn't one. I am sure this will be the first of 1001 questions I have on this. Thanks for your time and patience. regards Darryl. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Thursday, 26 June 2008 10:45 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Linking Tables(?) FWIW, VB Express is free and easy to use and depending on your needs, might be a better choice for gui than Access. Susan H. > > You will find that there is nothing so form-like and user-friendly > available in SQL Server. If Table1 has got numeric ID fields in it, it > just has numeric ID fields in it, and you won't be able to hide this. > You can link your tables to your old friend Access and use that as a > front-end for nice GUIs, but SQL Server is about storage--relatively > large storage--and nothing else. No GUIs to be had. _______________________________________________ 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. 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.