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
Tidak ada komentar:
Posting Komentar