Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #12395

Re: Access 2010 out of sync on a LAN

Show all headers | View raw

Thanks Patrick.

I copied the back end database from the other computer onto a usb drive, then opened the two versions side-by-side, and it's clear that the tables are out of sync. Same ID numbers show different data in multiple places in the active tables. 

I did not delete and re-add the tables, but I did refresh the links via the linked table manager.

After some conflict with my SysAdmin I showed him 2 screenshots of the same directory showing the same file names with 2 different file sizes and file dates, and he's working with me on the assumption that it's a very strange network problem and not an Access issue. 

-tc

On Friday, February 24, 2017 at 8:43:55 AM UTC-5, Patrick Finucane wrote:
> On Friday, February 24, 2017 at 8:12:18 AM UTC-5, itha...@gmail.com wrote:
> > My Access 2010 DB uses linked tables that are located on a file server on the LAN. The front-end files are located on the desktops. 
> > 
> > When the other user adds data via his front-end, the changes do not show up in my front-end, even after restarting Access, restarting the computer. When I sit at his workstation to and view the back-end tables in Windows Explorer the file size is 2840 KB and the added records are there. From my workstation the file size is 2836 KB and the added records are not there. 
> > 
> > I did check to confirm that the drive is mapped correctly. This is the same file. I am concerned that if I add or edit data in this non-synchronized system I will corrupt the file. A knowledgeable sysadmin who does not know Access thought it could be a file-locking setting in Access. I doubt this because I have not seen or heard of this but I'm not sure. 
> > 
> > I suspect that it's a network error, but I'm not sure. My System Admin literally does not believe me, so I am getting no support here. (To be fair, I also don't fully believe this, but every way I look at it, it's happening.) I'm running a virtual desktop on a Windows 10 OS, the other guy is running his virtual desktop on Windows 7.
> > 
> > I've been developing Access databases since 1992 and I've never seen this. I have not been able to find any previous threads on the topic
> > 
> > Any help would be deeply appreciated. Including search terms that might help me find previous threads on the topic, from this or Windows networking forum.
> 
> What happens if you unLink all tables on the problem machine and then relink? ALso, have you verified your results via running some queries on the tables in question?  Maybe a form is incorrect.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Access 2010 out of sync on a LAN ithacabus@gmail.com - 2017-02-24 05:12 -0800
  Re: Access 2010 out of sync on a LAN ithacabus@gmail.com - 2017-02-24 05:20 -0800
  Re: Access 2010 out of sync on a LAN Patrick Finucane <patrickfinucanetx@gmail.com> - 2017-02-24 05:43 -0800
    Re: Access 2010 out of sync on a LAN ithacabus@gmail.com - 2017-02-24 07:09 -0800

csiph-web