Search results

Dang, it would be SWEET if that were built in to Access/VBA. DBMSs (SQL Server, MySQL, and Oracle) have some logging but not enough to help out very much when developing. Alas, you'll need to roll your own.

No doubt, one of your users is putting the database into exclusive (read only) mode. You should not be sharing a single Access file between 4 users. You should look into splitting your database into a front end/back end solution. Each user should have the front end on their own workstation...

You haven't given us much information but the superfluous answer is that you need to make sure the Access file and the directory it is located in is not read-only. What kind of network are you on? How many users? Is there an IT department that controls access to folders? Etc.

There are a lot of people with tons of Access experience who tell you to do the wrong things. I think if you'll follow the writings of Access MVPs, and Access forum VIPs, you'll find that they all agree to normalize and use sub-forms as appropriate. These guys (including Bob) are well...

That means that you haven't yet put a unique key on ALL the columns that would prevent a duplicate (aka "same") authority.

It is very difficult to follow your code because of the PHP Code tag you used. That is probably why nobody looked at it before. My guess is that you need to read the help file on UBound and reconsider whether you really want your For loop to go only to UBound - 1. iCounter =...

Put a unique key on the columns in question and your DBMS will do that for you.

Duplicate thread reported: http://www.access-programmers.co.uk/forums/showthread.php?t=176927

Usually a problem like you describe will be obvious whether you provide data or not.

If you are doing data entry on multiple joined tables, you should be using sub-forms for related tables. When queries become complex, they become read-only. See http://allenbrowne.com/ser-61.html for more details.

The shortcomings you list for Access can be overcome by training. Access beats Excel hands-down for dynamic data entry. And the reporting should be comparable or better in Access (depending on the design and skill of the report writer).

I forgot to throw in napping, IMing (usually with co-workers so it looks like work), stopping by other bored workers desks so it looks like we're collaborating, etc.

e-mail, Facebook, AWF, creating database samples (this actually LOOKS like it could be my job). Every now and then, I'll do some real work.

I don't understand the question. Put them in the select and group by clauses separated by commas. select top 20 field1, field2, fieldetc, target_host_name_path, count(*) from Results group by field1, field2, fieldetc, target_host_name_path order by 5 Desc

Cool thing about using Access is that you don't have to know code. Just use the built in Query Builder tool. The instructions for using it are in help and the topics I mentioned before are well supported in the Query Builder (aka QBE). Then to see what happened, just look at the SQL view.

In Access help, look up: Count() group by order by top

Ooooo. I saw that thread and decided not to respond. I'm just not smart enough. I'll let you guys handle it.

NP, hope your system roll out is successful.

What were you trying to say again, Bob? Slade, what Bob says is quite true. If you're not doing a multi-step data conversion from one system to another, there is no reason to do what you're doing. Stated another way, if this is a transactional system (OLTP) there is absolutely no reason for...

Look at using an "update" query.