Martin Reid
mwp.reid at qub.ac.uk
Sat May 6 05:41:10 CDT 2006
I am sorting this myself but was wondering what you think about this and any non obvious solutionsyou may have? I have a field containing value1; value2; value3 Breaks all notions of relational design. The table is a table project associated with many developers. In the Project Task Name Field the values are the developer names associated with the projects. Is it possible in code to Break out the developer names and populate a table properly. This is Access 2007 and SQL Server 2005. The data is in SQL Server 2005 You response may be reused but full credit will be given. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of MartyConnelly Sent: Sat 06/05/2006 01:46 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Enumerate SQL Servers You might have problems with SQLDMO on SQL 2005 as it has been supplanted with SQLSMO and you might have to use WMI, I haven't checked the differences. Martin Reid wrote: >Thanks James. > >Just did something similar for the actual database names which is step 2. Idea is combo 1 lists the servers, then combo 2 lists the databases on each server. > > > >Best Wishes > > >Martin > >Martin WP Reid >Training and Assessment Unit >Riddle Hall >Belfast > >tel: 02890 974477 > > >________________________________ > >From: accessd-bounces at databaseadvisors.com on behalf of James Barash >Sent: Fri 05/05/2006 20:36 >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] Enumerate SQL Servers > > > >Martin: > >Here is a example which should work in Access. You will need to reference >the SQLDMO library to make it work. > > Dim oApp As SQLDMO.Application > Dim oNames As SQLDMO.NameList > Dim oName As Variant > > Set oApp = New SQLDMO.Application > Set oNames = oApp.ListAvailableSQLServers() > For Each oName In oNames > cboServers.AddItem oName > Next > >Hope it helps. > >James Barash > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid >Sent: Friday, May 05, 2006 3:05 PM >To: Access Developers discussion and problem solving >Subject: [AccessD] Enumerate SQL Servers > > >Anyone got an example of populating a drop down list in Access with all >available SQL Servers? >I am building a new login procedure. > >Martin > > > >Martin WP Reid >Training and Assessment Unit >Riddle Hall >Belfast > >tel: 02890 974477 > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> <http://www.databaseadvisors.com/> > > > > >------------------------------------------------------------------------ > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05/05/2006 > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>