Search results

apr I looked into this and have tried creating a new workgroup. The only problem I saw with this is that the user's MS Access will always look at this workgroup, when I only want/need it for this database. Is it possible to only use this workgroup when opening this database or does it have...

Is it possible that as soon as the form opens, it inserts the current username into a table I have created and then is cleared out when it closes? What I'm thinking is this: User A logs in and name is inserted into CurrentUsers table. User B logs in and name is inserted as well but another...

I have not tried the Environ option. I see where you are going with it, but the access does not need to be restricted to a table by user (all users have access to all tables) but I think it may be along the lines of something that may work. Does the environ always exist or just when someone...

Sorry for the confusion here. No it is not working correctly at this point. When two users are in at the same time trying to look at the same table (derived from multiple append & delete queries) they end up deleting each others views. This may just be a problem with how I wrote the macros...

I have gone to a split setup. The front end is on the server and I have made copies of that down to 2 test desktops. I run the macro to get table A on the first machine and while that is open, I do the same on the second machine. Once the second machine is done and I look back at the first...

After much more tinkering and moving and re-working the structure of the database, my problem has evolved yet again. The DB is set up to pull a list of purchases that higher ups have to approve. When table A is opened by the president it works fine, but if the president is looking at A and...

Pat I seem to have had the same problem as well. I was testing a DB yesterday. Could open it on 2 XP machines, but only one Vista machine at a time from what it seemed. Have you guys heard of a rhyme or reason on this? DB was created in 2007, converted down to 2002-2003 format.

Mailman Thanks the for idea. I thought that would only affect the PC I was working on, not all PC's the database was opened on (unless I went to each PC and did this). After trying that, and a couple other security configurations I gave in and re-wrote the SQL queries inside the DB so that...

Hey guys Thanks in advance for any help and suggestions. I have a MS Access DB set up and working fine except that I need to to open exclusively on the PC that opens the file. It is uploaded onto a server where a dozen users will have access, but only one can be in at a time to "approve"...

Maria Read through what you are looking for but have a question about it. Are you looking for the right 4 numbers of all of the cells, or just cells where there are only 4 numbers? From what Ken has, that will return the right 4 digits of all cells. If you are looking for only cells that...