Charlotte Foust
cfoust at infostatsystems.com
Wed Nov 15 10:00:44 CST 2006
The code is just a way to open and then manipulate another database from the current one. What is it that you want to happen? If you try to work with dbMyDB after that line, does it throw an error? If not, then it's working. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary J. Giever Sent: Wednesday, November 15, 2006 7:41 AM To: accessd at databaseadvisors.com Subject: [AccessD] Open a database This is frustrating. All I want to do is open another database from the currently open database. The code is like the help examples: Dim dbMyDB As Database Dim strDBName As String strDBName = "C:\My Documents\ClientMasterUpdate.mdb" Set dbMyDB = DBEngine.Workspaces(0).OpenDatabase(strDBName) But nothing happens. What am I missing? Gary J. Giever, M.A. Applications Developer ACCMHS _______________________________________________ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com