Hi,
I used the database splitter today, but it has made using the database unbearably slow - a form that was already slow to open (4-5 seconds) takes more like 30 seconds on the machines that will be using the DB. So, I changed it back. Will the problem here be the cross-tab queries, lookups or something else entirely?
Also I tried the original db (unsplit) on two adjacent machines - one with Access 2003, and the other...
Jason Keys
Last Activity: Dec 6 '06, 11:33 AM
Joined: Sep 27 '06
Location:
-
Split Database too slow
-
Would having all these lookup tables slow down the opening of forms that have data referencing them? I have some forms that have 5 or 6 sub forms including some crosstab queries so anything that I can do to speed up opening these forms would help (the standard on the machines that will be using this database takes 4 or 5 seconds to open even though cycling through records is almost intantaneous). -
Hi PEB,
I started with a single table that had all the lookup values in it and referenced them appropriately in the combo boxes in the table design. I found this fine if data is entered into the database or forms, but when I imported data through excel (transferspread sheet) data went into the tables like I had done nothing.
What I have done since is set up a whole heap of lookup tables that have a one to many relationship...Leave a comment:
-
Change RecordSource for forms
Hi,
I have a number of tables with the same structure they are all lookup tables. I went this way because I couldn't stop invalid data from being loaded (data is imported via transferspreads heet). Even though I have set up validation in the spreadsheet, I wanted to make sure that if that gets beaten, that the database validation will stop the invalid data.
Could someone tell me the best way to do this using the single...
No activity results to display
Leave a comment: