gerrythefish
Registered User.
- Local time
- Today, 11:49
- Joined
- Oct 11, 2014
- Messages
- 28
My access 2013 database is tiny - front end 16MB, Backend 30MB and will probably grow by about 30MB per year. 140 users, some remote, but typically about 10 concurrently. 120 tables (should be well normalized)
Front end is on users Desktop, which allows me to do a lot of data manipulation on the fly (via queries) that I wouldn't dare do over a network.
Primary reason to move to SQL now is access split database doesn't work well (at all!) over VPN.
After migration (SQL 2012) linked tables open very fast. Access queries with parameters are very slow.
I know that I can move queries to Stored Procedures.
I shudder at the thought of disconnecting the data - ie read from SQL, make changes, write back to SQL in a multiuser environment, and somehow deal with conflicting updates from different users - isn't that what SQL is supposed to do! :banghead:
Users edit records in datasheet view and forms, which can have multiple linked subforms.
I need help planning on what moves to SQL stored procedures/views and what stays in access. And how to read these (vba or access queries)
Front end is on users Desktop, which allows me to do a lot of data manipulation on the fly (via queries) that I wouldn't dare do over a network.
Primary reason to move to SQL now is access split database doesn't work well (at all!) over VPN.
After migration (SQL 2012) linked tables open very fast. Access queries with parameters are very slow.
I know that I can move queries to Stored Procedures.
I shudder at the thought of disconnecting the data - ie read from SQL, make changes, write back to SQL in a multiuser environment, and somehow deal with conflicting updates from different users - isn't that what SQL is supposed to do! :banghead:
Users edit records in datasheet view and forms, which can have multiple linked subforms.
I need help planning on what moves to SQL stored procedures/views and what stays in access. And how to read these (vba or access queries)