Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Andydr

  1. Andydr

    NEED HELP - Problem with Exchange after restoring Exchange Store

    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...
  2. Andydr

    Mailbox question

    Thanks Guys. Had forgotten Delegation. Many thanks again.
  3. Andydr

    Mailbox question

    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...
  4. Andydr

    SBS 2003/Outlook 2003 Contacts

    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)...
  5. Andydr

    Create a Query programmatically

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

    Create a Query programmatically

    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
  7. Andydr

    Windows 2000 Server/Exchange Server-Modem not always auto disconnectin

    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...
  8. Andydr

    Access 2002 and Outlook 2002 synchronisation

    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...
  9. Andydr

    Updating Linked Table to Microsoft Outlook Contacts - Permission error

    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...
  10. Andydr

    Shared FAx Service

    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...
  11. Andydr

    Select multiple rows into a single string for a Query

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

    Select multiple rows into a single string for a Query

    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...
  13. Andydr

    Substring Function - error Undefined Function

    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
  14. Andydr

    Problem with format of Hyperlink field in an Union Query

    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!
  15. Andydr

    Substring Function - error Undefined Function

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

Part and Inventory Search

Back
Top