Search results

  1. A

    Hi Banana, have you got my message for evaluating RASS Estimate? Ashok

    Hi Banana, have you got my message for evaluating RASS Estimate? Ashok
    • ak_ls
    • Profile post
  2. A

    Excel Password Crack

    Hi Charles, Will it also open and break the workbook having 128 bit strong encryption? Though not sure, I think cracking protection of VB project or worksheet or the workbook is different from cracking the encrypted workbook.
  3. A

    Access 2007 - Web forms?

    Newshoes, Microsoft has given a work around for DAPs. Here is the link. Not sure if it will help you. Use Access 2007 to work with a database that contains data access pages
  4. A

    Connecting to SQL Server over internet on port 80

    Thanks Banana. It has definitely helped. I'll sort out the rest. I am in UK and it's 1:30 am here. So now it's time to have sleep. Bye
  5. A

    Connecting to SQL Server over internet on port 80

    I just checked the reference you have given. What is the implication of Network Library=DBMSSOCN. Is this library available in Win XP / Access 2003? To connect to SQL Server running on a remote computer (via an IP address) oConn.Open "Provider=sqloledb;" & _ "Network...
  6. A

    Connecting to SQL Server over internet on port 80

    The firewall and security is being taken care by the datacenter dba. I have not to worry about it. ADP application has already been tested with some SQL Serer name. Therefore, if SQL Serer name is replaced with SQL Server's public IP, the connection should be established.
  7. A

    Connecting to SQL Server over internet on port 80

    Yes, if it is possible.
  8. A

    Connecting to SQL Server over internet on port 80

    User authentication is SQL Server based only. Not sure if this info is relevant. ADP application connects to SQL Server through one login.
  9. A

    Connecting to SQL Server over internet on port 80

    Citrix and SQL Server are on the same network. Users are on different networks, in different companies, in different countries and are not allowed remote desktop to gain access to Citrix. Access ADP application has been successfully tested in Citrix through remote desktop logon only.
  10. A

    Connecting to SQL Server over internet on port 80

    Banana, The network where SQL Server 2005 is installed and the networks to which users are connected do not trust. There is a need to provide access to teams connecting through networked that do not trust each other.
  11. A

    Connecting to SQL Server over internet on port 80

    For one of my client, I have recently migrated SQL Server 2005 database to a vertual environment provided by Citrix. Access ADP application has to connect to SQL Server 2005 over the internet. Can somebody give tips how I can accomplish this. :confused:
  12. A

    Amazing what people have as pets these days

    What about humans as pet! Humans are the best pet. However, if you eat them, consequences are frightening. Otherwise, you can love and care of them as any animal.
  13. A

    aaaaaaaaaaaaaaaaaaarrrrrrrrrrrggggggggghhhhhhhhhhh h!!!!!!!!!!!!!!!!

    Now, I realise the economic down turn in USA is hitting so hard.
  14. A

    Is it possible to be a Muslem without believing in Kuran?

    Does it apply to a Moslem as well? Also laws of a State may not recognize individual's claim. For example a person being Christian by birth claims that he is a Moslem without formally converting to Moslem.
  15. A

    US Daylight Savings Time Ends 4 Nov 2007

    There are countries with large land area that do not use Daylight Savings without any problem. Why can't states of USA have fixed times throughout the year within a state? State to state times may vary if required.
  16. A

    DAO parameterized query problem

    I checked the type of qdef parameter using MsgBox qdef.Parameters("@Explanation").Type It displays 10 which is type Text. I also checked the Access help for type Text - "A field data type. Text fields can contain up to 255 characters or the number of characters specified by the Size...
  17. A

    DAO parameterized query problem

    Jal Not sure if my understanding is correct because I have not tested it myself. When a text field on a form is assigned to a qdef parameter, the type of qdef parameter is set to Text that will not allow string size of more than 255 chars. This happens because the size of the string is not...
  18. A

    Access ADP performance with 1000+ users?

    Thanks Banana, ADP is a single user client and it does not support more than one connection at a time. Therefore, in ADP/SQL Server based application design, users scalablity issue has to be addressed by ADO and SQL Server side. Do you have some tips for ADP application design considerations...
  19. A

    Access ADP performance with 1000+ users?

    Thanks SQL Hell. My question is targeted to those who have used ADP application for 1000+ users and request to share their experience and describe the environment. So far nobody has replied. It seems that nobody has deployed the ADP / SQL Server for 1000+ users. I, myself has no such...
  20. A

    Access ADP performance with 1000+ users?

    Can anybody share experience of using Access ADP application with 1000+ users? tried this question in general section and there was no reply. Is it that ADP applications are not targeted for large number of users?
Top Bottom