linking tables

[bbypookins]

I want to make a change to my database that I didn't realize when I created
it. There is no data entered in it yet.

I created a number of tables which are located in the backend of the secure,
split database. These tables are linked to the front end and used to create
the forms. I have decided rather than recreating these tables in the BE, I
want to link them from another database that is fully functioning so if any
changes are made, they won't have to be made in both databases (don't know
why I didn't think of this earlier). Should I link them to the BE or the FE?
Both?

 

[Al Campagna]

bbypookins,
Link all the Back End data .mdb's (tables) directly to the Front End.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[bbypookins]

Actually, what I'm asking is if the tables don't even reside in this
database, but are being used from a separate database...do they need to be
linked to the backend or the frontend or both?

 

[Ken Sheridan]

Refresh the links in the front end so they connect to the database where the
tables you want to use reside. Use the built in Linked table manager in the
front end to do this, but make sure that you check the 'Always prompt for new
location' check box' or it will simply refresh the links to the existing back
end. The now redundant back end can then be deleted.

Ken Sheridan
Stafford, England