Help with Access capability

[behamout]

Hello,




I have been looking around to get a simple database running on my website.
Below is a little brief for the same, Could you please advise if its possible.
Here's a little example of what i want it to do.


1. We have a access file setup with a few tables containing information like customer name, customer Login ID, city, country, business type etc.
2. Every time this same customer does business with my company, my staff go to the above access file and update the information under his user name.
3. The same customer 1 day logs into my website, enters the member area, and automatically his last 5 business transactions with him should come up on the first page.
4. There should also be a search field, say "invoice number" where he can type the number, and search for it. The search will look up the database under his user name and ID and give back the result on screen.
5. This way we have a database for many customers.


Do you think this can be done?




Thanks
Sam

[pbaldy]

I suspect nobody has answered because it feels like it's more of a web question than an Access question. You can certainly use an Access database behind a website. Your login, search and results could/would be handled by the website code (php, asp, whatever). It's all doable, I've done very rudimentary things along those lines, though I used SQL Server as the database. My experience is old and crude, so I'm likely out of date with how it could be done now. You might try a web programming forum.

There are also Access web apps, which I have not personally created yet:

https://msdn.microsoft.com/en-us/lib.../jj249372.aspx

[behamout]

Thank you for the reply Paul,

Much appreciated, i will look around a programming forum and see what i come up with.

thanks

[pbaldy]

No problem, and welcome to the site by the way! There are people here that also do web stuff, so hopefully one will chime in.