My IT department finally agreed to let me have SQL Server 2012 to work on the back end. I will continue to keep Access as the front end because of its ease in creating reports and forms. I have a few questions if any of you could help:
1. Right now I distributed the front ends to my team mates and put the back end on the company's server, but Access is extremely slow. By putting the back end into a SQL Server, would I gain performance speed?
2. Would I still have the same limitations of Access or would I have more features that belong to SQL Servers (larger file size, more numbers of data items in a query, more statistical functions,...)?
3. Over time, would I be better off learning another front end to create queries, forms and reports or should I continue to stick with Access (I am no programmer)?
Thanks in advance for your advice!
Tim
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar