Auto FE Updater - mdw file problem

G

Guest

I cannot manage to get my mdw file to work with the Auto FE Updater (created
by Tony Toews).

Here is my .ini file :

[Settings]
MainApp=C:\Data\Store632\Store632DB.mdb
Server=G:\BAAD\CUSTSUPP\SPARES\Database\Store632\StoreDB installer
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
StartMethod=AutoSelect

ShortCutName=Store632DB
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No

MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)

Lockout=No
LockoutMsg=Sorry, not allowed into the system right now. Some maintenance is
ongoing. Try again in 10 minutes.
SupportMsg=Contact your friendly computer support person.
WindowStyle=NormalFocus
MDWPasswordEncrypted=D33CDCBB

[Keys]
;Root1=HKEY_LOCAL_MACHINE
;Path1=\SOFTWARE\Microsoft\Office\8.0\Access\RefLibPath
;String1=tt_utils.mde
;Value1=$AppPath\tt_utils.mde
------------
I think all that it needs to be there is there but it will work only the
first time. All subsequent tries give me an error message until I type the
password again in the .ini file. Then it will work only 1 time until I retype
the password in the ini file.

Here is the error I get :

The MDW account name and password in the INI file weren't valid for opening
the MDB to determine the version of the MDB.

You can re-enter the MDWPassword entry in the INI file and replace
'(Password is encrypted)' with the password. This utility will
automatically update the MDWPasswordEncrypted entry with the new encrypted
password.

-------------------
It seems to be a bug or something about the password encryption. Help will
be very appreciated.

Thanks,

Yanick
 
T

TC

If you don't get any answers here, try posting in
comp.databases.ms-access, where Tony Toews is more likely to see it.

HTH,
TC
 
F

Fred Boer

Dear Yanick:

I'll preface this by saying that I am not an expert, and that this
suggestion might not be relevent, but...

Is it possible you are trying to set up the AutoFE updater to "feed" the
password to Access so that when the user clicks on the icon, Access starts
up, opens the MDW, and automatically enters the password, thereby bypassing
the login screen? If so, that isn't what is intended by those lines. I tried
that once, and, (thanks Tony!) that isn't what those INI settings are meant
to do. If that is what you are trying to do, you need to provide the
password in the shortcut. Note: this means the password is visible to users,
so it might not be useful to you. In my situation, I don't care if users
know the password since their permissions are restricted.

If I haven't been clear.. post back!

HTH
Fred Boer
 
G

Guest

Thanks a lot Fred but this is not what I am trying to do. I actually try to
use it the way it should. All I want is to tell the ini file which mdw file
to use. If I want to do this there is 3 lines that must be in the ini file.
(According to Tony toews's web site)
----------
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)
----------

If I remove any of those lines I get an error msg saying that all those
lines must be there or none.

Do you have any other suggestions?

Thanks!

Yanick

Fred Boer said:
Dear Yanick:

I'll preface this by saying that I am not an expert, and that this
suggestion might not be relevent, but...

Is it possible you are trying to set up the AutoFE updater to "feed" the
password to Access so that when the user clicks on the icon, Access starts
up, opens the MDW, and automatically enters the password, thereby bypassing
the login screen? If so, that isn't what is intended by those lines. I tried
that once, and, (thanks Tony!) that isn't what those INI settings are meant
to do. If that is what you are trying to do, you need to provide the
password in the shortcut. Note: this means the password is visible to users,
so it might not be useful to you. In my situation, I don't care if users
know the password since their permissions are restricted.

If I haven't been clear.. post back!

HTH
Fred Boer


Yanick said:
I cannot manage to get my mdw file to work with the Auto FE Updater (created
by Tony Toews).

Here is my .ini file :

[Settings]
MainApp=C:\Data\Store632\Store632DB.mdb
Server=G:\BAAD\CUSTSUPP\SPARES\Database\Store632\StoreDB installer
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
StartMethod=AutoSelect

ShortCutName=Store632DB
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No

MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)

Lockout=No
LockoutMsg=Sorry, not allowed into the system right now. Some maintenance is
ongoing. Try again in 10 minutes.
SupportMsg=Contact your friendly computer support person.
WindowStyle=NormalFocus
MDWPasswordEncrypted=D33CDCBB

