msaccess query

[Anon]

to all
i have an ms access database which has a list of link table . These tables were created in oracle and linked to ms access. but now i want to load this software into another machine which does not have oracle. so i want to create the same tables in access itself. Please let me know what is the easiest method of doing so. that is to create a table in msaccess having the same structure as the link table structure.

[Anon]

From within your current access database select the linked table then go to File->Save AS/Export from there go into a new access database (that you've already setup) and put the table there. Access will create the table with approximately the same structure (some things don't translate) and data. You will just have to clean up the table structure for the few strange fields. And remember if you are useing any Sqeuences in your Oracle table they won't come across and you'll have to alter the tables to be autonumber in access.