Search results

  1. A

    Scripting access to secured database

    I am trying to script access to an Access database for use on the command line. The Access database is secured with a workgroup file. Dim oApp, sWGF,myWS Set sApp = CreateObject("Access.Application") set sWGF = "C:\Users\Alan\Documents\Secured.mdw" oApp.DBEngine.SystemDb = sWGF WScript.echo...
  2. A

    Problem Linking to a temporary table in SQL Server

    I am attempting to port an Access front_end/Access back_end application to Access front_end/Sql Server back_end. One small part of this application uploads a CSV file into a local table in the front end (using DoCmd.TransferText) and then proceeds to process it to merge the results into several...
  3. A

    Planning on switching to an SQL Backend

    I am currently looking after an Access Application for a client that has security built into a new .mdw file and is split across front end/back-end. The front end currently has about 70MB of forms,code,reports and queries, the backend has about 100MB of data. The number of users fluctuate...
Back
Top Bottom