it changes to:
mouse 4 19
monitor 10 14
speakers 7 27
keyboard 12 17
Values in those records are still okay!
Sometimes it even deletes complete detail records!!
I emphasize that data entry procedure is on more than 9 computers simultaneously, .MDB is on one computer in another room, there is no table with more than 10000 of records yet. Combo box is used with query inside.
Would MSSQL accept all tables (now linked from MS Access frontend to MSSQL backend), queries (as they were) and forms (I did not make any exotic things, I just have combos, tabs ....) from MS Access directly? I do not have any modules, macros .... No exhibitions ....
There might be some complications with the tables and queries (mainly queries) when you upsize. I don't remember off-hand what the suggestions are, but you can probably find all you need to know at MSDN's site.
You should also look in Access help under "Upsizing"
Last edited by Bbender27; 07-28-04 at 17:42.
Reason: to add the blurb about the help file