Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resding From EXECL sheet and updating Acess .mdb file remotely in web-server

 
kingshuk paul
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
I am facing a problem.Client is maintaining a database in old excel file.
Now in the web site database file is access .mdb file.Using reswin here.
Problem is he wants to write an application.
so that after chages to localmachines excel file
if i click on java GUI it should connect to the web-site URL and
update the .mdb file. I am still in dark.How to do that.
I am using jsp,javabeans and .mdb file and giving guis in jsp
file to update DB.But his specificatioon is to update one file
that is excel file locally and it should update the remote database
file in server.Could anyone enlight in this context.
thanks
kingshuk
EMAIL: kingshuk_14@rediffmail.com

hi
I am facing a problem.Client is maintaining a database in old excel file.
Now in the web site database file is access .mdb file.Using reswin here.
Problem is he wants to write an application.
so that after chages to localmachines excel file
if i click on java GUI it should connect to the web-site URL and
update the .mdb file. I am still in dark.How to do that.
I am using jsp,javabeans and .mdb file and giving guis in jsp
file to update DB.But his specificatioon is to update one file
that is excel file locally and it should update the remote database
file in server.Could anyone enlight in this context.
thanks
kingshuk
EMAIL: kingshuk_14@rediffmail.com
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18218
53
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ugh. Nightmare city. I'll bet the client doesn't want to pay for a modern-day implementation either.
There's a fundamental problem when you try and maintain the same data in 2 places at once regardless of how it's stored. Sooner or later it gets out of sync and it will be a nightmare to get it back there again. I had this fact pounded repeatedly into me when I worked with OS/2 and they'd keep critical system info in more than one place - sometimes referring to one copy and sometimes to the other. It CONSTANTLY got de-synchronized and the system would flake out. At least Windows generally knew better.
Another problem is in using Access as a web backend-database. In Java, there's a possibility for corruption because the JDBC-ODBC bridge isn't thread-safe. Even in a non-Java environment Microsoft's position has been to use Access for Development and SQL Server for production.
Because of the synchronization problem and because it's easier from a business-practical point of view to keep data backed up on a server than a client machine. Plus, if the client machine dies, you can just go to a different box and log in there. Servers are supposed to be fail-safe
If the client doesn't actually need to be able to do Excel calculations, it would be safer to forget about the Excel part and replace it with either a display-only web page or some sort of a web form. On the other hand, if this is a case where Excel is providing major functionality, I'd recommend that you make a spreadsheet that contains some extra VB code in it that fetches and stores the data from the webserver instead of keeping it internally. Or, if you prefer, does a Palm Pilot-style hotsync when a web connection is detected. That can be useful if the client machine's a laptop and isn't always connected.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic