Slow Database

[shaun_za]

Hi Everyone



I created a DB with one Table and one Form that displays all the links to open the various queries based on the single table.

Is this bad practice? Many of the users are complaining that the DB is slow. Should I split the table up ? Any advice to make things run smoothly?

[ranman256]

The db only needs split it multiple users are entering/querying data.
If you are always making code changes , then it should be split.
If only a few people use it occasionaly, a Non-split db is fine, since everything (tables,queries,forms) is in 1 db, then it should be fastest.

[shaun_za]

Thank you. Thought the same.