I've never posted a question with a high priority before but I have a meeting with the client tomorrow and would like to be prepared. The client only informed me of their final decision 1 hour ago.
I posted a question on this topic back in December. Please review the question for background.
Prior Question on this topic
The short story is that my client wants to have all users on a multi user network, use the exact same copy of the application accde. The client says they have an existing Access application already running in this mode, so apparently it can be done.
I have been developing in Access since Access 2003 and this goes against everything I have ever been told and the information given by EE'ers in the prior post. I sent the post to the client so they are aware. I'm having difficulty even wrapping my head around multiple users in the same accde using the same form at the same time but working with different data.
My application is being created in MS Access 2013 and the back end DB is SQL Server. A lot of development has already gone into this application prior to the client making this requirement known.
Among other things my application uses linked SQL tables, linked SQL view, forms bound to the linked SQL table, forms bound to local Access tables, MS Access queries, local access tables, global variables and calls many stored procedures. Let me know if there is any other pertinent information about the application that I need to supply.
I would like to have a systematic approach to undoing what is done to comply with the client request.
Given that I have to conform to this environment my question becomes. "What do I have to remove/revise in my application to accomodate the environment?"
I've tried thinking this thru and came up with some obvious changes that need to be made. I'm hoping other EE'ers have written to operate in this environment and can offer insight. Something along the lines of "To create an Access application to operate in this environment you can't use......" would be perfect but probably not going to happen.
I know I have to replace any local access tables.
I know I have to replace all global variables.
I have forms bound to the back end SQL table. Currently I am using tables linked to SQL as the data source for many forms. Will I have to make all of these forms unbound? Even if I make them unbound I don't understand how two users in the same accde could be using the same form at the same time but entering different data or revising different records.
Do I have to replace my local Access queries?
Can I still use SQL linked tables and views?
What else needs to be done?