Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 6th, 2011, 09:14 PM
Registered User
 
Join Date: Feb 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Table in VBA

There is a VBA add-in that can help take away some of the complexity. I use this to link to four different databases (MS Access 2007) for users on a LAN. The users connect via the internet. The databases are encrypted. The front end includes a reference to the VBA add-in which does all the work of linking the various tables. The tables and their locations are listed in a local table which the add-in reads and loops through as it builds links to the remote databases. This add-in can be downloaded from -> http://www.access-linked-table.com

Good luck and happy coding!
Milos
 
Old March 18th, 2011, 08:29 AM
Registered User
 
Join Date: Mar 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Opning Balance In Report Or Brought Forward

In My Database Have Report is About Ledger Openin Balance Problem Kindly Guide
 
Old March 18th, 2011, 08:33 AM
Registered User
 
Join Date: Mar 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Smile Opning Balance In Report Or Brought Forward

How i Define Opeing Balance in My Report in Ledger
Iam Trying But I Failled so plz Help Me

Kindly Send Me A Sample
To , My
muhammad.aamir835@gmail.com
 
Old November 22nd, 2012, 02:15 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default accdb Issue

Code:
    For Each vCounty In lstWeather.ItemsSelected
        CID = Me.lstWeather.Column(7, vCounty)
        Path = DLookup("LocalPath", "CountyCode", "CountyCode = " & CID)
        FileName = Path & "EngineRoom\CODispatch_be.accdb"
        Set rdb = OpenDatabase(FileName)
        Set dbsTemp = CurrentDb

        ' Call the ConnectOutput procedure. The third argument
        ' will be used as the Connect string, and the fourth
        ' argument will be used as the SourceTableName.
        ConnectOutput dbsTemp, _
           "CODL", _
           ";DATABASE= " & FileName, _
           "DispatchLog"
        rdb.Close
    Next

End Sub

Sub ConnectOutput(dbsTemp As Database, _
   strTable As String, strConnect As String, _
   strSourceTable As String)

   Dim tdfLinked As TableDef
   Dim rstLinked As Recordset
   Dim intTemp As Integer

   ' Create a new TableDef, set its Connect and
   ' SourceTableName properties based on the passed
   ' arguments, and append it to the TableDefs collection.
   Set tdfLinked = dbsTemp.CreateTableDef(strTable)

   tdfLinked.Connect = strConnect
   tdfLinked.SourceTableName = strSourceTable
   dbsTemp.TableDefs.Append tdfLinked

End Sub
I googled into this post and thought all my problems were solved. However, I appear to have stumbled into an suffix issue with TableDefs.Append and accdb. Whenever I run the code, I get an error 3055. The onboard help indicates this is a problem with the naming convention in the operating system. All of the code in the examples/Microsoft use the mdb (pre 2007) extension. Anbody have a work-around for this?




Similar Threads
Thread Thread Starter Forum Replies Last Post
Read-Only Linked Table pjm Access 6 August 21st, 2006 07:42 AM
Can a Make Table Query produce a Linked table? kronik Access 5 May 16th, 2006 06:17 AM
Linked Table sdilucca Access 1 February 24th, 2006 07:29 AM
Calling a stored make table query from VBA jas644 Access VBA 0 March 30th, 2005 06:29 PM
linked table Tasha Access VBA 1 August 6th, 2004 03:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.