Search results

How do I link documents to my Access ForntEnd application ? What I worn'a do: I like to have a form in which users can drag document (word, Excel etc.) into - I) don't wornt the document placed in Acces, just a shortcut to the file location. Any idea is appresiated. Romanov

:confused: I'm aware of how to create a function that automaticaly update my Table links from my Access FrontEnd to tables in a MS-SQL database : Public Sub RefreshLinksSQL() On Error GoTo RefreshLinks_Error Dim X As Integer, tbds As TableDefs Set tbds = CurrentDb.TableDefs For X = 0 To...

Linked SQL tables in Access looses primary key ? I'm having a very strange problem with my Access application. I'm using an Acces frontend application and my data is placed in a MS-SQL 2000 backend database.Because of slow communication between two offices, I have merge replicated my MS-SQL...

With Office 2000 and Office XP I have been using the Package Wizard to build setup packages for distributing Access solutions. One of the strong thing in this soliution is that it scans for dependencies and automatically add these to the package. Now I'm building application using Access 2003...

If have posted this quistion once before without finding any solution. I hope there is someone out there who can help - this is realy giving me a hard time. I trie to do a simple code in Access 2000 : Docmd.TransferText acExportMerge,, "tablename", "c:\filename.doc", True I keep getting the...

When I use the following command in Access 2000 : Docmd.TransferText acExportMerge,, "tablename", "c:\filename.doc", True, "" I get an error message saing : Cannot update. Database or object is Read-Only. The exact same code is used in my Access 97 application and works fine. If I take the...