|
Home > Archive > MS Access Multiuser > February 2006 > MS Access 97 Auto Client Updater
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MS Access 97 Auto Client Updater
|
|
| Patrick 2006-02-04, 3:24 am |
| I am looking for a MS Access 97 Auto Client Updater. I have a FE/BE
database on a very large NT4 network and I cannot use the one available
from Granite because of network security oncerns. I am looking for
something that I can build into my existing database and each time the
user accesses the FE database via their desktop, it checks for the
version number, and if found different, icopies the new version of the
database to the client workstation.
Grateful for any help or advice.
| |
| Douglas J. Steele 2006-02-04, 7:23 am |
| What are the specific security concerns? It's not like Tony's Auto FE
Updater at http://www.granite.ab.ca/access/autofe.htm gives the user any
capabilities they don't already have. It simply automates the process that
otherwise they'd have to do manually.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Patrick" <pbrydone@hotmail.com> wrote in message
news:1139034953.316232.292710@g43g2000cwa.googlegroups.com...
>I am looking for a MS Access 97 Auto Client Updater. I have a FE/BE
> database on a very large NT4 network and I cannot use the one available
> from Granite because of network security oncerns. I am looking for
> something that I can build into my existing database and each time the
> user accesses the FE database via their desktop, it checks for the
> version number, and if found different, icopies the new version of the
> database to the client workstation.
>
> Grateful for any help or advice.
>
| |
|
|
| Tony Toews 2006-02-05, 3:23 am |
| "Patrick" <pbrydone@hotmail.com> wrote:
>I am looking for a MS Access 97 Auto Client Updater. I have a FE/BE
>database on a very large NT4 network and I cannot use the one available
>from Granite because of network security oncerns. I am looking for
>something that I can build into my existing database and each time the
>user accesses the FE database via their desktop, it checks for the
>version number, and if found different, icopies the new version of the
>database to the client workstation.
You've already gotten the exact same answers I would've given from
Doug and Joan.
But I must admit that I'm curious too. What are the security
concerns? Would your employer like to purchase a fancy license and a
guarantee of some sort that it, for example, won't access the
Internet? <smile>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
| |
| Patrick 2006-02-05, 3:23 am |
| The concerns are more physical. We are not allowed to install
unauthorised software on our network. I am looking to build something
into our existing database.
Patrick
Douglas J. Steele wrote:[color=darkred
]
> What are the specific security concerns? It's not like Tony's Auto FE
> Updater at http://www.granite.ab.ca/access/autofe.htm gives the user any
> capabilities they don't already have. It simply automates the process that
> otherwise they'd have to do manually.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Patrick" <pbrydone@hotmail.com> wrote in message
> news:1139034953.316232.292710@g43g2000cwa.googlegroups.com...
| |
| Patrick 2006-02-05, 7:23 am |
| The security concerns are more physical. Because we are on an official
network we cannot install custom programs, external VB code, etc. I am
looking to build something into our existing database so that it
becomes part of the existing database.
| |
| Douglas J. Steele 2006-02-05, 7:23 am |
| Hopefully you realize that you can't build it into the database itself. It
has to be a separate program that runs before the database opens. That's
because you can't copy the new version of the front-end overtop the existing
version.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Patrick" <pbrydone@hotmail.com> wrote in message
news:1139132484.901936.231890@o13g2000cwo.googlegroups.com...
> The security concerns are more physical. Because we are on an official
> network we cannot install custom programs, external VB code, etc. I am
> looking to build something into our existing database so that it
> becomes part of the existing database.
>
| |
| Patrick 2006-02-05, 9:23 am |
| The application available at
http://accesstips. datamanagementso...iz/versions.htm is exactly
the one I am looking for but it has a couple of problems:
1. It appears to be built for a version newer than Access 97 and a
number of the functions don't work if I convert the databased backward
to Access 97.
2. If I change locations of the folder or rename it to the folder I'm
using on my server, the database cannot find the tables- I have
relinked all the required tables but am still having this problem.
Grateful for any suggestions.
| |
| Patrick 2006-02-05, 9:23 am |
| The application that is available at
http://www.databasejournal.com/feat...cle.php/3286111 is
just what I am looking for but it has a couple of problems:
1. It appears that the databases have been written in a version after
Access 97. If I convert the databases to Access 97, most of the
functions don't work (Replace, etc).
2. If I relocate the folder onto another drive and rename the folders
to what I have on my server, the databases cannot find the data tables.
I have relinked all of the required tables but no luck.
Grateful for any help or advice.
| |
| Douglas J. Steele 2006-02-05, 9:23 am |
| The only thing I see in that code that shouldn't work in Access 97 is the
line:
LocalFile = CurrentProject.Path & "\MyApp.mde"
The equivalent in Access 97 would be:
LocalFile = Left$(CurrentDb.Name, Len(CurrentDb.Name) -
Len(Dir(CurrentDb.Name))) & "MyApp.mde"
If there's anything else that doesn't work, check that your References
collection is okay.
References problems can be caused by differences in either the location or
file version of certain files between the machine where the application was
developed, and where it's being run (or the file missing completely from the
target machine). Such differences are common when new software is installed.
On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.
If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)
I'm not sure I follow your second issue. How does what your set up compare
to the 3 assumptions Steve documents at the bottom of the page?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Patrick" <pbrydone@hotmail.com> wrote in message
news:1139146832.161180.226120@g44g2000cwa.googlegroups.com...
> The application available at
> http://accesstips. datamanagementso...iz/versions.htm is exactly
> the one I am looking for but it has a couple of problems:
> 1. It appears to be built for a version newer than Access 97 and a
> number of the functions don't work if I convert the databased backward
> to Access 97.
> 2. If I change locations of the folder or rename it to the folder I'm
> using on my server, the database cannot find the tables- I have
> relinked all the required tables but am still having this problem.
>
> Grateful for any suggestions.
>
|
|
|
|
|