Michael Maddison
michael at ddisolutions.com.au
Tue Jun 13 19:10:46 CDT 2006
Hi Chester, If I get what your asking right... Automation? Try GetObject to get a handle on a current Access session. I think Access is an automation server. So in theory it should be possible. You may need to store the array as a global (hehe), just kidding... The array could be returned from a function call or as a property of a class. BTW I may be completely wrong and I would probably take a different approach. I can't imagine why you would want to do this? Why can't VB build their own array. Whats the problem this person is trying to solve? cheers Michael Maddison DDI Solutions Pty Ltd michael at ddisolutions.com.au Bus: 0260400620 Mob: 0412620497 www.ddisolutions.com.au -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Wednesday, 14 June 2006 1:30 AM To: Access Developers discussion and problem solving Subject: [AccessD] Access Array in VB Is there a way in VB to access (get to rows and columns) an array stored in MS Access? A person working in VB asked and I have no idea. You ideas please. Thanks. Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com