Build a database £££

[smstothrs]

Would anyone be able to fix or build me a database. and how much would it cost me ??

 

[Mark_]

Some where between nothing and the total economy of Europe... Depends on WHAT you are asking for. Your question is very vague. Similar to asking "I want something that can float, how much would it cost me???". Would need a lot more details.

 

[smstothrs]

apologies,

at the minute we are using the services template ms access provide and it works a treat my issue is i want this to be split for multi users.

can this be done ?

 

[Lightwave]

Yes it can be done.

Split the database
https://www.youtube.com/watch?v=u2IFTHgZQzg

Put the back end with the data on a SAN somewhere

Place copies of the front end on each local computer and then link to the the file on the SAN server with the database back end and link the tables.

 

[jdraw]

smstothrs,

Just curious--What is your role regarding the current and proposed database?

 

[smstothrs]

@jdraw i am not sure what you mean do you mean my role within the company

 

[smstothrs]

i have got this far but the macros from the template do not work once it is split

 

[jdraw]

I meant with respect to the database.
Are you the?
-business manager who needs some sort of automation to do some job "better"
- "proponent" (identified the need and has resources to oversee this project
-analyst
-developer
-dba


What is the business involved in simple English -no jargon?

 

[smstothrs]

i am the company director so i want to view everything that happens

i want other users to create quotes but not see the invoice's or yearly sales i also want to password protect each user so no one can log in as other users (does this make scene? ) sorry i am not very good with the access terminology

we are a mechanical and electrical company that also deals with facility management so as a job is raised i have been getting the guys to create a new quote/case and hitting submit on completion allowing accounts department to invoice it

 

[jdraw]

So, this proposed database will interface with the accounting/invoicing system you currently have?
As "company director" do you intend to build this yourself, based on your

i have got this far but the macros from the template do not work once it is split .

If this is a critical part of your business, you might want to review software compatibility.

 

[smstothrs]

sort of it generates the invoice for us. i have attached a template to give you an insight what i mean. but once i split it and link the tables the macros stop working

 

[jdraw]

I am not familiar with the template. There certainly are many objects within the template. I do note that it does not have any tables and relationships in the relationship window?? I'm not sure how you would adapt such a template to your business without knowing more about the structure.

There may be someone with knowledge of that template either on this forum or another. You might try google and see if you can find anyone familiar with the template.

You might find a local Access/database person who could offer direct support??

Good luck.