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.
--
S. Manley

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SMManley" <(E-Mail Removed)> wrote in message
news:2067EC5E-9205-48D6-8929-(E-Mail Removed)...
>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.
> --
> S. Manley