Tempvars not working in runtime version

[CharlesWhiteman]

I have been able to successfully utilise Tempvars in my Db but having compiled it and packaged the solution the tempvars dont work on the production server which is a 64-Bit Server 2008 and running Access 2007 Runtime Version.

 

[boblarson]

1. What do you mean it isn't working on a production server? Who is trying to run it from the server?

2. Is this not a split database (frontend/backend) with the BACKEND on the server and the FRONTEND a COPY on EACH user's machine?

 

[CharlesWhiteman]

Hi Bob, its a split database where the front end and backend are on the same machine - just different directories.

The machine is a Server 660 R2/64 and users will access it using web terminal services.

 

[CharlesWhiteman]

The server isa remotely hosted - has to be that way in this case.

 

[CharlesWhiteman]

Having done a bit of tesging find that one of the tempvars isnt initialising...

 

[CharlesWhiteman]

Think I found the answer, one of my Tempvars is based on a textbox.value and it's value wasnt decalred until after the tempvar itself was declared.

 

[CharlesWhiteman]

problem tested and solved