Access 2000 to Access 2007

[Guest]

I just recently upgraded a customer from XP Home to XP Professional; all was
fine. Then I upgraded them from MS Office 2000 to MS Office 2007
Professional. All okay, EXCEPT Access. Someone wrote a billing program for
them in MS Access 2000 and when I loaded 2007 it would not pull the files up;
I went in and altered a few things, like "Allow Macros" and it started
running. Problem is, now the two older systems who are networked into this
one, CANT read the files. They share the same database.

HELP!!!!!! PS: I am NOT an Access guru.

 

[Allen Browne]

Couple of configuration suggestions:

1. The database should be split so that each user has their own copy of the
front end, and they share a back end. So,
1.1 Make sure you give the new A2007 user the front end.
1.2 Make sure the A2007 user has full rights (read/write/create/delete) to
the folder where the back end is.
More info on split databases:
http://allenbrowne.com/ser-01.html

2. Click the Office Button, then Access options
2.1 Under Advanced, make sure the Default Open Mode is Shared.
2.2 Under Trust Center, add the database folders to the Trust Center
Settings.