Access 2007 use of 2003 db problems

[tgavin]

I have one client using 2007 in an office using 2003. I am having nightmares
with this. This is a copy that has several tables that synch with a master on
the network and other static tables that have to be replaced regularly to
update them because the owner uses it away from the office. I may add that I
am working with VERY computer illiterate people.

It won't import 2 of the major tables, it is not showing the conflicts
dialog box when synching, and some of the code is not working. I enabled all
the macros but the forms are not maximizing when the db is opened. There are
sporatic other cases.

I am having to get around the import problem by updating the tables off a
2003 machine and then just dragging a new copy to his desktop. This of course
means that it is not a true replica but it is the only way I can get it to
work.

Any help would be appreciated!

Terri

 

[boblarson]

Are you using Replication? If so, replication should ONLY be used with true
Jet objects (tables/queries) so it should be a backend. You should NOT use
replication for forms, reports, macros or code. It is not stable to do this
and you WILL end up with corruption (not a question of IF, but a question of
WHEN).

See here for more on Replication:
http://dfenton.com/DFA/Replication/index.php?title=Main_Page

--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[tgavin]

I was using it for replicating some of the tables, and all the queries,
forms, reports and code, but that was under 2003. Had no idea that would
cause problems. I would have assumed it was ok since when you set it up, it
automatically includes everything.

so going forward, if I separate out everything but the tables from the
replication, will it solve the problems with the inability to import the most
important tables and the code that is not working even though it is there and
written correctly. I mean, even i can't screw up docmd.maximize yet it's not
working.

 

[boblarson]

You also need to make sure that the Access 2007 user has done this:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[tgavin]

Already did that. Thanks!