Dallas, TX area - Non-Profit Legal Service Provider, seeking local assistance only.
We utilize an Access Database built prior to 2000. The current version of our database runs safely in 2003 access. We upgraded our Server to MS Server 2013 running in 64 bit. We attempted to just run the database in the new environment and learned that it broke most of the reporting modules. Why we are looking to migrate is to improve client search times. It appears that when performing a search, the search is indexing the entire database before reporting any information. It is not a feature that was present in the previous version of our server and database.
Also, need a special report query, that will utilize several tables, that all use different UID's to request open cases based on the Birth month, vs. specific birth date on a client ID.
Due to confidentiality and the Attorney/ Client privilege we are looking for onsite assistance.