2 Access97's on one system

[Blair]

My Question is. Can I install 2 versions of access97 on my computer, like
one on D drive and one on E drive with each having different default
folder's to save their files in?

thanks Blair

 

[Rick Brandt]

My Question is. Can I install 2 versions of access97 on my computer,
like one on D drive and one on E drive with each having different
default folder's to save their files in?

thanks Blair

I would think not. The second install would just recognize that there was
already a copy installed and likely would only offer a setup to the same folder
or an uninstall. Also, options like that are stored in the registry and both
installations (even of two were possible) would look at the same registry keys.

 

[Blair]

Your right, I just tried. Can you go into the registry and do it manually, I
have an install on c drive and f drive but they both use the same registry.
If I can would you please explain how

Thanks Blair

 

[Rick Brandt]

Your right, I just tried. Can you go into the registry and do it
manually, I have an install on c drive and f drive but they both use
the same registry. If I can would you please explain how

You can't. Why do you think you need to? There might be a better way to
accomplish the same thing.

 

[Blair]

I have 2 farms so I have 2 copies of the db in two different directies, but
when I put the farm name in one db it changes the name of the other so both
db's are using the same farm name file. I have included the way I managed to
save the farm name below. Does anyone have a suggestion on how I can isolate
each file.

Thanks Blair


Option Compare Database
Option Explicit
Public FarmName As String




Private Sub Form_Load()

Open "Farm Name" For Random As #1 Len = 50
Get #1, 1, FarmName
Close #1
Text1 = FarmName

End Sub



Private Sub Text1_AfterUpdate()
FarmName = Text1
Open "Farm Name" For Random As #1 Len = 50


Put #1, 1, FarmName

Close #1 ' Close file.

End Sub

 

[Rick Brandt]

I have 2 farms so I have 2 copies of the db in two different
directies, but when I put the farm name in one db it changes the name
of the other so both db's are using the same farm name file. I have
included the way I managed to save the farm name below. Does anyone
have a suggestion on how I can isolate each file.

Thanks Blair


Option Compare Database
Option Explicit
Public FarmName As String




Private Sub Form_Load()

Open "Farm Name" For Random As #1 Len = 50
Get #1, 1, FarmName
Close #1
Text1 = FarmName

End Sub



Private Sub Text1_AfterUpdate()
FarmName = Text1
Open "Farm Name" For Random As #1 Len = 50


Put #1, 1, FarmName

Close #1 ' Close file.

End Sub

All you have to do is include a full path instead of just the file name. You
can use the following to get the path of where the MDB resides so that the file
will be created in the same folder...

Left(currentDB.Name,Len(currentDB.Name)-Len(dir(currentDB.Name)))

 

[Blair]

Left(Mink Operations,Len(Mink Operations)-Len(F:\Mink Program\SBGFF(Mink
Operations)))

Ok I have to confess I didn't write this code, I just copy and pasted it
from another form and changed some names to make it work.I am not an
experienced programmer just a wanabe. So would you show me how I would apply
it to this file, sorry for the inconvience

Thanks Blair

 

[Rick Brandt]

Left(Mink Operations,Len(Mink Operations)-Len(F:\Mink
Program\SBGFF(Mink Operations)))

Ok I have to confess I didn't write this code, I just copy and pasted
it from another form and changed some names to make it work.I am not
an experienced programmer just a wanabe. So would you show me how I
would apply it to this file, sorry for the inconvience

What I posted before plus the name of the file you want to open

Left(currentDB.Name,Len(currentDB.Name)-Len(dir(currentDB.Name))) & "Mink
Operations"

 

[Blair]

Thanks works perfect
Blair

What I posted before plus the name of the file you want to open

Left(currentDB.Name,Len(currentDB.Name)-Len(dir(currentDB.Name))) & "Mink
Operations"