AndrewKent
Well-known Member
- Joined
- Jul 26, 2006
- Messages
- 889
Hi there,
I'm very new to using Access although I have been able to use Excel to a fairly high level. For a project I am about to undertake, I was looking to combine the two.
I am writing a program within Excel/Visual Basic that completes an application form to be printed and sent out. In addition to this, all information that is captured for the application, I want captured within a database. Previously, a simple Excel spreadsheet was used however it would seem Access would be better suited to this (as my user base is 50+ with potentially thousands of records).
My questions are:
Can my program (which will be used by 50+ users, all accessing it Read Only) be linked directly to an Access database? Therefore any application they complete, the details are svaed directly to the database?
Do I need to have Access installed on ever users pc or can Excel query the database directly without it.
I would like t add Add/Amend functionality to the Excel program, so that records could be created and existing records edited.
Would it be possible with multiple users? Ie, two people access the same record.
Any help would be fantastic,
Andy
I'm very new to using Access although I have been able to use Excel to a fairly high level. For a project I am about to undertake, I was looking to combine the two.
I am writing a program within Excel/Visual Basic that completes an application form to be printed and sent out. In addition to this, all information that is captured for the application, I want captured within a database. Previously, a simple Excel spreadsheet was used however it would seem Access would be better suited to this (as my user base is 50+ with potentially thousands of records).
My questions are:
Can my program (which will be used by 50+ users, all accessing it Read Only) be linked directly to an Access database? Therefore any application they complete, the details are svaed directly to the database?
Do I need to have Access installed on ever users pc or can Excel query the database directly without it.
I would like t add Add/Amend functionality to the Excel program, so that records could be created and existing records edited.
Would it be possible with multiple users? Ie, two people access the same record.
Any help would be fantastic,
Andy