updating front end

i have gotten a sample code from
http://www.databasejournal.com/features/msaccess/article.php/3286111
where it looks for a version in fe database, comparing it to be, if it
doesn't match then it will automatically updates the fe database on each
client's copy.
i have copied the code/tables/forms exactly (changing the path were database
is located). however on splash screen.. this code is not working.

Private Sub Form_Load()

On Error Resume Next

If ReconnectTables() = True Then

strVerClient = Nz(DLookup("[VersionNumber]", "[tblVersionClient]"), 0)
strVerServer = Nz(DLookup("[VersionNumber]", "[tblVersionServer]"), 0)
Me.Repaint
Else
MsgBox "Couldn't Find Data Tables. Exiting.", vbCritical, "Error"
End If


End Sub
tblversionclient and tblversionserver does exist but the msbox pop ups.
thank you!


.

Relevant Pages

  • Strange Error :This action was cancelled by associated objects
    ... After Inserting the record into dataBase and then click on the Form/Refresh ... Sample Code ... Private Sub Form_AfterUpdate ...
    (microsoft.public.access.modulesdaovba)
  • Re: Converting Access 2000 back to 97
    ... Access 2000+, and recent versions of SQL Server, normally use ... and if any of your tables use nVarChar fields ... On the other hand, if this is a old database, using VarChar ... The sample code often demonstrates linking CurrentDB, ...
    (microsoft.public.access.conversion)
  • Re: Registering programs in access
    ... It worked fine for me with no changes to the sample code. ... 'Create text string containing "Database to Call". ... >> (no private e-mails, please) ...
    (microsoft.public.access.conversion)
  • Re: Create Site: The specified domain either does not exist or could not be contacted.
    ... I specified email server settings again which succeeded. ... if I use the complete sample code for extending a vs: ... Database 'sts_content' already exists. ... After you create a new configuration database, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: updating front end
    ... perhaps ReconnectTables() returns false - try to check this ... >i have gotten a sample code from ... > doesn't match then it will automatically updates the fe database on each ... > tblversionclient and tblversionserver does exist but the msbox pop ups. ...
    (microsoft.public.access.modulesdaovba)
Loading