Search results

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:

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?

or Christian without believing in Bible! There are many more religions that have religious books as their base and same thing may apply to them.

Can somebody share experience of using Access ADP application with 1000+ users?

I have not been able to identify which marketing models are most cost effective for UK based small business engaged in developing small software solutions for UK clients? I know what will work in India or Saudi Arabia but I am still clueless what marketing model will work in UK and USA without...

I have no idea how to approach the following requirement. I have few Access ADP projects where Execl and JPG files are to be read and written to a sharefolder using a Windows username and password i.e. not current login user/password. The requirement is the there will be only one user account...

Using VBA, I am creating a PowerPoint Presentation (PPT) from Excel Workbooks. The created PPT's master slide has a ComboBox. This ComboBox is to be used for jumping to a slide selected in ComboBox. Therefore, the ComboBox is to be populated with slide numbers and titles before the PPT is...

I have few applications in MS Excel using VBA. These applications simulate Hierarchical Views of the data with following characteristics. 1) Indented values in a Column simulating a tree view of rows 2) Group level rows have formulas to sum or other calculations 3) Inrease or decrease to...

In Access ADP project, I am trying to copy an Excel Chart to a JPG file using the VBA code. This code runs for first time after opening the Access project but gives error if rerun. The error occurs at the following line in Sub CreateJPG. ActiveChart.ChartArea.Select The error number is o...

I have to migrate DAO queries to ADO. I am having prolem in finding the equivalent of the following which is frequently used in WHERE clause. Select ..... From table1 left inner join table2 on table1.colum1x = table2.column2x and ... Where ((table1.colum1x <> table2.column2x) is Null) or...

I am currently using Access 2003 ADP and SQL server 2005 Express. In this conbination, I can not make changes to SQL Server 2005 objects such tables, views, procedures etc from within Access 2003 ADP. I am forced to used SQL Server 2005 Express Management Studio. However, I can not set Access's...

I have an Access 2003 APD project that currently runs on SQL Server 2005 Express with no other named instance on the same computer. Now, I have to migrate this project to SQL 2005 vertual server. Can somebody tell me with the possible issues and resolutions if the vertual server is a named...

My Access adp application generates vba scripts (reading Excel worksheet and updating SQL server tables) and adds the generated scripts to a Module. The procedure names are stored in a table. I need to call these procedures on demand. :) I could easily do this in Visual Foxpro using foxpro's...

The following VBA code that connects to SQL Server in an Access adp project works without any problem on my computer but does not work on another user's computer. CurrentProject.CloseConnection ConStr = "Provider=sqloledb;Data Source=UK009125D\SQLExpress;Integrated Security=SSPI;Initial...