I hired a freelance to create an access database with forms. The work is actually still in progress. The database is basically a trimmed / hacked down version of the Microsoft Desktop Project Management Template. It allows a person to create a project, assign tasks and print / view graphs. Employee performance is what is being tracked. Employees log in and enter the number of items they have produced. Each employee has their own login and can only see / enter information for tasks assigned to them.
My fear is that this is not going to work well in a multiuser environment. There will be 2 to 4 computers where employees can login and enter production numbers at various times during the day. Most will probably enter them at lunch and end of day. I'm thinking I will need to allow multiple logins.
Can this access database with forms be converted to SQL to allow this ? We have the SQL Server.