473,287 Members | 1,946 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Launching app button to replace corrupt front end

One of my users had a corrupt front end that wouldn't open.

My app is launched using a launching application (logon app). The logon app
has a button for downloading a "fresh" copy of the front end from the server
to the user's PC. I thought that this was a good idea since Access seems
susceptible to corruption.

I told the user to open the logon form and click the "Download" button, which
would then replace the corrupt front end on his PC with a clean front end
from the server. The code uses the FileCopy command.

However, this failed giving the same error message (unrecognizable database
format) as when trying to open the corrupt front end. So now I'm looking at
the "download" code and I realize that the "download" code is opening both
the front end on the server and the front end on the PC to check the version
numbers, before executing the FileCopy command. The idea is to make sure that
an old version doesn't overwrite a new version.

I just want to confirm that it was this attempt to open the corrupt front end,
in code, to check the version number that caused the error message to appear
when the user clicked on the 'Download' button (which is supposed to replace
the user's front end copy with a copy from the server). It seems like the
FileCopy command shouldn't care if the file to be overwritten is corrupt or
not. But, I can't test this as I don't have a corrupt copy of my front end
available to me.

BTW: Is there a way to corrupt a front end (.mde format) so that I can
determine exactly what caused this error to occur when my user clicked on the
'Download' button. Actually, I hope the answer is no since my biggest concern
with Access is the ease with which it corrupts.

Thank you.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 8 '06 #1
3 2185

"rdemyan via AccessMonster.com" <u6836@uweschreef in bericht news:65f6f13123a0f@uwe...

BTW: Is there a way to corrupt a front end (.mde format) so that I can
determine exactly what caused this error to occur when my user clicked on the
'Download' button. Actually, I hope the answer is no since my biggest concern
with Access is the ease with which it corrupts.
Open the mde with Word (or notepad if you like)
Hit the spacebar
Save

Arno R
Sep 8 '06 #2
AARGGH!

That was too easy. Thanks for giving me one more thing to worry about :)

Arno R wrote:
>BTW: Is there a way to corrupt a front end (.mde format) so that I can
determine exactly what caused this error to occur when my user clicked on the
'Download' button. Actually, I hope the answer is no since my biggest concern
with Access is the ease with which it corrupts.

Open the mde with Word (or notepad if you like)
Hit the spacebar
Save

Arno R
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 8 '06 #3
I bypassed the version code checking and was able, using the launching app
download button, to successfully download a fresh copy from the server to
replace the copy I just corrupted (using the technique suggested by Arno).

So, at least I know how to solve this problem and am making it relatively
easy for users to replace a corrupt copy of the front end. I guess that's
the best I can do, so I'll stop worrying about it.

Thanks.

rdemyan wrote:
>AARGGH!

That was too easy. Thanks for giving me one more thing to worry about :)
>>BTW: Is there a way to corrupt a front end (.mde format) so that I can
determine exactly what caused this error to occur when my user clicked on the
[quoted text clipped - 6 lines]
>>
Arno R
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 8 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Matt | last post by:
In the following code, I have 2 questions regarding submit button with image. 1) Does this code <input type="image" name="populate" src="populate.gif"> behave the same as an HTML submit button...
12
by: Corey Burnett | last post by:
I have a client that has a split database (front-end/back-end). They are also using Access security - MDW file. The front end MDE file, the back end MDB file, and the MDW file are all located on...
0
by: krisa | last post by:
Would appreciate any help on this: I have an A2K frontend/backend application developed & tested on client's "usual" server. Then moved both back and front ends to a different server so...
9
by: Ant | last post by:
Hi, I'm wondering if anybody can tell me what the Validate document button is used for & how to use it. When I deliberately put some tag in that shouldn't be there, (such as an extra body tag) &...
3
by: rdemyan via AccessMonster.com | last post by:
I'm thinking about providing a relatively easy method for users to restore the front end from a backup. The purpose is to allow for restoring if the front end becomes corrupt. Here are some...
2
by: bobdydd | last post by:
Hi Everybody For Microsoft Access 2000 and above Windows XP I am trying to mimic the action of this command that at the moment runs from the start>>all programs at the bottom left of the...
13
by: Owen Jenkins | last post by:
Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a...
5
by: BA | last post by:
Hi there I am trying to write an "application" in Access 2000, that displays a front end and allows the user to interact with the database without seeing Access loaded, in the background, nor on...
1
by: anonymous | last post by:
Hello, wasn't quite sure where to ask this.... I have a coolermaster xcraft external hard drive case. It has a button on the front that performs an action when you install some program in...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.