Search results

Hi Bob, At this point, I hope I am not going to have to add any fields to existing tables. We have worked hard to try to think of all the information we need. What I am adding is data in the tables. These are look-up tables. I am having to continue developing this as we add new programs...

Ok, I'm back with another question. When I imported into the Production BE a table that I had modified in development, it created a new table with a 1 at the end of the name. I tried just changing the name of the new table by removing the 1, which it seemed willing to do, except then I got a...

Alrighty!! Thanks again. Have a great day. Cheers! ~RLG

Yes, thank you, that was very helpful! I copied the development FE into the production FE before importing the tables. Would you do it the same way if the tables are pre-existing tables that have been updated (such as look-up tables) - import them into the BE before updating the FE? Thank...

Well, let me backup and ask this. After I split the production DB and the development DB (which I have already modified with changes). I just copied the development FE over the production FE and then tried to import the new tables. Is that how you update the FE? ~RLG

Good morning Dave, Thank you for that great explanation! I looked up locking in one of my books and it says that Access 97 (V8) and earlier, locked a 2 KB page each time somebody updated, inserted or deleted rows. In Access 2000 this was increased to 4 KB but Access 2000 (V9) and later also...

Hi Bob, I am playing with this to make sure I understand the steps before doing it for real. I have a BE and FE of a copy of my production DB. In my development area, I split my db there. Then I imported some new tables into the "production" db from the development db. When I try to link these...

Hi Bob, I have been reading through the link you sent in another thread: http://www.kallal.ca/Articles/split/index.htm He talks about adding a new table once the db has been split but his instructions are for 2003 (I think). How would I go about it in 2007? Do I import it from the...

Hi Bob, For the most part it is set up that way. Each person is assigned a particular program and the records are filtered by program. But there is one instance where there are 3 people assigned to the same program. They need to be able to see each others records. So I think it will be ok...

Thank you for the quick reply. That makes sense. I think in this situation, there is very little chance that multiple users will be needing to update the same record - they each have their own clients and should only be updating the ones they are responsible for. Cheers, ~RLG

HI Bob, Could you explain why it is better to set the Record Locks = Edited Record at the form level instead of "wholesale"? TIA - ~RLG

Sorry for the long gap in time. In our set up, each user doesn't not have access to their hard drive. Everything is done from the network. It is my understanding that a typical split of the db would be to put the forms, reports, etc on the user's computer and the tables on a shared drive...

Hey Bob, Well, if you don't know of a way then there is a very good chance that there isn't a way! Thanks for replying. ~RLG

You are right and I have looked into splitting the db. But it wasn't in my court to make that decision. With the issues I am now dealing with perhaps I could make a case to split the db. However, I still will have this problem with modifications to tables and would still find a list of objects...

I have a db that was put into production because a number of users needed to start using it but there is still a lot of work I will be doing on it. I am trying to keep a list of forms, tables, etc that I update so that I can remember which ones to export to the production db. But I am afraid I...

Hi Bob, Thanks for the link. I am looking at it now. Also, thanks for the tip on how to get forms, etc from one db to another. I accidentally discovered the drag and drop method and it worked well for a while and then this locked out thing happened. I can see why the export or import...

Hi Bob, I was just doing a drag and drop from one db to the other. BTW - I found a post of yours in this forum that had a link about splitting the db but the link was broken. Do you by any chance remember it or have another one you can share? I wasn't going to split my db but you made a...

I was in the process of copying a form from one database to another (same database just in different locations). I copied one form over but the next form I tried to copy got this message: I tried closing the database but I still get this message. Other than rebooting my machine, does anybody...

Thanks vbaInet. I went that route. I added a TerritoryID field to the zipcode table and then linked it to the Territory table. I got it working just fine. Thanks for pointing me in that direction!

I have a ZipCode table: ID ZipCode City I have a form that allows the user to enter a zip code. I need to check that zip code against the table above to determine if it is Rural or Urban. I want to write an If statement something like this: If form.ZipCode is in ZipCode table Then...