Search results

Top work MajP thanks for assisting.

I tend to build systems where there my popups are set to modal yes and I only have one of these open at any one time. I just find it easier to manage.

Not sure yes its possible to run a vba function from the desktop using a vbscript I have something sorted so I can run compacts. http://rounduptheusualsuspects.org/?p=1386 This is the vbscript which shows where you put your function name it doesn't entirely run it from the desktop though. It...

Congratulations from a newbie

Here are some musings I have seen a number of systems like this that send stuff. Be aware that you are probably not going to be sending anything anywhere in the design. You simply have a case file that gets allocated to different individuals. I would suggest that that information is held in...

Firstly I would recommend looking at SQL Azure databases which is the first step into experimenting with web databases. I am essentially echoing Gizmo - experiment with Web but I wouldn't deprecate Access. At the end of the day if you have any form of LAN then it is likely to be cheaper to...

I think with patience and a following wind that strategy might work.

I use MS Access 2003 on windows home 10 haven't had any issues.

Yes I believe this is called multi-tennacy - I've been meaning to try and learn about it. I can see the benefits but at the moment I suspect it would be overkill big time for me. Most companies don't use it and those that do are spending a lot of money on this kind of thing.

rede its not clear from your post but you might be interested to know that there is a way of automating the compaction of MS Access databases - you have to do it via an external script because MS Access closes down as part of the compact procedure and any vba script running within an MS Access...

My interpretation of this . DSN is simply the name given to the small data store that indicates the type of database and the name of the database along with any passwords. It doesn't in itself contain text or functions that execute in anyway - if you could read a DSN file in a text editor it...

I use this quite a lot to print multiple individual PDFs It loops through the records in a query and prints all to a directory and names them something meaningful in this case an index based on an id. Which is exactly in line with Pat H's comment. Where the fields in the QUERY-ListofIDtoPrint...

Hi Wayne not RAF afraid its actually the old name of a windsurfing manufacturer its was a random choice when I firsts signed up - little did I know I would still be hear 14 years later :) Here's something you may find interesting - I and many others are trying to find the same solution. Web...

Have you considered SQL Azure? Its more involved to get set up and it involves learning SQL Server but its a true cloud based managed database where initial hassle is learning the configuration but after that offers true true scope for limitless expansion. This may be more than you need it...

Doc - someone posted an interesting comment on the poll comments section that you might want to read it is quite interesting and has a different view on the 2GB limit. It is by Mark Burns Link again User Access Poll increase 2GB file size

Thanks for the explanation I thought there might be some deeper reason to the limit. I also think that it would be great. At some point presumably they are going to have to do it. Hopefully the polls on user access forums will give support to those individuals within MS who think its time has...

Probably could get a 30% reduction but still need to import it initially and then run some procedure on it. I am working with national address datasets as well and it is causing similar size issues. One of the reason I requested the increase size to be considered. Having a single file that is...

Dear All Just thought I'd try and garner some support! I've requested that Microsoft think about increasing the default maximum file size for MS Access files on the Microsoft Access Users Voice from 2GB upwards. This is an idea that has been floated twice before and Microsoft has responded...

Excellent run down and identification of issue - hard to get things working when they are bugged!!! I would imagine even Microsoft will want to fix that.

I'll take it over politics anyday . My wife loves the royals but not really mentioned it much at all. Couple of colleagues talked about it for an hour so I've really not had to endure much at all.