changes in VBA code when oracle and MS access are linked

[shandoo27]

Hi,

I have till now used MS access tables for database and thus peacefully used Dlookup for selecting a particular column value and insert and delete and update for row modifications.

Now I am going to destroy these tables and link my MS access forms to oracle database. I would like to make the specified modifications to the VBA code of the buttons .

1. Is dlookup also applicable to Oracle or should i write a select SQL command. If so how to retrieve just a column value using SELECT command and assign it to a text box. ( Problem here is that the SQL when run returns a record set not just a single variant.

2. What modifications should i do before i execute a SQL command for insert delete and update. could you please give the syntax for connecting to oracle database.

thanks in advance for the help provided.

 

[darbid]

why do you need to make so many changes. The reason why people use Access is that it can have "local" tables which are called linked tables with other databases like SQL Server and as far as I know Oracle.

If you have the tables that Dlookup refers to as linked tables (and nothing else like names change) then you do not need to change anything.

As far as I understand you could move your whole back end to another server type and if you only every refered to and used the linked tables with DAO then there would be little to change.

I have made some pretty wild statements above which might cause the real epxerts here to contradict me which is always welcome.