Search results for query: *

Hi Folks, We're planning on migrating Active Directory from 2000 to 2003 - are there any known issues or problems that we should be aware of? Thanks for any help. Later, Jes

Hi Folks, Apologies if this is the wrong forum, but I think it relates to the import through DTS. I've imported a set of tables from an access database and set up all permission to edit, etc, yet when I link to these tables through access, I'm unable to edit the contents of the tables...

Hi Folks, I think the question sums up what I need to do. I've got my back-end tables in an SQL Server 2000 database and a front-end which links via ODBC. It works fine on my machine because I've set up the ODBC connection. However, I want to distribute the front-end to my users so they can...

Hi Folks, I'm linking to an oracle database through ODBC and want to update the table. I'm getting the message 'Query must use updateable recordset' when I run an update query on it. I think - and am fairly positive - that the cause is that looking at the index definition on the oracle side...

Hi Folks, Ok, I'll word it correctly this time. I've got an SQL-2000 database with stored procedures inside. I want to call thses from an Access 2000 database using pass through queries. Where there are no parameters, or where the parameters are discreet values, a 'docmd.openquery...

Hi Folks, Can anyone give me an example of how to use the values of a control on a form as a parameter in an SQL pass-through query? I'm using access 2k and SQL-2000. Thanks, Jes

Hi Folks, I'm trying to use the AppActivate command and it's coming back with Error 5 with any app that I try except 'Application.Name'. I'm working under Citrix and wonder if that's what is causing the problems. Can anyone shed any light on this for me. Thanks. Jes

Hi folks, I'n using Access XP and Excel XP in a citrix environment. I'm using automation to open a template in excel and then outputting the results of a query to that spreadsheet. The first time I run it, everything is fine. However, the next time, and everytime thereafter, the excel window...

Hi Folks, I've recently been experiencing a strange problem with an access 2000 app I've written. Everything will be working fine then someone else will try to start the app and be told it's corrupt, not recognised, all sorts of weird stuff. The only way to resolve it is for everyone else to...

Hi Folks, I'm trying to add a yes/no field to a table in Access 2k using an SQL script. No problem in terms of actually putting the field on but I cannot find a way of changing the control format to yes/no, other than going into the table details - it defaults to text box. This is obviously a...

Hi Folks, I'm running a multi-user database(Access 2000) in a citrix environment. The database is split into back- and front-end pieces with the front end running as a .mde. This mde is called via hyperlink from another access mde - this is because we needed a way to launch the application as...

Hi Folks, Probably a dead easy one for you top bods, but how do you import a table with an autonumber field and keep it's status as such, ie, transforming it to an Ident field? Thanks, Jes

Hi Folks, When trying to print a report ALL fields are filled with #######s...anyone got any idea why? It's an access database pulling information from an oracle database. One report, prints out just fine, while another has the above - it's the same information being pulled for both reports...

Hi Folks, Is there any way to get Windows Explorer to display using dumb terminals under citrix? I'm talking about the <Windows>-<E> key. Thanks, Jes

Hi Folks, I'm currently linking to an Oracle database that stores all my data. I need to run queries on that data so I've linked those tables. Trouble is though it's running like a piglet with a blister. Because of the complexity of the queries being run, they're written in VBA. The program...

Hi Folks, Before we start, let me say I'm not responsible for the citrix environment, just one of the suffering users. On the client side we seem to have Anti-Virus software running, and to my mind that's a bit Butt-Backwards. Especially as it's carrying out real-time checking, ie, every file...

Hi Folks, Is it possible to run the stored procedures in an SQL database from an Access2K database? Many thanks, Jes

Hi Folks, I think the title says it all ;0) I have a call logging system written under Access 2k and would like to automatically put the tasks recorded into tasks under Outlook. Anyone have any suggestions? Thanks, Jes

Hi Folks, My users keep losing their network printers!! The most unusual so far is one of my users running access 2000 - one report would open fine, another, in the same instance, would display the message &quot;No Printers Installed&quot;. Has anyone got any suggestions, as this is driving...

Hi Folks, We are constantly having our profiles corrupted. This happens seemingly at random with no consistency as to who it affects. Any suggestions. Thanks, Jes