Search results

  1. R

    Access Front End Changing backend SQL Servers

    This seems easy but I am having a problem Have not touched this in a few months Have the front end MS Acccess DB using an odbc link to the backend MS SQL server SQL Server has both tables and views Production works fine I want to take a copy of the Front End and point it at a different backend...
  2. R

    Creating a Report but no Data

    Still working away at this and relatively new to Access I have a Command Button that points to a subform The Subform uses an Unbound txt box to provide the list of items in a drop down list I have an Event Procedure that calls the Report on Click The Report uses a record source from a Query...
  3. R

    Slow response on Form in Access with queries converted SQL views

    Hi Great site I have moved on from my previous thread and converted all the Access Queries to SQL views I have an Access form that has an Row Source with an enbedded Select statement with a couple of trims and Like variable in it. What the form is doing is a Find within the database on either...
  4. R

    Converting DLookups in Access DB Backended in SQL Server

    Hi Just joined this forum looking for some help on a small ( 11Meg) Access database. I do not have a SQL server background I work in a larger organization where we have a DBA group but they do not support the migration from Access to SQL server. They support the actual database only No query...
Back
Top Bottom