Re: updating front end

perhaps ReconnectTables() returns false - try to check this

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com



"GEORGIA" <GEORGIA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:702F04B8-386E-4A22-9FE7-8C1C4B4B757E@xxxxxxxxxxxxxxxx
>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

  • updating front end
    ... i have gotten a sample code from ... doesn't match then it will automatically updates the fe database on each ... Private Sub Form_Load ... tblversionclient and tblversionserver does exist but the msbox pop ups. ...
    (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: Link to a new table location
    ... There's sample code at "The Access Web" in ... as it's only set up to handle all tables being in the same database. ... "Beth" wrote in message ...
    (microsoft.public.access.tablesdbdesign)