Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: same access file opened on 2 computers to update while open on both

18 Nov 2011   #1
blueyedsamurai

Windows 7 Ultimate x64
 
 
same access file opened on 2 computers to update while open on both

I have a shared folder that i mapped so 2 computers can share the files. Both computers have access 2007 installed.

What i want to do is have them able to open the same access file and have it update while they both have it open?


My System SpecsSystem Spec
.

18 Nov 2011   #2
Maguscreed

Microsoft Community Contributor Award Recipient

Windows 7 x64
 
 

Man it has been a long time since I messed with access, but I do recall a method where it actually duplicates the file allows the changes from two sources, then sync's them back into a single file.

Anyhow what you want is possible if not exactly the way you are looking to do it. I'm sorry I haven't had my coffee yet and as I said it's been awhile.
My System SpecsSystem Spec
18 Nov 2011   #3
blueyedsamurai

Windows 7 Ultimate x64
 
 

thanks for the reply anyway but i actually figured it out.

I never use it and at the office they have 2 girls typing leads and they wanted it to update but it wasnt.

all i did was change the security settings to allow network with full permissions and it worked...its a bit laggy but it will do.

if theres some other way that isnt as slow the im all for it
My System SpecsSystem Spec
.


Reply

 same access file opened on 2 computers to update while open on both




Thread Tools





Similar help and support threads
Thread Forum
Open MS Access file
Hi all, I need a little help. We got a new computer in the office and it is running Win 8.1. We also have 2 older computers and they are running win XP. I have them all networked together and everybody can see and edit all files on any computer. So far so good. Here is the problem: MS Access...
Microsoft Office
Cannot open file Access is denied message
Hi all. I have a strange issue (or so it seems to me that i am a newbie) . I try to use a small utility which reads massively *.txt files and if they are saved as ANSI it saves them as Unicode. The problem is that when i run it (run as administrator) i get an error message saying "Cannot open...
General Discussion
Outlook 2010 Access denied. Cannot open pst file.
Hello everyone, I wonder if anybody has the same issue as me. My Office 2010 beta just expired, so I had to uninstall MS Office 2010 and reinstall the official release. After the uninstall, I saved my pst file to a different location and cleaned the AppData directory of Outlook which...
Microsoft Office
Access 2000 - Database Locked when opened by a specific computer.
Hi again, everyone. I'm having some Access woes with which I have been unable to find help about around the web, as my circumstances don't seem to fit other reports of this problem. I get the dreaded: The database has been placd in a state by user <name> on machine <name> that prevents it from...
Microsoft Office
If FF is opened, Email links will not open. Any fix?
If I have Firefox Nightly x64 opened and click on a URL link contained in a Thunderbird email, I receive a message warning that states that FF is running and need to close before I can open the selected URL link. See attached image. I don't really want another FF session opened. What I would...
Browsers & Mail
Put file on desktop -> open file -> access denied?
Hello there. Whenever i take a file and put it onto the my desktop, all the permissions to the file is completely stripped. Leaving none able to open the file. I am able to go into access control and add myself again, but it makes no sense at all.. Why does windows do this and do anyone know...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:48.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App