Search results

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.

Hi Learn - your question is a pet project of mine You are asking where do I get something like MS Access except to create web databases? You are finding it difficult because.... it pretty much doesn't exist. (there are programs that are best described as 'getting there' but event management is...

NG - really great idea I try to practice humility not because I enjoy it but because I selfishly believe that it is the best way of getting better. I am a strong believer in the idea of Categorical Imperative - ie that there is an optimal solution or group of solutions that are independent of...

...... Thanks

Access front end with link to SQL Server - Where are the Queries RUN? I probably should know this but If you have a series of ETL queries , written and stored in an MS Access front end linked to SQL Server. If you run a script of those queries - what engine performs the heavy lifting - are...

Just a hunch but don't use * in the replace string. The code builds an SQL updated query and * is seen as a wild card which will do something very weird probably in an update query. How about change PINK to BLUE

and here's a function to randomise a field if you need it - not sure if this randomises two records of the same string the same or differently . I guess you might want to test that. (Looking at its use of the Rnd Function I think they might be different which may make it unsuitable) Public...

I did a quick tinternet search and came back with this. I would probably create a table to hold all the field names in and with the recordset write the table names to the table. Public Functions ShowTableFields() Dim db As Database Dim tdf As TableDef Dim x As Integer Set db = CurrentDb For...