Recent content by ak_ls

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

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.

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

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

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

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.

Yes, if it is possible.

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

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.

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.

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:

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.

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

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.

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.