Setting up a front end/ back end 1

[Harr777]

I have a Access app. that is almost finished. All of the forms and tables are in the same database. I am a little new to Access. The way that I understand it, if you have the forms in a seperate database than the tables, you can change the forms without having to worry about whats going on with the tables.
Does anyone know of a way to change the forms to at this point (where they would access the table in a separate database). I hope that there is because I have a lot of code written in this project!

Thank you kindly.

 

[idd]

Try the following, this will split the database for you creating a front end and a back end.

first make a backup copy as you should always have a method of reverting back in case the split is not what you wanted.

so copy the file and save it somewhere else or same place with a different name.

Then open the DB and from the menus select the following.

Tools ---- Database Utilities ----- Database splitter.


what this will do is copy all your tables to a new database and create links to them in the current file.

The backend has only table

the front end has all the rest i.e. forms, queries, reports, modules.

hope this helps.

Iddris

 

[Harr777]

Iddris,

Thanks, that's great. Who knew! (not me).