G
Guest
Hello, I am really confused, let me run down quickly what I think I have
figured out ...
-Replication has been removed in Access 2007
-Access 2007 is focusing, for advanced use, on being the front end of the
database, and for end user queries / reports, if you want replication you use
a different backend than the Access tables
-Microsoft web site says ahre point for those function, but when I look at
the prices it looks like we are talking thousands ... I have a one employee
business ...
-The microsoft web site does not address (as far as I can tell ... ) the
lower budget alternatives to replication.
- I gather from searching, that some other back end solutions offer
replication,
My replication needs are light weight - I just want to be able to edit some
records at home with out having to worry about wether I remembered to copy
over the database to work before we make changes to the database at work. So
.... record level syncronization. The need is not intense enough to write
custom code or rewrite the front end ...
So my questions ...
-Are the above assumptions correct?
- are there any choices for a different back end than Access that allows for
replication that Access can link to in the free open source to hundreds
rather than thousands price range, and that allows for the same kind
abilities such as auto cascade of updates and deletes and forces referential
integrity?
Thanks!!!
Roger
figured out ...
-Replication has been removed in Access 2007
-Access 2007 is focusing, for advanced use, on being the front end of the
database, and for end user queries / reports, if you want replication you use
a different backend than the Access tables
-Microsoft web site says ahre point for those function, but when I look at
the prices it looks like we are talking thousands ... I have a one employee
business ...
-The microsoft web site does not address (as far as I can tell ... ) the
lower budget alternatives to replication.
- I gather from searching, that some other back end solutions offer
replication,
My replication needs are light weight - I just want to be able to edit some
records at home with out having to worry about wether I remembered to copy
over the database to work before we make changes to the database at work. So
.... record level syncronization. The need is not intense enough to write
custom code or rewrite the front end ...
So my questions ...
-Are the above assumptions correct?
- are there any choices for a different back end than Access that allows for
replication that Access can link to in the free open source to hundreds
rather than thousands price range, and that allows for the same kind
abilities such as auto cascade of updates and deletes and forces referential
integrity?
Thanks!!!
Roger