ms access in midlands
Author
Discussion

cheeky_chops

Original Poster:

1,632 posts

278 months

Friday 19th March 2010
quotequote all
looking to win some work and the legalities mean a hosted web app is no go - hence next step is offer MS access. Which i dont have time to learn indepth

initial reqs are multiple logins with minimum 2 levels of security, users assigned customers, some screen to capture financial sales and customer questionaire info, dropdowns with lookups, pdf reporting by user/customer/questionaire/month/ytd

Thoughts?

cazzer

8,883 posts

275 months

Friday 19th March 2010
quotequote all
You askin for someone to quote you on it?

cheeky_chops

Original Poster:

1,632 posts

278 months

Saturday 20th March 2010
quotequote all
looking to chat to sombody who could do it, thats why i put a little bit of info up

lestag

4,614 posts

303 months

Monday 22nd March 2010
quotequote all
I'd be building it in MS Access interfacing to a SQL Server Express Database http://www.microsoft.com/express/database/ rather than access tables ( a MDB) you can run it on a XP or higher PC to act as a server

I don't program, but I had the (mis)fortune of being responsible for a bunch of access DBs them...... and got my analysts to code them for SQL to gain reliability

cheeky_chops

Original Poster:

1,632 posts

278 months

Tuesday 23rd March 2010
quotequote all
sql server is my bread and butter so no prob there...

Just found out the issues -
Basically a questionaire for sales
no data to be held externlly (their IT rules) so no web pages/db
sites thru the UK, no linked network/shared drives
THe PC's are locked down so dubious if they have traditional desktop, probably citrix.
Takes 3 months to get IT to look at any new projects
They want it by May

Hmmm....

lestag

4,614 posts

303 months

Tuesday 23rd March 2010
quotequote all
cheeky_chops said:
sql server is my bread and butter so no prob there...

Just found out the issues -
Basically a questionaire for sales
no data to be held externlly (their IT rules) so no web pages/db
sites thru the UK, no linked network/shared drives
THe PC's are locked down so dubious if they have traditional desktop, probably citrix.
Takes 3 months to get IT to look at any new projects
They want it by May

Hmmm....
then why not host website intenally?

amir_j

3,579 posts

228 months

Wednesday 24th March 2010
quotequote all
cheeky_chops said:
sql server is my bread and butter so no prob there...

Just found out the issues -
Basically a questionaire for sales
no data to be held externlly (their IT rules) so no web pages/db
sites thru the UK, no linked network/shared drives
THe PC's are locked down so dubious if they have traditional desktop, probably citrix.
Takes 3 months to get IT to look at any new projects
They want it by May

Hmmm....
Tried to email you but you have set it to off- drop me a pm.

cheeky_chops

Original Poster:

1,632 posts

278 months

Wednesday 24th March 2010
quotequote all
lestag said:
cheeky_chops said:
sql server is my bread and butter so no prob there...

Just found out the issues -
Basically a questionaire for sales
no data to be held externlly (their IT rules) so no web pages/db
sites thru the UK, no linked network/shared drives
THe PC's are locked down so dubious if they have traditional desktop, probably citrix.
Takes 3 months to get IT to look at any new projects
They want it by May

Hmmm....
then why not host website intenally?
because it takes 3 months to get their IT (based in France)to do anything except break/fix - otherwise their IT would do this project. I doubt we can drop a virtual iis server in or host on their desktop(data loss risk aside...)

Amir - will PM you.