By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

Sharing file updated

P: 4
I am maintaining a sharing Access application the file name is: [PTW_Rev310.accdb]
I put this file in the company server: F:\Suez Maintenance Data Base\Work Permits\ PTW_Rev310.accdb
And- The users taking copy from the server to local PC [C:\]
So I need the following
1. When I will update the file from current rev (310) to update rev (311)
AND when the users open the file who in their partition
THE Message appear [There IS a NEW VERSION take copy from the server] and close

Any insight or tips would be appreciated!
Jan 19 '15 #1

✓ answered by jforbes

[There IS a NEW VERSION – take copy from the server] is not a native message of MS-Access. You'll need to go into the code to see why it is giving that message.

My guess, from what you posted, is that the Original Developer put in a Revision number somewhere in the Database that needs to be incremented along with the revision number in the File that you set to (311).

Share this Question
Share on Google+
6 Replies


jforbes
Expert 100+
P: 1,107
[There IS a NEW VERSION – take copy from the server] is not a native message of MS-Access. You'll need to go into the code to see why it is giving that message.

My guess, from what you posted, is that the Original Developer put in a Revision number somewhere in the Database that needs to be incremented along with the revision number in the File that you set to (311).
Jan 19 '15 #2

P: 4
yes I mean that so what is the code to benefit for this case
Jan 19 '15 #3

jforbes
Expert 100+
P: 1,107
You'll need to go into the code and find the cause of the message. There are a couple different ways of doing this. One of the easiest may be to hit [Ctrl]+[Break] on your keyboard when the message is displayed to see the code that is displaying the message and work backward from there.

The other way to find out is to open the Database Options (this is done differently in different versions of Access) and see what is listed as the Display Form under the Current Database. Then you can open that Form in design mode to see what code it is executing and hopefully find out why you are getting the message you are.
Jan 19 '15 #4

P: 4
first thank you for your care
but I feel you are not understood me
the message not important for me just i want any thank to inform the user there is a new version in the server so omit your file and taking copy from the new version in the server like this code
Expand|Select|Wrap|Line Numbers
  1.  If Left(Right(strFileLast, IIf(bIs2007, 11, 9)), 5) <> Left(Right(strFileName, IIf(bIs2007, 11, 9)), 5) Or _
  2.           (nDiffMin > 60) Then
  3.  
  4.        'MsgBox Left(Right(strFileLast, 9), 5)
  5.        'MsgBox Left(Right(strFileName, 9), 5)
  6.        'MsgBox nDiffMin
  7.  
  8.         MsgBox "A new Version of this programe is available on server" & vbCrLf & _
  9.                "Created at " & dServerFile & vbCrLf & vbCrLf & _
  10.                "This file date " & dThisFile & vbCrLf & _
  11.                "Please copy the the file " & vbCrLf & _
  12.                strFolder & strFileLast & vbCrLf & _
  13.                "to your local hard disk, and delete this file", vbOKOnly, pconProgName
  14.  
  15.  
  16.         GoodVerPos = conNewRev
  17.         Exit Function
  18.     End If
  19.  
  20.     GoodVerPos = conNormal
  21. End Function
Jan 19 '15 #5

jforbes
Expert 100+
P: 1,107
Ahh, I think I understand. I was sure you were getting the error message, not attempting to provide the message.

I think you might want to refer to these posts as they are addressing a similar situation:
http://bytes.com/topic/access/insigh...ront-back-ends
http://bytes.com/topic/access/answer...-version-1-0-a
Jan 19 '15 #6

P: 4
Thinks alot i think that i want tomorrow i will try and i inform you with result
Jan 19 '15 #7

Post your reply

Sign in to post your reply or Sign up for a free account.