467,895 Members | 1,391 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,895 developers. It's quick & easy.

importing objects

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
  • viewed: 1331
Share:
2 Replies
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by lawrence | last post: by
4 posts views Thread by jean-marc | last post: by
5 posts views Thread by dixie | last post: by
5 posts views Thread by amywolfie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.