Hi, folks, I recently ran the bu

[Marmalade]

Hi, folks,

I recently ran the built-in performance analysis feature on my Access 2000 database, and one of the "ideas" it offered involved compiling my code by opening my module and selecting "compile" on the debug menu. When I opened the module and selected the debug menu, the only compile option was "compile books." Anyone know what this means?

Thanks,

M

 

[jfischer]

"books" is the name of your database.

 

[nfusee]

Yep...books is the name of the database....

 

[Marmalade]

Doh! Thanks, guys. "Books" was the original name of the database, which has been renamed several times. I didn't even recognize the reference.

Which raises another question...

The current name of the database is "Item Tracker," which is listed on the "General" tab of the "Database Properties" window. The Debug menu, however, lists the *original* name - "Books" - while the "Title" field on the "Summary" tab of "Database Properties" lists yet another name, "Textbooks," that was applied to an intermediate version of the database.

Why so many names? Is this dangerous? And is it possible to "reset" all of these name and title fields to the *current* name?

Thanks,

M

 

[jfischer]

Open a Debug window (Ctrl-G) and adapt the following statement to your needs:

Application.SetOption "Project Name", "MyAccessProject"

"Project Name" must be entered as is, "MyAccessProject" is the name you want to give your project.

 

[Marmalade]

Thanks, j; I ran the statement, and the Debug menu now displays the current name. The "Title" field on the Summary tab of Database Properties still shows an older name, however; and when I try changing it, a dialog box pops up informing me that Access "is unable to save the database properties." Would you happen to know what's going on?

M