importing objects

[bobh]

Hi All,

For AccessXP when importing objects from one database into another
databse if the object exists the import will create a copy of that
object and stix a 1 or the next available nbr at the end instead of
overwriting the existing object.

ex: if I have qryGetData in ThisDatabase and I import qryGetData from
ThatDatabase access will create qryGetData1 in ThisDatabase.

Is there anyway to tell Access to overwrite objects??

bobh.

[Salad]

Re: importing objects

bobh wrote:

Hi All,
>
For AccessXP when importing objects from one database into another
databse if the object exists the import will create a copy of that
object and stix a 1 or the next available nbr at the end instead of
overwriting the existing object.
>
ex: if I have qryGetData in ThisDatabase and I import qryGetData from
ThatDatabase access will create qryGetData1 in ThisDatabase.
>
Is there anyway to tell Access to overwrite objects??
>
bobh.

I wouldn't want that safety feature to be disabled.

I am unaware of a built in feature of Access to disable it.

The best way would be to write your own import form.

[lyle fairfield]

Re: importing objects

On May 15, 1:52 pm, bobh <vulca...@yahoo .comwrote:

Hi All,
>
For AccessXP when importing objects from one database into another
databse if the object exists the import will create a copy of that
object and stix a 1 or the next available nbr at the end instead of
overwriting the existing object.
>
ex: if I have qryGetData in ThisDatabase and I import qryGetData from
ThatDatabase access will create qryGetData1 in ThisDatabase.
>
Is there anyway to tell Access to overwrite objects??
>
bobh.

I hope not.