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.

Jun 27 '08 #1

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.

Jun 27 '08 #2

lyle fairfield

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.

Jun 27 '08 #3