How to Use Access via SQL Server over internet/intranet

[kensaffer]

There are over 30 users that want to access an Access 2000 Sql Server project over the company intranet as well as from their home pc's via the internet. How would they do this if they don't have Access on their home pc's ?

 

[PaulBricker]

Well I'm not 100% versed in .adp issues but in general, you will need to use some type of server-side language -PHP ASP Cold Fusion etc that gathers the info from the user and then interacts with the database. At least that's the way it happens with .mdb databases. As I say, I don't have experience specifically with .adp on an intranet but it probably isn't much different.

Paul

 

[kensaffer]

Paul, Thank you. I was hoping that perhaps I could take the forms or reports and export them as html pages. If I don't know server-side languages, then I'm really stuck.

 

[PaulBricker]

Well, although I haven't exported any of those objects as HTML, it's possible you could use those as your interface, but you would still need a server-side language to interact with the database. I've always worked in Access but when I created a couple intranet sites for the school I work for, I didn't have much trouble with ASP. The experience I had with VBA got me thru a lot of the learning curve with ASP.

Hope this helps.

Paul