Search results

Hi I'm running SQL server 2008 and am trying to use ODBC connections with SQL Server authentication. I can only get Windows authentication to work however, which is unsuitable for my application. I've used the 'This account' section in the Log On tab of SQL Server Browser and the SQL Server...

Hi I've recently started using SSIS packages in 2008 as we have had to upgrade from SQL 2000 where I implemented several DTS packages. I have created a simple SSIS package that simply copies one table from one sql server to another. This package runs fine until I save it, then I just cannot...

Hi We have an online form for customers to fill out - this data is then placed into an mdb on the same web server. What I want to do is query this database from our intranet, but to do this I need to create a connection to the remote database, which is where I am hitting trouble. When...

Hi When I filter on a form on our database, I cannot then remove this filter. In order to continue working i have to exit the database completely! Please help!

Hi all I'm about to start on a new project - automatically compacting and repairing our databases every evening. I am confident that I can do this (just!), my only issue is deleting the lockfile in case any users have forgotten to log off the databases before they have left. Obviously I will...

Hi I've got a button on a form that opens another form - nothing unusual, but it would be preferable if this second form was password protected i.e. the user clicks the button to open the form and is immediately prompted to enter a password. I've looked at user-level security wizards but that...

Hi I'm recently added the CalendarControl 9.0 into some combo boxes in order to quickly input dates - however only the dates are then added, not the day of the week. The day of the week would be really useful if it was visible as the form is outputted to a HTML page for our intranet for other...

Hi I'm recently added the CalendarControl 9.0 into some combo boxes in order to quickly input dates - however only the dates are then added, not the day of the week. The day of the week would be really useful if it was visible as the form is outputted to a HTML page for our intranet for other...