Probably a dumb question....

[Guest]

I have a secure split database ready to go - the backend and workgroup to be
installed on the clients file server and the front end on the individuals
PC's. I know each front end will need Access installed to work but does
Access need to be installed on the server too?? I just cant seem to find
out!!!!

Thank you

Paula

 

[TC]

No, you do not need Access on the server.

But if you have to ask, it sounds like you have not done any testing
yet. Networked apps have different issues to "single PC" apps,
particulatly with response times. You'd be very unwise to release it
for production use, unless you've done some testing (in the networked
environment) first. Particularly since it sounds like this is the first
networked app that you have done!

HTH,
TC

 

[Guest]

it is my first app hence the sily question! I have built it on my home pc and
am loading it into the office for testing. I just wanted to make sure that
when i arrived to do it that i had checked this out first!

Thanks for your help

Paula

 

[TC]

It wasn't a silly question

Give it a try & tell us how it turns out.

TC

 

[Guest]

Hi TC

I have a wee problem. Everythng is working fine apart from one of my
reports. Its a report based on a parameter query with a combo box on a form
for selection. The query is not working. The error message is "Function is
not available in expressions in query expression" . This worked fine on my
pc at home. Any ideas??

Thanks

Paula

 

[TC]

It sounds like it is mostly working - well done

Show us the SQL of the query.

TC

 

[Guest]

Since my last post I managed to grab the IT man while he was floating around
the office to give me a hand! I installed the front end on 4 different pc's
and the 3 of the pc's the report didnt work on apart from one of the pc's it
all worked beautifully! So he checked the network permissions for everyone
and they were all ok so he left the office equally baffled as me! All the
pc's have Windows XP and all the Access is 2003. It cant be the query because
it worked on one of the pc's and everything else is functioning as it should
apart from this report. Any ideas?

Thanks for your help

Paula

 

[TC]

Show us the SQL of the query.

TC

 

[Guest]

Here you go ...

