Creating Copy database, changing name, and deleting programmatical

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database I would like to link to it's tables. The problem
is, that it is the backend of a 3rd party application and does not have a
normal Access extension.

I have a query and reports in my access file I have been working on and need
to programmatically create a copy of this other database and change the
extension so that my table links work. Finally, I would like to delete the
copy upon exiting my Access query/reports file.

If there is a way to create the query to feed a report without changing the
extension of the data file, I do not know where to begin.

Thanks in advance everbody.
 
Cliff_G said:
I have an Access database I would like to link to it's tables. The problem
is, that it is the backend of a 3rd party application and does not have a
normal Access extension.

I have a query and reports in my access file I have been working on and need
to programmatically create a copy of this other database and change the
extension so that my table links work. Finally, I would like to delete the
copy upon exiting my Access query/reports file.

If there is a way to create the query to feed a report without changing the
extension of the data file, I do not know where to begin.
Click to expand...


No need to copy the file and rename it. Even if the Import
wizard doesn't make it obvious, you can still link to table
in the file.

The easiest way to link to a table is to use the File -
Import External Data - Link Tables menu item to link to a
remote table. Just type the name of the database if the
wizard won't allow you to browse for the file.

Another way is to use the CreateTableDef method (see Help
for details)

You can also get the data using a query by using the IN
phrase in the FROM clause (see Help ... ).
 
Back
Top