Search results

I'm trying to automate this process from the live DB. Also, It's an access front end with Linked sql server tables. Therefore, cant import the tables as they would be the live ones. Also, I do not have access to the sql server back end to do this there - therefore, got to try and automate this...

I cant do that as the current DB is my master and the other is for training. Therefore, once a month I intend to delete all data from the training and then update it with new data. Hence I cant bring the Training tables into my live DB But thank you

I am trying to delete data from several tables in another DB - where the table name matches the tables in my current DB. I so far have: Dim t As TableDef DoCmd.SetWarnings False For Each t In CurrentDb.TableDefs If t.Name Like "*" Then CurrentDb.Execute "Delete From T.name In...

Can't just Delete the tables as they are sql tables and deleting them and copying them across will only copy over the live tables into the Training access Database. Also, I cannot delete the data and repopulate due to the hundred thousand records in some tables - it would take hours

Hi - not possible to delete the data - as a number of tables have a few hundred thousand lines and it'll take hours - unless it's possible to overwrite the exisitng data Thanks Jason

I have two identical Databases - one is a Live DB and the other is a Training DB. The data is held on a sql server connected to an access front end. (I do not have access to the sql server). - On each table I have a field called UpdatedOn - On each table every record has one field that is a...

Thank you to those who responded. I have now resolved the issue. When I ran another working Query that has been ok for years - that failed as well. Therefore, I went back through my clients to the point I added the new timer code and the original Queries worked fine. Therefore, I created a...

In VBA I have set a timer on a form to run a query and export to a specific folder as an excel file. If I open the database as 'File Open' and open the form and let the timer run it exports perfectly. As soon as I put the database into runtime - the Timer code kicks in and starts running but...

I have an extremely strange problem. I have an access database front end linked to a sql server backend via ODBC . The sql server was a replicated server of 4 up to 27/03/14 and then 3 were decommissioned leaving just the one server. The issue I'm having is if I run a pass through query in...

I don't have direct access to sql server, but I do have a mirrored environment on a standalone laptop. When I run the same query directly in sql query - it's fine!! If I try and use a plain access query - there are so many records it takes forever anyway - hence I've always used a pass through.

I have an access 2007 database connect to sql server 2008. I am running a pass though query to search between two dates (this query has been fine for years) If I now run any search using parameters from 26th March 2014 to date - the query takes 10+ minutes to run. If I then change the date...

Hi I tried: Set Wbk = Nothing Set xlsApp = Nothing this didn't work. I also tried your replacement code - but my office network does not allow direct access to "c:\windows\explorer.exe" therefore all I got was an error. Any other ideas?? Thanks for your help though :)

Thanks, I'll give your suggestions a go. Essentially, I open an Excel from access. Which is just a cmd button to open the file. The excel file auto displays a form with several fields to complete (in no way is it linked to access). Then they click a send button to auto send the completed form...

Hi, This is the code i'm using. Ignore the first part as it's just copying the xls file into the temp folder. Therefore, the files named string is SDest and then I'm just opening it: Regards Jason Dim SDest As String Dim SSource As String Dim DName As String Dim Temp As String DName =...

I am trying to open an excel doc from a command button using vba. I can open the excel file, but because the excel file has a userform on open, access is then locked and I can't even look at it and the excel userform doesn't work correctly. Therefore, Im sure there's an extra step in access...

Fantastic.....Top drawer Thank you very much...it worked perfectly Jason

In my make table qry I have to build, do I have to add the 1st table in the database. Not really sure how the make table qry will look like. As your code will run this qry for every table, so not sure on the tables etc in the qry Thanks for your help

Hi thanks will give it a go :)

PS...I placed this problem in this forum as I believe it can be done in vb!!

I have an access database connected to a sql server. How can I export/copy the sql tables into another database as Access tables? Not as sql tables! I could write make table qrys and run them as a macro, but it'll take ages to write 250 qrys to do this. Any help please!!!!