Oracle to Access

G

Guest

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!
 
T

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?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access and Linked tables to Oracle 7
Querying the Catalog 1
Linked Oracle db in Access 2000 6
Access 2k3 Front End to Oracle 10g Back End design thoughts 4
How to connect to Oracle server from within microsoft access 1
ODBC link to Oracle 8i database 1
How to connect to the Oracle server from Microsoft Access 1
To convert from Oracle Database to Access 5

Top