Access Database doesn't have updated info
Posted on 2006-04-02
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.