Using front end and backend

[leenu_n]

Hi,
I have some important tables in the backend on Access. I want to use Access forms to access it. Is it possible to create an mdb for the tables and use another mdb to access these tables using forms ? How will it be linked ? Will i have to create tables in the forms mdb too ??? This is urgent . Pls lemme know

Thanks

 

[Jack Cowley]

Create your database as you normally would. When it is finished use Tools > Database Utilities > Database Splitter to split your database into Tables (backend) and everything else (frontend). Search Access help for more information on the advantages, etc. of a split database.

hth,
Jack