By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,151 Members | 1,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,151 IT Pros & Developers. It's quick & easy.

Looking for suggestions for "How to Develop"

P: n/a
First... thanks for taking time to read my quest.

I have Access database that I have created that once it has been
deployed I will not know who has it or who is using it.

This is my idea but I'm not limited to this.
I would like to create a solution that allow the user to click a
button or some action that would go to an asp web page and tell them
that they either have a old version and needs to updated or they are
using the latest version. I would like to have a form that would work
like a browser so this process would not open up a new browser.

Please let me know you thoughts, ideas and suggestions.

Thanks

N. Graves
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
N. Graves wrote:
First... thanks for taking time to read my quest.

I have Access database that I have created that once it has been
deployed I will not know who has it or who is using it.

This is my idea but I'm not limited to this.
I would like to create a solution that allow the user to click a
button or some action that would go to an asp web page and tell them
that they either have a old version and needs to updated or they are
using the latest version. I would like to have a form that would work
like a browser so this process would not open up a new browser.

Please let me know you thoughts, ideas and suggestions.

Thanks

N. Graves

Interesting question. I was hoping you'd get some answers.

I have an About form and the caption might say
"Tech Support"
and the hyperlink might be
http://www.techsupport.com
so when the person clicks it it goes to that site.

I went to google groups and saw the following routine
Private Sub MyCmd_Click()
Dim dblVal As Double
dblVal = Shell("C:\Program Files\Internet Explorer\Iexplore.exe" & _
" " & "http://www.google.com/search?q=Dreyer ice cream", 1)
End Sub
This will open up google and return all hits for Dreyer ice cream. That
really doesn't help you out since you want the value of it. But...you
could pass something like that to your site and display whether or not
they have the correct version.

Here is a link that may help. It appears you could FTP or request a
file. Let's say at your web site you store something called
CurrentVersion.Txt. It contains one line with the value 2.0. If you
could get that file to your machine you can read the file with the Open,
Get or LineInput, Close commands (see help)
http://www.mvps.org/access/modules/mdl0037.htm
and then compare the value of the text file to the current version number.

Maybe there is something where you can read a HTML page but then you
have to think of all of the various browsers that are in use.

THe problem I see is that the results from the server are returned to
the HTML page in the browser and NOT to the calling program. Check your
version and see if your version has XML capabilities.

Here is a google link with some code that may get you started from Dev
Ashish.
http://groups.google.com/groups?hl=e...%3D30%26sa%3DN

Nov 13 '05 #2

P: n/a
N. Graves wrote:
First... thanks for taking time to read my quest.

I have Access database that I have created that once it has been
deployed I will not know who has it or who is using it.

This is my idea but I'm not limited to this.
I would like to create a solution that allow the user to click a
button or some action that would go to an asp web page and tell them
that they either have a old version and needs to updated or they are
using the latest version. I would like to have a form that would work
like a browser so this process would not open up a new browser.

Please let me know you thoughts, ideas and suggestions.

Thanks

N. Graves


Also, goto http://groups.google.com and search for Downsave problem and
read the thread.

Nov 13 '05 #3

P: n/a
On Tue, 22 Jun 2004 04:14:02 GMT, Salad <oi*@vinegar.com> wrote:
N. Graves wrote:
First... thanks for taking time to read my quest.

I have Access database that I have created that once it has been
deployed I will not know who has it or who is using it.

This is my idea but I'm not limited to this.
I would like to create a solution that allow the user to click a
button or some action that would go to an asp web page and tell them
that they either have a old version and needs to updated or they are
using the latest version. I would like to have a form that would work
like a browser so this process would not open up a new browser.

Please let me know you thoughts, ideas and suggestions.

Thanks

N. Graves

Interesting question. I was hoping you'd get some answers.

I have an About form and the caption might say
"Tech Support"
and the hyperlink might be
http://www.techsupport.com
so when the person clicks it it goes to that site.

I went to google groups and saw the following routine
Private Sub MyCmd_Click()
Dim dblVal As Double
dblVal = Shell("C:\Program Files\Internet Explorer\Iexplore.exe" & _
" " & "http://www.google.com/search?q=Dreyer ice cream", 1)
End Sub
This will open up google and return all hits for Dreyer ice cream. That
really doesn't help you out since you want the value of it. But...you
could pass something like that to your site and display whether or not
they have the correct version.

Here is a link that may help. It appears you could FTP or request a
file. Let's say at your web site you store something called
CurrentVersion.Txt. It contains one line with the value 2.0. If you
could get that file to your machine you can read the file with the Open,
Get or LineInput, Close commands (see help)
http://www.mvps.org/access/modules/mdl0037.htm
and then compare the value of the text file to the current version number.

Maybe there is something where you can read a HTML page but then you
have to think of all of the various browsers that are in use.

THe problem I see is that the results from the server are returned to
the HTML page in the browser and NOT to the calling program. Check your
version and see if your version has XML capabilities.

Here is a google link with some code that may get you started from Dev
Ashish.
http://groups.google.com/groups?hl=e...%3D30%26sa%3DN

I use a system very similar to what you describe with a couple of exceptions.

The front end has a custom property storing the version number.
When an update is published I put a copy of the new FE and a text file containing the new version number at a
predetermined URL.
When a "Check For Update" button is clicked, it uses FTP to download the text file. (no browser involved).
The text file is read and the version number compared to the custom property in the current front end. If they are
different I use Michael Kaplan's TSISOON utility to close the current database and open a small single form "Update"
database.

When this db opens it moves the current FE to a backup folder.
It then uses FTP to download the new version to the program folder.
When the download completes it uses TSISOON again to close the Update db and open the new front end.
Error handling checks that the download has succeeded and if not rolls everything back to the current version.

It has worked without problems for the last 18 months or so.

Wayne Gillespie
Gosford NSW Australia
Nov 13 '05 #4

P: n/a
Thanks Salad and Wayne.

After I posted this note. I did some research and found a component
call "Microsoft Web Browser" and that allowed me to display the
webpage.

Here are the details of how I plan to support my end users and my MDB
is not a data collecting tool so the table data is not important but
the forms and reports are.

I added a form with the "Microsoft Web Browser" component. Then on
the "On Current" Event I assigned a URL to the form. I also added a
table to this DB that is called revisions. In this table I explain
and record any update information along with a BuildID(autonumber
filed)

The URL that I created include information about the build and the
database name.

wbbWebsite.Navigate
URL:="ServerName/Tool_Updates/NeedUpdates.asp?Ver=1&Project=MSInv.mdb"
I then created a Web ASP page that will read into the
MSInv.mdb/revision table that is stored on the IIS server. If the
Version that you are using it the same has what is on the server you
will get a message that says you are currents if not then you get a
link that you can click on to download the new database.

You guys are the best keep up the good work!!

N. Graves
On Tue, 22 Jun 2004 04:34:05 GMT, Salad <oi*@vinegar.com> wrote:
N. Graves wrote:
First... thanks for taking time to read my quest.

I have Access database that I have created that once it has been
deployed I will not know who has it or who is using it.

This is my idea but I'm not limited to this.
I would like to create a solution that allow the user to click a
button or some action that would go to an asp web page and tell them
that they either have a old version and needs to updated or they are
using the latest version. I would like to have a form that would work
like a browser so this process would not open up a new browser.

Please let me know you thoughts, ideas and suggestions.

Thanks

N. Graves


Also, goto http://groups.google.com and search for Downsave problem and
read the thread.


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.