Rename external database that is closed (1 Viewer)

memaxt

Registered User.
Local time
Yesterday, 23:39
Joined
Mar 12, 2013
Messages
62
Hi there,

I have a service pack database that a user opens which the user selects their database to update.

After the service pack as exported its contents to their database, is it possible to rename their database file (accdb) lets say from "Version 1.0" to "Version 2.0" via VBA in the Service pack database?

The service pack saves the path of their database file.


Many thanks
Max
 

memaxt

Registered User.
Local time
Yesterday, 23:39
Joined
Mar 12, 2013
Messages
62
Hi all,

I figured it out using the following code:


Dim db As Database
Dim strBackend_Path As String
Dim LResult As String

strBackend_Path = Me.RESULT
LResult = Replace(strBackend_Path, "(v2.5)", "(v2.9)")
Name strBackend_Path As LResult
 

Users who are viewing this thread

Top Bottom