[Keys]
;Root1=HKEY_LOCAL_MACHINE
;Path1=\SOFTWARE\Microsoft\Office\8.0\Access\RefLibPath
;String1=tt_utils.mde
;Value1=$AppPath\tt_utils.mde
------------
I think all that it needs to be there is there but it will work only the
first time. All subsequent tries give me an error message until I type the
password again in the .ini file. Then it will work only 1 time until I retype
the password in the ini file.

Here is the error I get :

The MDW account name and password in the INI file weren't valid for opening
the MDB to determine the version of the MDB.

You can re-enter the MDWPassword entry in the INI file and replace
'(Password is encrypted)' with the password. This utility will
automatically update the MDWPasswordEncrypted entry with the new encrypted
password.

-------------------
It seems to be a bug or something about the password encryption. Help will
be very appreciated.

Thanks,

Yanick
 
F

Fred Boer

Dear Yanick:

Ok, well, it was worth a shot! I wish I could help more, but I'm on vacation
and all of my information about the AutoFE is at work. If it's any
encouragement to you, I can tell you that it works fine for me over my
network... I'm sure Tony will help when he sees your message!

Cheers
Fred Boer
Thanks a lot Fred but this is not what I am trying to do. I actually try to
use it the way it should. All I want is to tell the ini file which mdw file
to use. If I want to do this there is 3 lines that must be in the ini file.
(According to Tony toews's web site)
----------
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)
----------

If I remove any of those lines I get an error msg saying that all those
lines must be there or none.

Do you have any other suggestions?

Thanks!

Yanick

Fred Boer said:
Dear Yanick:

I'll preface this by saying that I am not an expert, and that this
suggestion might not be relevent, but...

Is it possible you are trying to set up the AutoFE updater to "feed" the
password to Access so that when the user clicks on the icon, Access starts
up, opens the MDW, and automatically enters the password, thereby bypassing
the login screen? If so, that isn't what is intended by those lines. I tried
that once, and, (thanks Tony!) that isn't what those INI settings are meant
to do. If that is what you are trying to do, you need to provide the
password in the shortcut. Note: this means the password is visible to users,
so it might not be useful to you. In my situation, I don't care if users
know the password since their permissions are restricted.

If I haven't been clear.. post back!

HTH
Fred Boer


Yanick said:
I cannot manage to get my mdw file to work with the Auto FE Updater (created
by Tony Toews).

Here is my .ini file :

[Settings]
MainApp=C:\Data\Store632\Store632DB.mdb
Server=G:\BAAD\CUSTSUPP\SPARES\Database\Store632\StoreDB installer
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
StartMethod=AutoSelect

ShortCutName=Store632DB
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No

MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)

Lockout=No
LockoutMsg=Sorry, not allowed into the system right now. Some
maintenance
is
ongoing. Try again in 10 minutes.
SupportMsg=Contact your friendly computer support person.
WindowStyle=NormalFocus
MDWPasswordEncrypted=D33CDCBB

[Keys]
;Root1=HKEY_LOCAL_MACHINE
;Path1=\SOFTWARE\Microsoft\Office\8.0\Access\RefLibPath
;String1=tt_utils.mde
;Value1=$AppPath\tt_utils.mde
------------
I think all that it needs to be there is there but it will work only the
first time. All subsequent tries give me an error message until I type the
password again in the .ini file. Then it will work only 1 time until I retype
the password in the ini file.

Here is the error I get :

The MDW account name and password in the INI file weren't valid for opening
the MDB to determine the version of the MDB.

You can re-enter the MDWPassword entry in the INI file and replace
'(Password is encrypted)' with the password. This utility will
automatically update the MDWPasswordEncrypted entry with the new encrypted
password.

-------------------
It seems to be a bug or something about the password encryption. Help will
be very appreciated.

Thanks,

Yanick
 
G

Guest

Thanks again Fred, Your help is very appreciated.

Fred Boer said:
Dear Yanick:

