Oracle to Access

[dgreen]

I'm trying to convert part of an Oracle database to Access (due to budget
constraints, several of our business districts can't afford Oracle but have
Access on their PCs and, yes, eventually it will all be done via the web).
I'm some what familiar with Access but am having problems with Primary
Keys/Foreign keys and cardinality in Access. It seems that some of what I
have in Oracle doesn't make a straight conversion to Access. Any pointers in
approaching this situation will be greatly appreciated? Thanks for your help!

 

[Tim Ferguson]

It seems that some of what I
have in Oracle doesn't make a straight conversion to Access. Any
pointers in approaching this situation will be greatly appreciated?

There are some things you cannot model directly in Jet, but most things can
be. If it's only a budgetary difficulty, you can always move up to MSDE or
one of the free versions of SQL Server which have working triggers.

Remember too that later versions of ADO can use complex CHECK constraints
against other tables.

Hope that helps


Tim F