Download failed

Question

Good evening.  I sent a message to our webmaster that everytime I went to download from the server, it failed.  Our webmaster for our camp sent the following message:

The SSL certificate at https://secure39.nocdirect.com/ (which is how we access the downloads as well as the application system) has expired.

 The SSL cert has been updated for metis.nocdirect.com but they've removed the cert from secure39.nocdirect.com all together. I can't remember what the Access DB uses but I seem to remember that there was a config option within the system where you could change this. If the download doesn't work for you guys now, you have to find how to change this in your databases. 

Has anyone fixed a problem like this before?  I would appreciate any help I can get.

Thank you.

---

ShanP

Answer 1

I can't remember what the Access DB uses but I seem to remember that there was a config option within the system where you could change this.

---

ShanP

It's going to be very difficult for someone to help with your question as you are asking them for information on a system which is internal to your organisation.

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

Thank you for your reply, Jeff.   As I know nothing about Access, can you please tell me how to go inside and check the db?  Or is this a stupid question? 

Possibly I need to take it in to someone who can look at it?

Thank you.

---

ShanP

Answer 3

Here is some links on how to use MS Access.  There are different versions of MS Access and the way you use them differs.

http://www.functionx.com/access/Lesson01.htm

http://office.microsoft.com/en-us/training/get-to-know-access-RZ006118141.aspx

http://www.quackit.com/microsoft_access/tutorial/

It's going to be very difficult for you to figure out what to do when you don't really know what it is you need to do.

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 4

This is not an MS Access problem. It's based on website configuration. You'll need to edit the config file on the website.

"The SSL certificate ... has expired." That SSL cert is, or would be, on your server.

Access knows nothing about SSL certs.

---

With Joy Wend Your Way

Answer 5

Thank you.  I will pass this on to our webmaster.

 

---

ShanP

Answer 6

Good morning,

I have had the following reply from our webmaster:

Nope. That's not it. The Access DB is trying to go to the secure39.nocdirect.com website using SSL. Our hosting provider is no longer providing SSL at that address and has informed us to use metis.nocdirect.com instead. This requires a change in one field of one table in the DB I believe.

I have looked at the tutuorials , etc but am afraid to dive in.  I have backed up my db as is.  I have looked at the database tools and visual basics.  I do not see the whole database, just the string (?).    There is nothing about the website.  How do I go to looking at the whole of the database?  Is there a way to search for "secure39..." and then change it to "metis...."?

Sorry to be a bother again.  Thank you for any help.

 

---

ShanP

Answer 7

Okay, apparently I misinterpreted your problem.

You are talking about an Access database running on a network? You have users opening this Access db from their workstations?

Correct?

---

With Joy Wend Your Way

Answer 8

Hi George,

There are 3 camps - Vancouver Island, Shuswap and Gwillam Lake.  The campers all use our website, BC Family French Camp and apply for one of the camps via the application process.  When I open the file, bcffc_main, a main menu comes up.  I click on download registraton data.  Since I am the Vancouver Island registrar, the server filters my vancouver island registrations and puts them into file and then downloads them into my database (this is how I understand it).  There is one registrar for each camp.

When I click on downlaod registration data, a box says, "getting registration data file."  It then states it is connecting to the server.  However, it pops up another box telling me that the download of the registration file failed. 

 

---

ShanP

Answer 9

Okay, that workflow wasn't clear from the original post, which seemed to imply you are working with a website. Sorry I shoud have asked that at step one.

This error is raised by your local Access database when code in it runs to reach out to the web server.

"When I open the file, bcffc_main"...  I assume, then, that "file" called bcffc_main  is your local Access database?

You'll have to open it, find that reference to the ssl cert in the Access db, and update it. You mention a "config" option. You'll have to find that and change it. Of course, as has been previously noted, since we can't see the db, there isn't much we can do except in very generally terms.

Let's start with the Access version you have and whether you have an uncompiled or compiled db file. Is it bcffc_main.MDB, bcffc_main.MDE, bcffc_main.ACCDB or bcffc_main.ACCDE?

 

 

---

With Joy Wend Your Way

Answer 10

Sorry about not being clear from the beginning.  I will try to include everything that I know. 

The database file is bcffc_main.mdb.  I am using Access 2010.  This database was developed in 2003 using Access 2000. 

---

ShanP

Answer 11

Somewhere in that mdb is either a table which lists configuration settings, including this one, or it is saved "hard-coded" into the VBA in the mdb.

The response you got from the webmaster isn't very helpful in that regard.

Let's start by opening the mdb as you normally do BUT, but before you do that, Press the [Shift] key and hold it down until the mdb is fully open. You should be able to see the Navigation Pane, on the left side of the screen when you do that. Look for a table with "config" in the name. If you see it, we'll open it and look for that cert setting.

 

---

With Joy Wend Your Way

Answer 12

Actually, talking to the other moderators, it seems like your question should be in a forum that specializes in Access, not SQL Server. It's way off-topic here.

Would you mind coming on over to http://www.utteraccess.com/ ? I'll be there, and can help you move forward. I'm sure the folks here wouldn't mind.

 

George Hepworth

 

---

With Joy Wend Your Way

Answer 13

Thank you for your help and direction, George.  It is greatly appreciated.  I will head over to the other website.

Have a good evening.

---

ShanP

Answer 14

ShanP was able to resolve this problem after some coaching on how to look for the configuration information in her Access database. There is a developer-designed function to update the connection information, apparently in a table within the mdb.

She discovered this functionality and used it to update the config information.

---

With Joy Wend Your Way