Stew Schneider wrote:
Well, I have now played a bit with the interface between OOo and MS
Access. Our office DB is in Access in two parts: an mdb file on each
office XP Pro box containing the queries, forms and reports, and a
second mdb file (actually on a Linux share) containing tables. The two
are linked via the linked table manager.
I registered the queries, forms and reports mdb on one of the XP
machines, but locked up. Apparently, a db with no tables caused it
indigestion. Connection was via ODBC. Alternatively, it hung because it
couldn't see the second DB. Hard to say.
I can get to the tables easily enough in the second mdb (actually, I
probably should move that to MySQL), but it would be sooo nice not to
have to re-write all the forms, queries and reports..
Any suggestions?
You can only access the data inside an mdb file - you can't use forms /
reports / queries / code.
If you want to dump Access ( which is a commendable goal ), then you'll
have to rewrite all of the above. First, I would move your data to
MySQL. Then you can think about rewriting the interface & app logic.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
