Search results for query: *

Hi I need some help with an Exchange restore problem. I tried restoring Exchange Server from a back-up copy taken a few days back. I thought I had successfully done the restore until I tried mounting the Mailbox Store. Got several messages the main one being,c1041724. "An internal error has...

Thanks Guys. Had forgotten Delegation. Many thanks again.

I have recently installed SBS 2003 and have deployed Outlook 2003 to the workstations that are running XP Pro. For 2 users, within Outlook 2003 on their PC’s they have access to their Mailbox plus the other persons. I have granted permissions to the various folders so that each person can read...

I have a couple of questions about contacts in Outlook 2003. I have recently installed SBS 2003 and have deployed Outlook 2003 to workstaions that are running XP Pro. The questions are, 1) I imported the old contacts into the system created public contacts folder(via a Mailbox Contacts folder)...

Thanks for that. Am just trying CreateQueryDef to see if that will do what I want. Again many thanks

I want to create a Query using an SQL staement that can be run with VB. I am use to Oracle SQL where can you can write a SQL statement such as Create or Replace View as ... SELECT Statement. I Cannot find the equivalent within Access. Is this possible please? Thanks

Hi, dont know if anyone can help. I have had exchange server running on windows 2000 server at a clients site for about 2+ months now, with sending and receiving working OK at every hour and modem automatically disconnecting after 1 mins idle time. Over the last 3/4 weeks the modem is not...

Hi Guys I need some help.I posted this in another forum and received no replies, so thought I would try this one. I want to update Contact information in Microsoft Outlook 2002 from an Access Contact table that I have. I was originally thinking of writing code to export the relevant data to a...

Hi Guys I need some help. I want to update Contact information in Microsoft Outlook 2002 from an Access Contact table that I have. I was originally thinking of writing code to export the relevant data to a CSV file and then import into Outlook that way. I then came across the Linked table...

Has anyone had a problem with Shared FAx Service running on Windows 2000 Server with Exchange 2000 getting errors of "The Shared FAx Service failed to receive a fax" Event ID 32091 or 32034.When I look at the InBoxLog.txt, it suggests a "Reception error", which to me sounds...

Thanks. Have been been busy so havent had a good look any of these yet. But they have given some pointers. Thanks again guys.

Hi I need some help with a query. I have got 2 tables VACANCY and VACANCY_LOCATIONS linked as VACANCY.[vac:vacancy_id] to VACANCY_LOCATIONS.[vacloc:vacancy_id] There is a one to many relationship between the tables, ie for each record in VACANCY there could be multiple rows in...

Thanks Guys that worked fine. I have now found a web page that gives a comparison of Oracle SQL and Access SQL. http://www.cse.bris.ac.uk/~ccmjs/ora_sql.htm

Thanks RottPaws. If I can crack the Substr, then I can do something with the hyperlink problem, using instr and mid! The quote at the bottom of your reply reminds me of comments from Oracle Support!

Thanks Guys, will give it a try and let you know.

I know, I did find reference to it in one of the forums when searching and the syntax they describe is what I have tried but it doesnt want to work. Many thanks again.

Thanks, will try that but you are right there is SUBSTRING, which I found but I just cant get it to work in the Query. So I am assuming that I have got the Syntax wrong.

Hi I am trying to use SUBSTRING in a query but every time I try to go to the Datasheet view I get "Undefined Function 'SUBSTRING' in expression. see below as an example, select CLIENT.[cl:client_id] ,substring((CLIENT.[cl:client]),1,20) from CLIENT I am using Access 2002. Having used SQL...

I have got a main form with a subform that is set to Continuous. What I want to do is hide certain fields depeneding upon values within the current record. Therefore if viewing the Subform and there are 4 reocrds the individual rows should display different fields. I have tried several ways but...

I am having a problem with a hyperlink type field when running a Union query. I have a field defined in my CLIENT_CONTACTS Table as a Hyperlink Data Type, which is being used for Email addresses. If I run either of the unionised SELECTS individually, which has this field included, I get the...