Search results

Thanks all. By the way, I'd just about cracked it when I stumbed across this: http://www.access-programmers.co.uk/forums/showthread.php?t=191823

Having a senior momen here! I've done re-linking tables in the past but this is slightly different. Can anyone point me to code to link an Access FE to an Access Back End WHERE I don't know how many tables there are or what they are called? Any links gratefully followed! Thanks

Hi there everyone. An update and a question. As mentioned before, in order to keep the Acces database running I'm developing an archiving system in order to keep the file size down. The archive will be on SQL Server, so here's the plan:- Create an accdb file containing the 18 tables that I...

Thanks namliam - all sorted.

Access 2010 vba - I'm trying to pass a start date and end date to a date field in a make table query, and use the 'between' operator on that date field. So I have a criteria on the date field like this "Between [dtStart] and [dtEnd]" and if I run the query manually it asks for 2 values and then...

I do custom Access programming for a living and if I told my customers you can't have an amended report until sometime next year then I'd be out of business!! BTW, namliam is right, if you can get at the SQL data then Access is a pretty good tool to generate some reports of your own. And...

Thales - just for your info I had previously written an archive system for this client but didn't use it at the time as we thought we were going to SQLServer. I just need to tidy it up a little and we're ready to go. The code could run every day if we wanted but we just picked monthly as it...

I'd like to thank everyone who has contributed to this thread, and I thought I should bring you up to date. The existing application using both an Access front end and Access back end has always worked well, even with roughly 100 users. It has become quite a large system with hundreds of forms...

CJ_London. Very cunning idea but I was having trouble getting the buttons just right. So I had another go at Googling and found a simpler answer, which is to use the OnChange event of the tab control itself, then inspect the tabcontrol.value and that gives you the index number of the tab...

Update from my previous message:- I have created a series of stored procedures and have replaced the code for all the pages that display fields of data. This has made some difference to the overall speed of the form opening, but I need more. So I'm looking into using stored procs again to...

Thanks to everyone that has contributed to this thread, it's been very useful. I'm still not sure what exactly to do to make things faster, in particular the main multi-tab form, but for anyone that's interested this is what I'm planning to try. 1. There are 17 tabs on this form. The first is a...

SQL_Hell and others Apologies for not responding sooner but have been away for a few days break - needed it! I manually rebuilt the worst of the indexes a table at a time and that seemed to improve things by approximately halving the time to open the key form that I mentioned previously. This...

Good news:- sorted that out Not so good, no change to index fragmentation. I presume it's me!! Thanks for spending the time on this. I'm out for an hour or so so I'll have a fresh look when I get back

Right, got it. Easier that I realised. So then I executed the code you sent me to check the top 20 worst index fragmentation but I get zero results. The table headers are there but no records. Sorry - being a bit thick today, but any ideas where am I going wrong? PS it goes without saying - a...

I created a new database called SQLAdmin as suggested. I downloaded the full MaintenanceSolution.sql and installed it and executed it. But now what - as a total novice I have no idea what to do next. Would you mind spelling it out as I can't see where I can run something and select version B. I...

SQL_Hell Thanks again.Don't worry about out of hours because I'm doing all this on my own SQL Server, and will do it eventually on the client's. But neither of them are in use at the moment. As for the troublesome form, it's not the only thing that seems slow, but it's the one form they use...

2 files attached. I haven't worked out how to attach nice looking files. Hope the attached txt files are readable Dave

SQL_Hell Here it is allow updates,0,1,0,0 backup checksum default,0,1,0,0 backup compression default,0,1,0,0 clr enabled,0,1,0,0 contained database authentication,0,1,0,0 cross db ownership chaining,0,1,0,0 default language,0,9999,0,0 filestream access level,0,2,0,0 max text repl size...

To SQL_Hell (great name by the way). I agree that it seems unlikely to be hardware but we are still puzzled by the fact that the apparently least capable machine, mine, is 4x faster than the client's server. Just to be clear, there are many parts of the program but the key part is the display...

To Rx - thanks for all your feedback, it's much appreciated. Here are some of the answers:- 1. The SQL Server is in a virtual Server 2012 2. We did use the SSMA, I just used the word upsize as shorthand 3. I do all the linking in code, as you say very quick to switch 4. We are using the SQL...