Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2005

Tip: Looking for answers? Try searching our database.

Oracle to Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dgreen - 27 May 2005 17:30 GMT
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 - 28 May 2005 09:56 GMT
>   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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.