Is it possible to connect to an access-db in Linux?

that is because this is the only good approach

windows                                                        | Linux
                                                              |
client app---(JDBC ODBC bridge)---MDB---(X)---gateway server---|---(JDBC)---web app

(and that drawing looks horrible in a non monospace font - copy paste to notepad to view)

would it be that difficult to port the client app from Access to something
more java and server suitable ?

Hello Arne!

Nice to hear from you!

Hmm I guess one easy approach is to use Windows all the way.

The problem is that the client just hate Windows.

Why do they want to use Access then you may wonder? The client-company used use windows before they got bought up from a bigger company that do not like windows. The previuos company used Access for one customer database and one quote database. They would now be able to use the same databases since there sell-support application PowerSell uses Access.

This is a tricky question. 

I guess they must use Access for PowerSell and i guess those clients is *.exe applications for windows. Correct me if I'm wrong when I say that you may store the common Access database for those clients on a linux server and be able to connect to the database from windows clients. Does this sound reasonable? exe -> linux -> Access

If they must use windows for PowerSell I guess I'm home free, that I could also use windows all the my self.

Best regards
Fredrik

only possible if the Linux box runs Samba and the windows box sees the MDB as file
on a file share

success ?

Hello Arne!

Acctually not yet, but hopefully soon!

One person has quit his job over here so I need to work for 2 persons. So I have been quit busy. But I'll get back as soon as I can.

Best regards

Fredrik

Please give svar so I can reward you!

ok