Access on the Intranet

[evilbungle]

Good Morning,

I am trying to set up an interface to my Access 2003 database, It is a database for booking jobs for field staff to complete, it is split between client and server.
Basically we now need people from another office to be able to raise a job that we can give out but both sites are on different servers so there is no shared area.

I have tried to create a Data Access Page but I keep getting an error message.

The other issue is that I have some code behind the form in the database which records User Name and date raised etc.. and I need a lot of the fields to be combo boxes neither of which I can get to work with a data access page.

Is there a way of doing this with just HTML or Javascript or do I need to do it through a data access page?

Sorry if I havn't been clear if you need clarification please let me know, many thanks for your help.

Ed

Edit: forgot to say the Error I get is "Expression Service could not be loaded"

[Delerna]

I have found that internet explorer version 7 has a problem with data access pages where I work.
Cant remember the error that I was getting, but .........

We had to go back to IE6

[evilbungle]

I have found that internet explorer version 7 has a problem with data access pages where I work.
Cant remember the error that I was getting, but .........

We had to go back to IE6

Unfortunatly this isn't the issue as we are on IE6

[Delerna]

By the way, yes you can do this with html and java script and/or vb script

Also, what are the errors you are getting, we use data access pages extensively on our intranet and have no problems with them. Once we erradicate the errors that is.

All with combo boxes etc.

[eugenvlad]

Hi,

We recently set up an Access Database and we are using Data Access Pages to connect to it over intranet.

It works on almost all computers but one. On this one we get the same error like you: "expression service could not be loaded"

All computers use IE7 with same settings and OWC 10 or 11 depending on the Office version installed on each one.

Have you figured out what caused the problem?

We are also opening some queries from this access database in Excel. The problematic computer is not able to open the queries (crashes) - so I was thinking that it has to do with the MS office installation, but we couln't find out anything till now.

Please let me know if you have any ideas.

Thank you.

Good Morning,

I am trying to set up an interface to my Access 2003 database, It is a database for booking jobs for field staff to complete, it is split between client and server.
Basically we now need people from another office to be able to raise a job that we can give out but both sites are on different servers so there is no shared area.

I have tried to create a Data Access Page but I keep getting an error message.

The other issue is that I have some code behind the form in the database which records User Name and date raised etc.. and I need a lot of the fields to be combo boxes neither of which I can get to work with a data access page.

Is there a way of doing this with just HTML or Javascript or do I need to do it through a data access page?

Sorry if I havn't been clear if you need clarification please let me know, many thanks for your help.

Ed

Edit: forgot to say the Error I get is "Expression Service could not be loaded"