You should be able to use Oracle as a back end, but you will probably want to use a DSN to connect to it. This is a little slower than provider statements, but probably safer since DSN's are essentially a service and Access doesn't care what is on the other end.
You will also want to make sure that your data types are correctly aligned between the Access front end and Oracle tables.
Are you using local tables with datasets from Oracle, or linked tables?
mmcdonal
|