Tezcatlipoca
Registered User.
- Local time
- Today, 21:51
- Joined
- Mar 13, 2003
- Messages
- 246
Hola,
This is just - hopefully - a quick and simple question, but can anybody advise me of Access' capabilities when it comes to being connected to the web, or, even better, when linking tables to an SQL database stored on the web?
Basically, I've been asked by work to look into the possibility of writing a little call logging database for their helpline. In straight Access and VB, this is easy and well within my experience, but, and here's the sticking point, they want people in two separate offices to all be able to access it at the same time.
I'm not entirely sure what to even start writing this database in, but my thinking was setting up an online SQL database to hold the actual info, and giving both offices Access front ends that connect to this database.
If anyone can please advise me further, or can think of a better way to achieve this, I'd be extremely grateful.
This is just - hopefully - a quick and simple question, but can anybody advise me of Access' capabilities when it comes to being connected to the web, or, even better, when linking tables to an SQL database stored on the web?
Basically, I've been asked by work to look into the possibility of writing a little call logging database for their helpline. In straight Access and VB, this is easy and well within my experience, but, and here's the sticking point, they want people in two separate offices to all be able to access it at the same time.
I'm not entirely sure what to even start writing this database in, but my thinking was setting up an online SQL database to hold the actual info, and giving both offices Access front ends that connect to this database.
If anyone can please advise me further, or can think of a better way to achieve this, I'd be extremely grateful.
Last edited: