Database Running Slow While Developing

[comptechbranden]

Hello All,

I created a database for about ten users here at the office. My database development file of the database is tied to the same back end that the users actual front end file is tied to. When I develop in my file I just copy it to the users so they get working updates and the whole process seems to work great except as the database got more intense and we introduced more users the front end is running fine for them but when I go in design mode to make changes in my separate front end it runs way slow for me.

Any ideas? Is there a way I can stop temporarily stop my design file from accessing the back end when I am developing and easily re-enable it or something? I do like to use my data as test data while developing...

Thanks for any ideas!

 

[DCrake]

here is a link to a sample database that may be of use to you.

 

[comptechbranden]

So how do I import this into my database and make it work for me so that it manages if I want to be connected to live data or not?

 

[DCrake]

As an alternative copy the back enddatabase to your local machine. Then when youopen it up or develpment work use the link table manager to toggle between local and server data. when finished swap back to server tables.

 

[comptechbranden]

It looks like I will need to import the module and form into my database, update the module to include the names of my tables and links the the back ends and then I can use this form with the logins to switch back and forth. Is that exactly what I need to do or am I off base here?

 

[DCrake]

Yes this is what you ned to do

 

[comptechbranden]

Awesome! I will give it a try here. I visited your website and found some other good examples there. I appreciate your help and glad you responded! I hate little database show stoppers and I have had a couple lately.

I am working on subforms within subforms right now and trying to figure it out. I cant get data working on the second subform hitting to the subform on the main form. I think I have a small design issue that keeps me from doing it easier ultimately...I can do another thread for that when I get fed up with it, lol.

 

[DCrake]

Thanks for visiting my website and hope you found it useful. Don't be afraid of providing feedback on any of the samples you came across of the help you receive.

 

[comptechbranden]

I imported the module and updated it. I also imported the form. I go to login with the form and ive got it to the point that it runs all the way down to giving me an error saying I dont have the correct password. It says the following when I use my login info or Training info. Any ideas?

Runtime error 3031 (not the correct password) at line;
tdf.RefreshLink ' Relink the table.

 

[comptechbranden]

I ended up just copying my back end and using the linked table manager to switch back and forth from the back end that everyone's using and the back end only I use to develop with. It increased speed and now I am able to develop at a normal speed again with the lag in between every change.

Not to mention I can make any changes to the fake back end without screwing up valid data.