Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jharding08
  • Content: Threads
  • Order by date
  1. jharding08

    Forms on Access 97 DB are locked, how to unlock??

    I have an old Access 97 database that i need to upgrade to 2003. I can get most of the tables and some queries, but the forms and modules are locked. Is there a back door to beign able to get read/write priviliges for this DB? I a good with access, just not the security part of it, i can get...
  2. jharding08

    Importing into Access From SQL Server

    I am running an Export table function that reads an sql server connection then imports a table into access db connection. I have code that reads an access db and imports a table into another (different) access db. this is the code: sSQL = "SELECT " & Columns & " INTO " & sTable & " FROM " &...
  3. jharding08

    Using OPENROWSET for SQL SERVER

    I am converting some sql statements that were designed for an Access database connection to make them work with SQL Server. Most of the time this has meant to use OPENROWSET for the external SQL Server connection while using a local Access table connection. Can anyone tell me why this...
  4. jharding08

    Converting Access SQL to SQL Server

    I have to do a data transfer between two databases. The code was already written to move data between two access MDB files. I am changing the backend database to SQL Server, which inevitably will change the SQL statement. here is the statement for two MDB's - "INSERT INTO Packages " & _...
  5. jharding08

    SQL Statement From Access To SQL Server

    I have to do a data transfer between two databases. The code was already written to move data between two access MDB files. I am changing the backend database to SQL Server, which inevitably will change the SQL statement. here is the statement for two MDB's - "UPDATE Packages P INNER JOIN " &...

Part and Inventory Search

Back
Top