[Wine] Wine ODBC and unixODBC

[mkelliott21]

Okay,

I have been ask to work on a project at work, that entails putting data inside a Microsoft Access database.  Most of this work is being done at home, so I am setting up my system to be able to use Access through Wine.

I have successfully installed Windows XP Office(thanks CodeWeavers, you guys are the greatest...  yes it is the LinuxDemo, saving my pennies to buy the licenses javascript:emoticon(':)') ), but I just need to know if I am thinking wrong.

I have unixODBC working with a Oracle XE database in Linux.  I just want to make sure that I understand that I can set a DSN in unixODBC and it will read the Access database.  Can I use the drivers in Wine(Microsoft Access (*.mdb) drivers just like I could if I was in a "real" Windows enviroment.

I would much rather use OpenOffice to develop and test (from Linux), and just have the Access database show up as a datasource in OpenOffice.

This can be done can't it???

The problem I am having is the Wine drivers showing up in unixODBC.... ???

I would love to get rid of Windows all together, but where I work, the "higher-ups" in IT look down on me cause I use Linux.  They have made so many rules that make it almost impossible to do anything unless it is Microsoft stuff.  (the irony: very soon they are moving to Oracle database,,,,, but they want this to be a Access database even though they are taking Access away from us next year)

I am using:
 openSuse 10.3
CodeWeavers Linux Standard (Demo) version 6.2.0
unixODBC 2.2.12