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]

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]

On May 15, 1:52*pm, bobh <[e-mail]:

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.