Search results

That's a very good point, which I will use!

No Pat, we are a very small company and our wired network has no free ports on the switch! I might have to get my boss to pay for that to change! :-)

Yes David, thank you, I will do that as well to see if we can minimise wireless activity.

Sounds like getting the wireless network out of the equation might the best thing to do in the short term. Realistically, I can't see my boss wanting me to migrate the BE to SQL server anytime soon. All this said, we have not experienced any issues other than this performance issue with the...

How easy is it to change the BE to SQL server?

Ah I see. No the links are set-up in the front end database as a fixture. The only time that they get changed is when I do a new release of the front end database AND there are some back end database changes at the same time. Such as a new table, or new columns in a table etc. Otherwise, the...

Many thanks Dave - what do you mean by "reconnect"? I've gone for the hidden form option as it seems easiest to be honest. Thanks again, Simon

About 3 months ago I split our company's main access 2010 database as follows: - gpm_BE.accdb - on server (windows 8 PC not used by anyone, it acts as a file server) - backend database is about 50Mb in size containing just tables. - gpm_FE.accdb - on user PCs mixture of Windows XP, Windows 7...

... that moment when you spend about 10 minutes writing a post asking for help with a VBA procedure only to spot the error yourself just as you are about to click 'Submit New Thread'

Hi there, I have worked with computers since the mid-70s and have until the late 80s I did a lot of programming initially on mid-range IBM computers. Since then I've notformally been in a job my prime responsibility has been to write code - but somehow I have always found myself 'hacking'...