John,
The problem is that we have conditioned the employees to see if there is a locked file before entering the database, to not go in it. It looks like someone is in the database but they are not. Also if we make a copy of the database for maintenance, testing or to fix something the database looks like someone is in them and actually nobody is.
Jim Wagner
________________________________
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, November 29, 2011 1:01 PM
Subject: RE: [MS_AccessPros] Linked tables question
Jim-
You get locked out:
a) If one user opens exclusive
b) If one user opens read-only
If both users have full access to the database with the linked table and are
opening shared, there should be no problem.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Tuesday, November 29, 2011 8:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Linked tables question
Hello all,
We have 2 databases that we support that have a linked table between them. On
the form in the Executive VP database there is a subform with the source for the
subform has a Select statement
SELECT [LatestPSS].[movedate], [LatestPSS].[BALANCE] FROM LatestPSS; this shows
the VP the data she needs to see on a daily or even when she needs to see it.
The data is manipulated in the other database by a user who updates the
information. The purpose for this way is so the VP does not have to open the
other database just to see 2 fields values.
The issue is that whenever anyone is in either database, the database gets
locked or shows that someone is in both databases.
Is there a way of using a non linked table solution to get the data to the VP
without linking tables?
Thank you
Jim Wagner
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar