Access bak File

[Sondra]

I have a database that was built as an .mdb and then
backed up and the user used the .bak file for the final
database. How can I change the extension back to .mdb so
that the users won't have to use an "OPEN WITH" when
trying to access the database.

Thanks.

 

[Douglas J. Steele]

There's a built-in rename function called Name:

Name oldpathname As newpathname

 

[Al Moroz]

Can't you rename the file using 'My Computer'? My
apologies if I misunderstood your question.

This alias is for newsgroup purposes only, do not reply to
it.

 

[Brendan Reynolds \(MVP\)]

If you need to do this programmatically, see Doug's post elsewhere in this
thread. If it's a one-time thing, just right-click the file in either 'My
Computer' or 'Windows Explorer' and choose 'Rename'. When renaming files, it
helps if you go into 'My Computer', select 'Folder Options' from the 'Tools'
menu, select the 'View' tab, and in the 'Advanced settings' list make sure
that the option 'Hide extensions for known file types' is *not* checked. It
is checked by default when Windows is first installed, which was a really
bad design choice. Weird things tend to happen when you try to rename a file
with a hidden extension - you end up with two extensions, e.g. abc.bak.mdb
or abc.mdb.bak. It also causes lots of fun when trying to support users via
the phone: Support Person: "OK, select the file named 'abc.mdb'." User: "Uh,
I don't have a file called 'abc.mdb'. I have two files called 'abc', but
neither of them are called 'abc.mdb'." Great, now you get to figure out
which one is the mdb and which one is the ldb. (As you've probably guessed
by now, this is something of a 'pet hate' of mine!

The steps above are for Windows XP. They may differ slightly for other
versions of Windows.