Microsoft Access Help!

simon4amiee

Afternoon all, I dont know if i am in the right area so apologies, I am starting a new job next weeks as an Analyst for the NHS, and I asked then to send me some infomation because Ive been off work through redundancy for 6 months and am bored out my brains. The information I understood, but I suspect something can be done about the following statement, I suspect advanced access users would understand this, but I may be barking up the wrong tree!

"Occasionally due to network problems Infocom is unavailable. This means the IPCNs are unable to follow up new admissions and all additions/discharges to the team workload must be done manually.

Unfortunately because of the workload a manual system is unsustainable and also leads to repetition and inefficiency and is highly detrimental to the information quality.


Possible solutions:

Even with data type conversions at the moment our data table is over twice the recommended size for a shared access database. We also have over the recommended users for a multi user database, this seriously limits efficiency and can effect our connection to Infocom.

Move the store to a specialised server and change the Infection Prevention and Control data store from Microsoft Access to a more appropriate format"

More4me

look up the appropriate forum and post your query
http://groups.google.co.uk/groups/dir?hl=en&sel=usenet%3Dmicrosoft.public.access

bookduck

Not sure of your question, but I read it as they are migrating for ms access to probably MS SQL server