• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Access Database doesn't have updated info

Hi,

I developed a Visual Basic .NET ASP solution, and it seems to be working fine.  It's running on a third party Windows Web Server hosted by iPowerWeb (yuck).  Without getting into too much un-needed detail, a user can login and edit job postings, which are then reflected on a more publicly accessible site.

I'm using a Microsoft Access database stored in a _database subdirectory of the actual application path.  Like I said, everything appears to be working OK.

Now I'm expecting that when I download the Microsoft Access database from the web server, it will have all the current listings.  But no, it has just the two sample listings it already had back when I uploaded the file.  None of the listings that have been added via the web interface are there.

Is the app actually even using the Access database?  I want to be able to manually adjust some values in the database by FTP'ing it down, making changes, and FTP'ing it back up again (preference because I don't want to deal with developing an un-needed module to handle very infrequently changed data).

P.S. - connectionstring uses a server.mappath statement, and connection and adapter are oledb.

Thanks!

Kevin
0
kmoloney
Asked:
kmoloney
  • 5
  • 2
2 Solutions
 
jrschererCommented:
Hi kmoloney
First, check with your host where he runs the "live" access database. Unless you have a dedicated server, he will put it on a share not accessible to you by FTP. The fact that you downloaded your initial copy is pretty much a proof of this.
Second, you are certainly aware of the fact that your concept download-modify-upload a .mdb file will make you loose all changes which were done by web clients in this time period.
May be you want to reconsider to write your own ASP maintnance access against your database. This will solve both problems.
Jack.net

0
 
kmoloneyAuthor Commented:
Jack - Oh my Gosh...contact iPowerWeb Tech support...better set aside the coffee and cigarettes...and remove anything breakable from within easy reach.

Thanks, I will attempt and post the results.
0
 
kmoloneyAuthor Commented:
No surprise...online support referred me to e-mail / phone support.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
farsightCommented:
Their help says:

http://helpcenter.ipowerweb.com/cgi-bin/ipowerweb.cfg/php/enduser/std_adp.php?p_faqid=1801&p_created=1100577092&p_sid=n-5iE24i&p_accessibility=0&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MzQmcF9wcm9kcz0mcF9jYXRzPTAmcF9wdj0mcF9jdj0mcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1kYXRhYmFzZQ**&p_li=&p_topview=1

<%
Dim DBPath,objRS,objConn
'----------------------------------------------------
'DO NOT MODIFY ABOVE THIS LINE
'----------------------------------------------------
' Change the path below to the actual location of your mdb file
DBPath="/db/file.mdb"
'----------------------------------------------------
'DO NOT MODIFY BELOW THIS LINE
'----------------------------------------------------
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.mappath(DBPath)
objConn.Open
Set objRS=Server.CreateObject("ADODB.Recordset")
%>

How does your own connection code compare to that?
I'd think you would just need:
  DBPath="/_database/file.mdb"
where file is modified to match your actual file name.

---

I agree that "download-modify-upload a .mdb" isn't a good idea.  I realize it's necessary sometimes.  When I MUST do it, I add an Out-Of-Service flag to the application, usually based on the existence of a file.  Then, on each page, I check the Out-Of-Service flag, and if it's set, I just show "Site is Temporarily Down for Maintenance.  Please try back in a few minutes." and I DO NOT access the database.  Then, to do database maintenance, I upload the Out-Of-Service file, wait a few minutes, then download-modify-upload the database, and finally, delete the Out-Of-Service file.  This solution is a little bit better, but still far from ideal.
0
 
kmoloneyAuthor Commented:
farsight,

My connection string is should essentially be accomplishing the same things as their help file:

OleDBConnection1.ConnectionString="Provider=""Microsoft.Jet.OLEDB.4.0"";Data Source=" & server.mappath("filelocation")

Besides, the application is actually working - its not that the web app doesn't appear to see the database, just that I can't download it.  I would think if it were a path issue, it wouldn't see the database at all.  I did search their help file for other topics related to this one, but nothing there.  Haven't checked the web extensively yet; always like to give away 500 points if I can :) !!

And you and jack are correct about the "download-modify-upload" strategy.  However, the current situation is simply that, at most, three people might want to access this concurrently (myself included), and always 8:00 a.m. to 5:00 p.m., M-F (myself excluded).  As you can see, I don't work those kind of hours.  Plus, the changes I might need to make might be the addition of a single field or changing a value maybe once every couple of months - and then, in theory, never.  The DB should be down and up again in five minutes or less.

In fact, somehow, I feel more secure knowing that their INSN'T a web interface to a particular table with settings that shouldn't have anyone's access except my own.  Less hacker-inviting.  Point taken in theory, but in practice, I think this will work out fine for the time being.
0
 
kmoloneyAuthor Commented:
By the way, when I attempt to download the file through the VDECK control panel, I receive the following error message:

  Microsoft VBSscript runtime error '800a004c'
  Path not found
  /inc/host/FileManager.asp, line 23
0
 
farsightCommented:
Do you have something that looks like   /_database/file.mdb   for your "filelocation" ?

> Now I'm expecting that when I download the Microsoft Access database from the web server, it
> will have all the current listings.  But no, it has just the two sample listings it already had ..
From this, I understood that you had downloaded the database, and noticed it had only sample data.

> Is the app actually even using the Access database?
From this, I understood there was an open question about the app using the database, not "its not that the web app doesn't appear to see the database".

In your initial question, you never mentioned "just that I can't download it".

It's a bit difficult to help when given inaccurate info.

http://www.computerperformance.co.uk/Logon/code/code_800A004C.htm
Either (1) you're using the wrong path/filename, (2) you had a typo, or (3) iPowerWeb's download script is broken.
It does sound like tech support is the way to go.

I suspect the actual database used is not what/where you think it is.
0
 
kmoloneyAuthor Commented:
Also, for the record, re the 800A004C, iPowerWeb Tech Support (not the sharpest) indicated that the download links in their VDECK control panel aren't supported for Windows Server 2003 (so why do they have them?).  It also ticks me off that iPowerWeb offers ASP.NET, but vehemently refuses to support it.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now