Search results for query: *

I've found the problem. My connection string needs to be changed from Jet.OLEDB.4.0 to ACE.OLEDB.12.0 and it works fine.

Hi Skip Here is the code Sub ADOFromExcelToAccess() ' exports data from the active worksheet to a table in an Access database ' this procedure must be edited before use Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long ' connect to the Access database Set cn = New...

Hi I'm trying to write data from Excel 2007 to An Access 2007 database. I have tried code which is designed for an Access 97/2002 database and it does not work with Access 2007. At least I think it's the code. The same code works OK with an Access 97 database but I get an error saying that...

Starting the merge from Access I get as far as opening the existing Word document. When this is open a "confirm datasource" dialogue box opens with one choice in it - OLE DB database files. Clicking OK on this brings up a "mail merge wizard" error box saying "Word was unable to open the data...

Thanks for the reply fneily. I'll repost in the access forum. I forgot to mention that I did try initiating the merge from Word and got the same error.

Starting the merge from Access I get as far as opening the existing Word document. When this is open a "confirm datasource" dialogue box opens with one choice in it - OLE DB database files. Clicking OK on this brings up a "mail merge wizard" error box saying "Word was unable to open the data...

Our company is using Office 97 and is planning on moving up to Office 2007. Some of the Access databases are used via runtime versions of Access. This was achieved by using Office97 Developer tools. Can the same be done in Access 2007?

Using Client 6.5.1. On login screen there is a dropdown box asking "for user". This box lists the usernames for the first 9 id's found in the data folder. If the username which I want is not in the list I have to click "other" and then find the id file for that user. Is there any way to make...

We are running Lotus Domino server version 6.0.5 on Windows 2003 server and for the past two weeks we have come in on a Monday morning to find that the server has shutdown during the weekend. The only event in the event log confirms that the Domino server stopped. The Windows 2003 server is...

Thanks for your reply xlhelp. I will check for the last data cell next time it happens. I haven't tried disabling the antivirus. We have real time protection on the PC and on the server. There is plenty of space on the server and every user has their own folder to which only they have...

We have an intermitent problem with users saving excel97 files to our windows2003 server. Occassionally when saving, Excel looks as if it has locked up and has to be kiled off. It has in fact been creating a massive file on the server with a name composed of random letters. This file can...

Hi We are testing a Citrix/Thinstation solution for our workplace. A diskless workstation boots via PXE and downloads the linux OS and the thinstation configuration file telling it which server to connect to via an ICA connection. We are not using program neighbourhood on the client and we...

I am trying to set up a diskless workstation to access the published desktop on a citrix server running on windows server 2003. I have built the network boot image using thinstation. Everything works fine until I enter login details and then I get the message "To log on to this remote...

Hi I am a newcomer to citrix so please excuse any obvious oversights by me. I have XP Presentation Server 4 running on win2003 server. Using Thinstation on a Suse OS I created a network bootable file which, during its creation, automatically downloaded the Citrix linux client. This boots up...

Hi tf1 and thanks for the reply. It isn't a link that I've inadvertently created the whole workbook is embedded in the Word file. I can mail the Word file to someone who does not have access to the original Excel file and they can still double click the chart and get access to all of the other...

I've been using Office97 for several years now and have not noticed this "feature" until now. I have an Excel workbook with a few worksheets, one of which contains a graph. If I highlight the graph and "copy" and then launch a Word97 document and "Paste" (not linking)I get the graph in the...

OOPS Just noticed that you wanted to print them on the same page. Sorry.

MArk up first block (drag cursor). Holding control key down mark up all other blocks. Set print area. Each block will now print out on a separate page.

Users are running Excel 97 SR2b on Win98 machines. Files are stored on a win2003 server. A user can be working on an Excel file and save it successfully several times but then the next save causes Excel97 to hang and the task has to be ended. Also the temp file which excel uses has grown to a...

I have just been using the 180 day trial version and it installed OK. I guess you have a faulty CD.