SELECT DISTINCT [Broker Details].Number, [Broker Details].Lastname, [Broker
Details].[First Name], [DIP'S].[Dip Number], [DIP'S].DateofDIP,
[DIP'S].[Client Name], [DIP'S].PropertyValue, [DIP'S].Loan, [DIP'S].Lender,
[DIP'S].Scheme, [DIP'S].Rate, [DIP'S].[Tie In], [DIP'S].[Arrangement Fee],
[DIP'S].Valuefeeselect, [DIP'S].Result, [DIP'S].[Procuration Fee]
FROM [Broker Details] INNER JOIN [DIP'S] ON [Broker Details].Number =
[DIP'S].Broker
GROUP BY [Broker Details].Number, [Broker Details].Lastname, [Broker
Details].[First Name], [DIP'S].[Dip Number], [DIP'S].DateofDIP,
[DIP'S].[Client Name], [DIP'S].PropertyValue, [DIP'S].Loan, [DIP'S].Lender,
[DIP'S].Scheme, [DIP'S].Rate, [DIP'S].[Tie In], [DIP'S].[Arrangement Fee],
[DIP'S].Valuefeeselect, [DIP'S].Result, [DIP'S].[Procuration Fee]
HAVING ((([Broker Details].Lastname)=[Forms]![Selectbrokerpopup]![Combo12])
AND (([DIP'S].DateofDIP) Between Date() And DateAdd("m",-3,Date())))
ORDER BY [Broker Details].Lastname, [DIP'S].DateofDIP;


Thank you

Paula

 

[TC]

Since you said the error was: "Function is not available in expressions
in query expression", I thought you might be using a function that was
ok when used from your PC, but not when used from the other PCs. But
the only functions that I can see, are Date(), and DateAdd(). Those
seem fairly innocuous.

Whether this fixes it or not, I suggest that you enbracket /all/ of the
field names, since some of them are Access reserved words; eg. [Broker
Details].Number - change to [Broker Details].[Number].

If it still fails on some PCs, replace the forms reference:
[Forms]![Selectbrokerpopup]![Combo12] with a constant (eg. "Smith").
If that fixes it, then clearly it is something to do with the form
reference.

HTH,
TC

 

[Guest]

Hi TC

Thank you for your time and for replying to me again and again and again and
again!!!!!

I have done as you suggested and enbracketed(not sure if that is a word!)
all of the field names. Obviously I wont be able to test this until I am able
to go to the office again which at the moment involves trapsing three
children along too! I may have to wait until term starts again.

My lack of experience kicks in here as I am not really sure what you meant
by replacing the forms reference with a constant???

You have been so helpful already I dont want to be annoying but if you have
time would you be able to explain that bit for me please?

Thanks a million

Paula

 

[TC]

Paula, the people who are fun to work with, are those like you, who
follow our suggestions, answer the questions that we ask, and generally
keep at it until they solve their problem. The ones who /aren't/ fun
are the ones who /don't/ follow suggestions, don't answer questions, &
then just disappear half-way through the process, so we don't know
whether we helped them solve their problem or not!

So you are fine to ask as many more questions as you want, as far as I
am concerned.

When I suggested to try changiung the forms refernce to a constant, I
meant to try changing this part:

HAVING ((([Broker
Details].Lastname)=[Forms]![Selectbrokerpopup]![Combo12])

to this (for example):

HAVING ((([Broker Details].Lastname)="Smith")

You might think, "What's the point of that? I can't change my query
every time I want to use a different surname! I want to select the
surname from the combo box on the form, like I had it originally!"

The answer is, this is a "divide & conquor" technique which is often
very useful when debugging, if you don't know where a problem is. Say
you make the change described above. If the problem still happens, you
haven't gained anything. But if the problem /stops/ hapenning, you now
know that it is something to do with referring to the value in the
combo box. This gives you an excellent further lead to work on. In
/either/ case, you change the code right back to what it was before.
The change was only to see if the problem might be something to do with
the form reference. As soon a you know that, one way or the other, you
change the code right back again.

HTH,
TC

 

[Guest]

Thanks TC

I understand what you meant now! I will definately give it a try. It will
probably be a few days before I am able to get into the office but I will
definately let you know how I get on.

In the meantime have a very Happy New Year.

Thanks for all your help.

Paula

 

[Guest]

Hi TC

I managed to get into the office today for more testing. They needed the
logos changed on the reports so i brought them in a new frontend. I added the
brackets to the query as you suggested but no joy. The combo box that
generates the report is working fine as they have been inputting the data but
only when you press the "ok" button on the form to generate the report does
the error occur.

It is still only working on one of the pc's even with the new frontend
loaded today.

Any more ideas for me to try out please????

You're a star

Paula

 

[TC]

Sure. On the PC that has the error, replace the combo box refrenc (in
the query), with a fixed constant string. I explain how to do that,
before. If this /fixes/ the probem, we know that it's omething to do
wih the combo box. If it /doesn't/, we know that it's not, & wiull have
to thunk of something else. Either way, you only make that change
temporarily, to see if it fixes the problem or not. Review what I sai
before, it is all laid out in there.

Cheers,
TC

 

[Guest]

Hi TC

Just spent a quiet Sunday morning in the office all by myself ready to try
out your suggestions. I had a few changes to make to the layout of the
reports and made new mde files for everyone. This believe it or not also
managed to fix my other report problem so now everyone is able to access
it!!! I dont know whether this is because i made the mde files in there
instead of loading them from a cd - its a mystery!!

Thank you very much for all your help and patience - thankfully everything
is working perfectly now(for the moment!!!).

I may be back.............

Thanks again

Paula
x

 

[TC]

Ok, well done!

Remember that when you copy a file back from a CD to your hard disk,
Windows will set the file to Read Only. You need to go into the right
click properties of the file & remove that setting. No idea if this is
anything to do with what we discussed before, I haven't gone back to
re-read it. Just thought I would mention this, in case you did not
know.

Cheers,
TC [MVP Access]

 

[TC]

Hi Paula

I replied to this a few hours ago, but I post through google, and
google seems to be losing most of my posts at the moment! So lets's try
again.

Glad you got the problem sorted. Just one thing about "loading files
from a cd" - you do know that when you copy a file from a cd to your
har disk, Windows makes the file read-only? You need to go to the right
click properties of the file, and un-set that attribute. I'm not sure
if this is relevant to what we discussed in this thread - I have not
gone back to re-read it - but I thought that I would mention this, just
iun case you did not know.

Cheers,
TC [MVP Access]

 

[Guest]

Hi TC

Yes i was fully aware of that thanks. But thanks for the suggestion - its
one of those simple things that you forget until you get used to the cryptic
Access error messages!!!

Thanks again for all your help.

Paula
x