Hi.
I asked a long time ago if anyone has any knowledge of a dialect for ms access. At that time there wern't any..

I would like to ask the question again, hoping to get a different answer this time!

so if anyone knows about a ms access dialect for hibernate, please let me know where to get it from..

thanks for any help.

No, there is not access dialect for hibernate. If you want you can write one, this is not a difficult task. The problem with access is that it has a syntax so specific that it is not possible to explain it with a dialect (mainly a join problem).

You can use ms access with a basic dialect and if your queries are not too complex you may manage to use it.

If you want more precisions you can see this post

http://forum.hibernate.org/viewtopic.ph ... highlight=

I actually spent quite a bit of time investigating this as I had a large amount >20GB stored accross various MDBs that needed consolidating and cleaning. After much headache I can give you these points.

The Sun JDBC/ODBC bridge driver is worthless.

You will need a commercial JDBC driver to do anything

Writing a dialect for access is more trouble than it's worth

If you're goingto the trouble of writing in Java, and then distributing a Java application with all the attendant headache (JRM etc.) then you may as well go the extra half inch, put a proper database in and just write something to move the data from access to a real database.

Doing anything serious with access will cause your eyeballs to bleed, if you're not doing anything serious then Hibernate is probably overkill.

Have you tried using SQL server dialect?

I would probably concur. Use SQLServer2000 to import and migrate MS Access, and then use the Hibernate/SQLServer 2k. Just doing something like that myself - I'll post any itinerate issues.