Importing/Access Defaults

  • Thread starter Thread starter Mell via AccessMonster.com
  • Start date Start date
M

Mell via AccessMonster.com

I want to import all objects from one db to my current.
The problem is some of their tables, forms etc. are named exactly the same as
some of my tables, forms etc. [i.e - contacts] so when I import the objects
over, as you know access automatically renames [i.e - table] contact to
contacts1 so the contact table i have in my existing table won't have the
same name as the imported one.
I have this problem on some names on tables, forms and macros and as you know
when I go to run my forms, it gives me that error b/c the original name was
renamed. [Makes sense]

Is there any easy way to connect and rename the second set of objects that I
imported over instead of having to manually re-build the tables, forms and
macros from scratch so I don't get the error messages.

I know that it has lost it's connection b/c of the rename, but I don't know
the easiest way to re-link them w/ out having to start from scratch so I
don't have two objects [i.e table] named the same name?

Sorry for the confusion
Mell
 
Hey Mell

You are confusing, you are just performing a verry complex copy and paste from
DB A to DB B to obtain DB A in DB 2.
Can you explain me what the goal is you want to reach?

best regards
 
Goal:
To bring over objects from one db to another db, but some of the tables,
Forms & Macros are named the same as the db that it will now be housed in [i.
e - table (named - contacts)], so when I import those ojects over, access
automatically see's that some of the objects [tables, form & macros] are
named the same and puts a 1 behind the names that are the same. So when that
happens, the name from some tables, etc. have now been renamed (if you will -
1) and now the macros and forms that use to work in db before I imported them
over now no longer work b/c the name has changed [I get error messages]. So
how do I fix this w/ out having to manually go and create new tables, forms &
macros so the names are not the same?


Hey Mell

You are confusing, you are just performing a verry complex copy and paste from
DB A to DB B to obtain DB A in DB 2.
Can you explain me what the goal is you want to reach?

best regards
I want to import all objects from one db to my current.
The problem is some of their tables, forms etc. are named exactly the same as
Click to expand...
[quoted text clipped - 16 lines]
Sorry for the confusion
Mell
Click to expand...
Click to expand...
 
Back
Top