Search results

The database is not split. I seen this on other MS-Databases here. It seems the "magically" appear from the creation of drop-downs on the datasheet for a table. This one database is Very Slow on doing queries. Although, there are only 16 thousand records. I have dumped the two primary tables...

These "extra" tables I guess are created by all those relationships people have created for "drop down" lists etc. I need better system performance, it is sooo bad now a query to pull 1700 records from a table of 16000 records takes 5 minutes then to jump to the bottom of the output of the...

I work at a place with a couple dozen MS-Access DBs. Many are Very Slow to work with. And a some have "extra" tables when I view the table relationships. What are those all about? Here is a snapshot of the relationships. http://www.box.net/shared/szmsd18omu Thanks for insights Russ...

Re: limiting a look-up column current row data - datasheet view Would this be possible in datasheet view? Thanks Russ

Thanks for the pointer a "combo box" i need. Russ

I have a table where I want a selection of dates from another table to be in a drop down box. I am not sure how to do it. It is a simple db at this time. table1 = activitytable with fields: personname, trainingname, dateoftraining table2 = trainingdates with fields: trainingname, trainingdate...