B
Barry Young
I have an Access database in which the tables are currently linked to a
Access database backend.
I used the Oracle Migration tool to import the database and that worked
fine.
When I link to the Oracle Tables, it wants to insert the Schema name to the
linked table names. My application uses these table names such as
tblCustomers as its reference in basically all the objects.
I also have a routine that links the tables to the appropriate database via
code. But I am getting errors such as table not found when I try to do it
via code.
Has anybody actually migrated without having to do a major replace of table
names in the front end application (Forms, Queries, Modules, etc?
Barry
Access database backend.
I used the Oracle Migration tool to import the database and that worked
fine.
When I link to the Oracle Tables, it wants to insert the Schema name to the
linked table names. My application uses these table names such as
tblCustomers as its reference in basically all the objects.
I also have a routine that links the tables to the appropriate database via
code. But I am getting errors such as table not found when I try to do it
via code.
Has anybody actually migrated without having to do a major replace of table
names in the front end application (Forms, Queries, Modules, etc?
Barry