Renaming a Database

[gareth001]

Hi i know the solution to this is probably quite simple but i can't work it out!

I have a database created as a template - I then copy this and use it for each of our clients, the problem is the database template is named after a client (so the taskbar and title bar has the client name on it) how can i change this name?

Thanks for your help in advance Gareth

 

[willir]

gareth001

First rename the database using Windows or DOS tools. From Explorer, select the database.
Right click
Select Rename
Type in the new name BUT do not overtype or delete the MDB file extension. This will depend on how you have Explorer setup to display the extentions or not.

You will see either
ABC.mdb -> NewCompany.mdb (change to new name but dont touch ".mdb&quot
ABC -> NewCompnay (no file extension)


Second, open up the database. From the Access menu,
Select File
Select Database Properties
(If you do not see this option, expand the viewable commands by selecting the down arrow)

In Database properties, you can change the title.

Richard

 

[gareth001]

Thanks, i tried this but there was no change to the window titles. The database properties appears not to change anything. Is there anywhere else that can be changed?

Thanks again Gareth

 

[willir]

Gareth

When I changed the name of a simple test database at the DOS / Windows level, Access used the new name. The Taskbar just says "Microsoft Access".

I gather there may be some programming included in your database which may be controlling the display.

For example, on a form, the name displayed at the top of the form is usually the actual name of the form. This can be changed by using some coding...

Me.Caption = "My New Title"

A typical place to put this code at the form level would be in the "On Load" or "On Open" events.

I will dig around to see if a similar thing can be set for the Access window display captions.

And lesson learned...
Rather than hardcode things for a customer, I prefer to use a table for storing customer specfic information such as the default area code for the phone number. This way, I make the change to the record used for storing the custom information, and I dont have to bother hunting for the hard coded customization.


Richard

 

[gareth001]

That would be great, it is the part that says Microsoft Access that is changed, the database was not created by me, i've just inherited it!

And yes it does include VB

Thanks