Search results

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...

Just wanted to add that in Management Studio, the temporary table can be seen in the tempdb, but any attempt to display the columns gives an error message. This seems to be true of any temporary table - I created one using a query in the Management Studio and it also failed when I attempted to...

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...

Three reasons really - One - some worries that the current application is loading the network up pretty severely - and it also means one of our remote offices only choice is to come in as a remote client. Two - I am currently worried about manually needed to wait until all users are offline and...

Thanks for the tips - given that this is early days of the experiment, I am not constrained to do things one way or the other, so I am not wedded to an ADP - it just seemed from my other reading around the net to be what was recommended. How do I make the split between front end and back end if...

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...