Updating a database

[Guest]

Hello,

I use to work with a database I created; I run this database in a little
business of mine and I use to work in the database in my house. Usually I add
new tables, forms, queries and reports in my house and then I go to my
business and import the new things. But when I make too many changes it
becomes complicated. Does anybody know some way to do this updating process
in a better way?

Thanks and Regards,
Ibrahim

 

[Guest]

You should be working with a split frontend/backend database.

The backend databse has just your tables and would remain at work.
The frontend database has all your forms, queries and reports etc.
You could then just work on your frontend at home and just simply copy it
over the version you have at work. You can even add tables to your frontend
and then import them to your backend when you get to work and then reset them
to linked tables in the frontend.

Before you do anything - MAKE A BACKUP!

Look in the Access help for information about splitting your database.

Steve

 

[Joseph Meehan]

Hello,

I use to work with a database I created; I run this database in a
little business of mine and I use to work in the database in my
house. Usually I add new tables, forms, queries and reports in my
house and then I go to my business and import the new things. But
when I make too many changes it becomes complicated. Does anybody
know some way to do this updating process in a better way?

Thanks and Regards,
Ibrahim

For a start, try splitting the database. You want a back end where all
the data (Tables) are stored and a front end where all the forms queries
reports etc are stored and they are linked to the tables in the back end

That way you can work on a copy of the front end and just copy it over
the existing front end unless you have made changes to the table design.

Remember to bring home a copy of the back end.

 

[Peter Hibbs]

Ibrahim

As previous replies have said, split the database into front-end and
back-end. When you have done that look at these two sites which will
help with relinking the files and adding new fields and/or tables.

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'

HTH

Peter Hibbs.