Access 2000 ~ Vista error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 20 Jul 2007 08:28 GMT

We recently updated all 5 computers in a small office to Vista. We run an
access database for receipting purposes. Now after the upgrade, we are
unable to open the database in a share mode. Only one workstation can have
it open at a time. Any idea why? I've checked everything I can think of
with Vista, not knowing much about it as of yet. Any input would be greatly
appreciated. Thank you !! Tony

Reply to this Message

Allen Browne - 20 Jul 2007 09:37 GMT

After installing Vista, you will have had to install Access again. You may
need to set each copy to Shared Mode under:
Tools | Options | Advanced | Default Open Mode

Note that the actual mode the database is opened in is set by this setting
on the *first* machine to open the database in this session.

The other possiblity is that you don't have adequate permissions on the
folder where the database resides.

You may also want to create an administrative shortcut for opening Access:
http://allenbrowne.com/bug-17.html#RunAsAdmin

If you have multiple users in this database at once, it would be helpful to
split it:
http://allenbrowne.com/ser-01.html

Signature

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.

> We recently updated all 5 computers in a small office to Vista. We run an
> access database for receipting purposes. Now after the upgrade, we are
[quoted text clipped - 4 lines]
> greatly
> appreciated. Thank you !! Tony

Reply to this Message