Access 2007 use of 2003 db problems

T

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
 
B

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

__________________________________
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access 2010 Backend DB Backup/Restore 0
Converting a 2003 Access VBA DB to 2007 2
Problems converting old DB to Access 2007 1
keep 2 copies of a DB in synch with Access 2007 24
confusing error in access2003 db running in access2007 7
Using tables created in 2003 IN 2007 2
Access 2007 Split Assets db, issue moving to new directory 0
Shared DB Library 5

Top