This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JSP and the fly likes Resding From EXECL sheet and updating Acess .mdb file remotely in web-server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Resding From EXECL sheet and updating Acess .mdb file remotely in web-server" Watch "Resding From EXECL sheet and updating Acess .mdb file remotely in web-server" New topic
Author

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

kingshuk paul
Greenhorn

Joined: Dec 05, 2001
Posts: 16
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


kin
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15952
    
  19

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Resding From EXECL sheet and updating Acess .mdb file remotely in web-server
 
Similar Threads
Copy excel file to access table
How to store a table's data from oracle database into an excel file?
controller creating javabeans
Urgent-Please give some hints
Connecting Exel file to servers Acess DB file remotely