G Guest Apr 23, 2004 #1 In my Access 2000, I don't find Database type when I write VBA as: Dim db As Database A runtime type error is seen. Why ?
In my Access 2000, I don't find Database type when I write VBA as: Dim db As Database A runtime type error is seen. Why ?
R RobFMS Apr 23, 2004 #2 The default for a new Access 2000 database is the ADO object module. If you wish to use the DAO object module: 1. Open up a code module 2. Go to Tools->References 3. Find Microsoft DAO 3.x Object Library. At this point you can do: Dim dbs as DAO.Database -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The default for a new Access 2000 database is the ADO object module. If you wish to use the DAO object module: 1. Open up a code module 2. Go to Tools->References 3. Find Microsoft DAO 3.x Object Library. At this point you can do: Dim dbs as DAO.Database -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
