Access DB to internal website

[mbatestblrock]

So I have been reading up on this, and I could sure use some advice...

I have sharepoint services 3.0 running on a server... I have a database I would like to be accessed via Web interface so my team and I can simply log on to check things in real time and edit forms in real time. Right now the access database is on my computer and nobody else has access to it.

would the actual share point server accomplish this? becuase as of right now I can log into sharepoint services website and it is under shared documents, but then I have to save or open on a local machine and then publish it back to the server. There has got to be a way to do all of this in the web interface???

I can get what ever it takes to make this happen I just dont know what it is!

Someone please help!

[NeoPa]

This is probably not the best place to be asking this as the expertise required here is web-based rather than Access based. It's also quite specific to sharepoint so that also narrows down the number of people who may be able to help.
I'm happy to move this to the HTML / CSS forum if you'd like. Otherwise feel free to leave it here but don't hold your breath.

Good luck whatever.

[mbatestblrock]

This is probably not the best place to be asking this as the expertise required here is web-based rather than Access based. It's also quite specific to sharepoint so that also narrows down the number of people who may be able to help.
I'm happy to move this to the HTML / CSS forum if you'd like. Otherwise feel free to leave it here but don't hold your breath.

Good luck whatever.

Please by all means move it somewhere would I may be able to get some help. Thank you very much!

[NeoPa]

Please by all means move it somewhere would I may be able to get some help. Thank you very much!

I can't promise how much help you'll get as it's quite a specific question but there are two things in their favour

1. There are fewer questions to get lost in
2. Their expertise is at least more to do with this side of things.

Let's see how it goes anyway.

[NateJames]

Any luck on your problem yet as I have a similar problem, and would like to know how your making out with it

Thanks
Nate

[NeoPa]

Nothing as yet Nate. We like to keep answers in the thread so anyone can find them.
However, I've asked a couple of experts to look at this thread specifically so hopefully they may know something.

[drhowarddrfine]

This question is specific to a program or technology. I'm not sure this question has anything to do with html or css because neither can do what you want. If anything, you need a programming language of your choice. Personally, I know nothing of Sitepoint.

[jhardman]

This question is specific to a program or technology. I'm not sure this question has anything to do with html or css because neither can do what you want. If anything, you need a programming language of your choice. Personally, I know nothing of Sitepoint.

I don't know anything about it either, but I do have experience connecting db's to web interfaces. There are several ways to do this depending mostly on your server. Do you know what kind of server you are using?

Jared

[mbatestblrock]

Hey guys. just a little update sorry it took nine years!

any who, I was kind of trying to find an easy way to do this, and it turns out there is no easy way, and your right in saying it doesnt really belong in an html/css thread. but Ill keep her going anyways.

as far as the server I am running, currently it is IIS 6 but could be changed to anything. It is just running in our office so it really would not matter if apache was put on it. Soooo, With that being said. I have been reading up on a bit of this, and I am no programmer but I am sooo interested in the things that can be done ASP, mysql, php etc. I am getting into it slowly but surely.

So far to accomplish a bit of what I needed (which is I have an access database and in it there is an inventory table and I wanted this to be easily accessible on our network for me and my coworkers to see, so I wanted it on the web) I wanted the entire deal on the server though. Really what I wanted was to log into the page and more or less see what I saw when I started up my access database.


Turns out they have software that will convert your access database into a php and mysql page, but I didnt like it at all!

So I duh around a bit more and ended up getting Microsoft Expression Web and Microsoft Visual Studio 2005.

Now EW and VS will accomplish this task that I did, for some reason I did it in EW because it seemed a little easier than learning VS at the time.

anyways, in EW you can connect to an access database source and tell it what queries or table you want to pull.

and that was the end to my first problem. It was very easy to do.

I do want to get into much heavier databasing though, and have this inventory database be dealt with via web interface. So well see what further adventures bring.


It is late, and I am tired but I hope this brought some help to anyone???

[NeoPa]

It seems like you've been busy and thanks for the update :)
We'll consider this one resolved then and you can post further problems as and when you find them.