Search results

  1. T

    Embed PDF file in bound control

    I need to embed a PDF file into my DB. Based on the client's business rules I cannot maintain the document outside of the DB. I cannot therefore link to a given location outside of the database. The code that I am using, which I have confirmed from several different sites, is as follows...
  2. T

    Sending Access Report via Networked Fax Service

    How do I output a report from Access 2007 directly to a Fax Server residing on Windows 2003 server? The idea being to run a "mail merge" like application that sends the correct document to the correct recipient. I do not want Outlook installed on the client machines though, so the solution...
  3. T

    How do I run a T-SQL statement from within ACCESS VBA

    How do you write a purely T-SQL state such as CREATE VIEW, ALTER TABLE, GRANT/REVOKE CREATE DATABASE within VBA. The idea being that I wold like to build up a dynamic sql string, based on user input, then EXEC that string via Access/VBA on the SQL Box. This is part of the SQL Admin project...
  4. T

    SQL Server Admin Project

    With XAMPP in the PHP world, you can install PHP, Apache, MySQL and all of the tools needed to manage a complete solution from a single installer. All of the ADMIN for this environment is then run from a PHP driven front-end, which I reckon is pretty cool. So, I want to recreate that kind of...
  5. T

    Re-Attach SQL tables via VBA to Access 2007

    Anyone got any ideas on how to re-attach SQL Server linked tables please? I need to re-create a connection with a different user after clicking a LOGIN button. I have been running around in circles now trying to figure it out and am at the point where I need to ask for help. I have tried the...
  6. T

    Record lock problem - Access 2007, SQL Server 2005

    Okay - my turn.:rolleyes: I have an Access app (duh) with linked tables to SQL Server 2005 at BE. I have a specific table that is the record source for a form. Whenever I try to edit data in this table it complains that someone else has edited or is busy editing the record. Gives me the...
  7. T

    Access 2007 Runtime Problems

    I would like to start a single thread that lists all of the problems associated to the use of Access Runtime here. If there are more than say 3 or 4 responses on a given problem it warrants a new thread with links from this central thread. I have already noticed several discussions across the...
Top Bottom