Problem with Access 97 Dim

[KMITCH]

I'm having a problem with Dim in Access 97.<br><br>Trying to create a database variable in a <br>module with the following:<br><br>&nbsp;&nbsp;&nbsp;Dim dbsCurrentDb as Database<br><br>This does not want to compile.&nbsp;&nbsp;The closest option<br>in the popup is DataObject.<br><br>Any help appreciated.

 

[samara]

Look into Tools/Reference to see if you have a reference to Microsoft DAO Object Library, it may be the missing part... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[KMITCH]

Mohamed Aly<br><br>Thanks for your response.&nbsp;&nbsp;Sorry for my ignorance,<br>but I'm not sure which Tools/Reference you are referring<br>to.&nbsp;&nbsp;I do not see this under the Tools menu in Access 97.<br>Is this a directory/folder outside of Access?<br><br>Thanks,<br>Keith

 

[samara]

You can find it under the Tools menu, if you first go to the VB editor in Access 97 and then click on Tools/References, you will find a list of all avaible libraries you can add to your code.<br><br>Hope this would help YOU... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[KMITCH]

Mohamed Aly,<br><br>Thanks again.&nbsp;&nbsp;I tried this and it worked great!<br><br>-Keith<br>