Ok, well, it was worth a shot! I wish I could help more, but I'm on vacation
and all of my information about the AutoFE is at work. If it's any
encouragement to you, I can tell you that it works fine for me over my
network... I'm sure Tony will help when he sees your message!

Cheers
Fred Boer
Thanks a lot Fred but this is not what I am trying to do. I actually try to
use it the way it should. All I want is to tell the ini file which mdw file
to use. If I want to do this there is 3 lines that must be in the ini file.
(According to Tony toews's web site)
----------
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)
----------

If I remove any of those lines I get an error msg saying that all those
lines must be there or none.

Do you have any other suggestions?

Thanks!

Yanick

Fred Boer said:
Dear Yanick:

I'll preface this by saying that I am not an expert, and that this
suggestion might not be relevent, but...

Is it possible you are trying to set up the AutoFE updater to "feed" the
password to Access so that when the user clicks on the icon, Access starts
up, opens the MDW, and automatically enters the password, thereby bypassing
the login screen? If so, that isn't what is intended by those lines. I tried
that once, and, (thanks Tony!) that isn't what those INI settings are meant
to do. If that is what you are trying to do, you need to provide the
password in the shortcut. Note: this means the password is visible to users,
so it might not be useful to you. In my situation, I don't care if users
know the password since their permissions are restricted.

If I haven't been clear.. post back!

HTH
Fred Boer


I cannot manage to get my mdw file to work with the Auto FE Updater
(created
by Tony Toews).

Here is my .ini file :

[Settings]
MainApp=C:\Data\Store632\Store632DB.mdb
Server=G:\BAAD\CUSTSUPP\SPARES\Database\Store632\StoreDB installer
CommandLine=/wrkgrp "G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw"
StartMethod=AutoSelect

ShortCutName=Store632DB
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No

MDWFile=G:\BAAD\CUSTSUPP\SPARES\Database\Security\system.mdw
MDWUser=singleuser
MDWPassword=(Password is encrypted)

Lockout=No
LockoutMsg=Sorry, not allowed into the system right now. Some maintenance
is
ongoing. Try again in 10 minutes.
SupportMsg=Contact your friendly computer support person.
WindowStyle=NormalFocus
MDWPasswordEncrypted=D33CDCBB

[Keys]
;Root1=HKEY_LOCAL_MACHINE
;Path1=\SOFTWARE\Microsoft\Office\8.0\Access\RefLibPath
;String1=tt_utils.mde
;Value1=$AppPath\tt_utils.mde
------------
I think all that it needs to be there is there but it will work only the
first time. All subsequent tries give me an error message until I type the
password again in the .ini file. Then it will work only 1 time until I
retype
the password in the ini file.

Here is the error I get :

The MDW account name and password in the INI file weren't valid for
opening
the MDB to determine the version of the MDB.

You can re-enter the MDWPassword entry in the INI file and replace
'(Password is encrypted)' with the password. This utility will
automatically update the MDWPasswordEncrypted entry with the new encrypted
password.

-------------------
It seems to be a bug or something about the password encryption. Help will
be very appreciated.

Thanks,

Yanick
 
T

TC

This is a complete guess, cos I do not know his product, at all.

Maybe "(Password is encrypted)" means, that instead of supplying the
real password, you must encrypt it using a scheme that is provided by
the auto FE updater program. Then, if someone else, who does not know
the auto FE updater program, looks at the password in the .INI file,
they will only see the encrypted value. The auto FE updater program
then decrypts the password, before it actually uses it to log on via
that workgroup file.

As I say, this is just a guess on my part. But I don't see what other
meaning you could give to "(Password is encrypted)". I know the
passwords are encrypted (by Jet) in the workgroup file, but you can't
log-on with an /encrypted/ password, so he can't be meaning that.

HTH,
TC
 
J

Jesper

I cannot manage to get my mdw file to work with the Auto FE Updater
(created
by Tony Toews).

I'm listening in on this one as I think I may have the same problem. The
weird thing is that 18 out of 19 computers in the multiuser setup have no
problems. Only the one is giving me problems like the one you describe.
I'll look into it again.

Jesper, Denmark
 
T

TC

You need to go to some other group where tony toews hangs out. He does
not come to this one, afaik.

HTH,
TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top