John,
I will try that today. Thank you very much
Jim Wagner
________________________________
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, December 1, 2011 6:27 AM
Subject: RE: [MS_AccessPros] Linked tables question
Jim-
You could create a procedure in the startup of the VPs database that fetches the data into a local table and then releases the back end.
On Error Resume Next
' Delete the existing table - if it exists
CurrentDb.TableDefs.Delete "tblDataForVP"
' Import a fresh copy
DoCmd.TransferDatabase acImport, "Microsoft Access", _
"X:\SharedDB\DataDB.mdb", acTable, "tblData", "tblDataForVP"
' Make sure all is clear
DBEngine.Idle dbFreeLocks
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 Jim Wagner
Sent: Thursday, December 01, 2011 2:16 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Linked tables question
John,
Several reasons for the training this way,
The culture of the department constitutes it. It is very strange way of doing things I know. (Before I started here thing)
The lack of support for a one back end database and multiple front end solution based on security issues.
I was hoping there was a way to get the data to the VP without the linked table and this would not be an issue here.
Jim Wagner
________________________________
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, November 30, 2011 11:54 PM
Subject: RE: [MS_AccessPros] Linked tables question
Jim-
The lock file will be created if the VP opens his copy with the linked table and then opens the link. Why do you have your people trained this way?
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 Jim Wagner
Sent: Wednesday, November 30, 2011 10:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Linked tables question
John,
I did not explain it correctly. The databases have locking files in the folder but are not locked out from others getting in them. I was trying to figure out a way to have the VP see the data without having to link the table and creating the lock file in the folder so people do not think that someone is in the databases.
Jim Wagner
________________________________
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, November 29, 2011 1:29 PM
Subject: RE: [MS_AccessPros] Linked tables question
Jim-
Two possibilities:
1) Not everyone has full access to the folder in which the database is stored.
2) Someone crashed out of the database and left a .ldb file hanging around.
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 Jim Wagner
Sent: Tuesday, November 29, 2011 9:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Linked tables question
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]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar