Search results for query: *

Have you solved this already? I'm having the same problem now. Patrick.

Hi, I have got a serious problem (don't we all). When I import a Access2k table to SQL2k (only 57 records) some data is lost. All records are imported but one field is left empty ocassionately. The table is as followes: Table [Opmerkingen] Fields: [ISO NR] = text [Opmerking] = memo Some...

Incredible. So much programming for just a simple icon. I would just download the resource hacker util (see my above post) and save as. This saves a lot of API stuff. Patrick.

Phew. I don't know if you can rip icons of exe files with the imagelist. I do know that you can use the program resource hacker to rip icons from executibles, dll's etc. http://www.users.on.net/johnson/resourcehacker/ You can save the icon as ... and load the .ico file in the imagelist. Patrick.

Thanks. I already figured it out. I used the Datediff function to get a difference between the values and multiplied with 24 or 60 to get days / secs.

Hello, I am creating a query in Access 97 and I would like to summarize a time field. E.g. [Duration] = 00:04:03 I I sum this field in the query, I get all mixed up values like 0,67 in stead of 1:65:03 Any suggestions? Thanks in advance, Patrick Wolfert

Thanks both for your help. It isn't really a problem because SQL is the only thing running on that server. So memory is available for SQL. I discovered I could not install a new virusscanner on the server because the setup ran out of mem. I looked at the task manager and discovered that sql is...

Hello, I have a SQL server (2k) up and running (win 2k adv. server as OS). The problem is that the sqlsvr.exe's memory usage is increasing by the hour. In two weeks time, the program is using 1,6 GB of internal memory. Once I reboot the server (or restart the service), the mem. usage is just a...

Try this: DoCmd.TransferDatabase acImport, "dBbase IV", "D:\V Care\Project\", acTable, cmbhav, "D:\V Care\Project\bhav1.mdb", False, False Patrick. PATHTOFILE is just the path, not the file itself. Patrick.

Try this: DoCmd.TransferDatabase acImport, "dBbase IV", PATHTOFILE, acTable, DBFFILENAME, "D:\V Care\bhav.mdb", False, False patrick

What parameters have you given TransferDatabase. Please post the code. Also: Have you looked at the VBA help file. It contains an excellent example of both commands. Patrick.

You're welcome. Patrick.

Thanks. Works like a charm. I will set the primary key it's just that I just finished importing the table from access. patrick

Hello, I have imported an access dbase into SQL 2k. Afterwards I have done some querying / updating etc. The problem is that somehow there are a lot of duplicate records in the table. I most have made a mistake with updating the table before. I have tried linking the table in an access dbase...

I did check them and both are running under their NT-account (Administrator on the server and my own username on the notebook). Patrick.

- TransferSpreadsheet for Excel - TransferDatabase for Dbf (Dbase) Look in the help file for some easy to use examples. Patrick.

Thanks again. btw: I think you've linked to the wrong FAQ. Patrick.,

Thanks. It worked (the stored proc). Are all security issues (user rights) also copied using this routine? Patrick.

The remote host server must be the SMTP server. In your case, in which you don't have a LAN, you need to point it to the SMTP server of your ISP (mail server). Patrick.

Hello, This is the situation: I have got an SQL-2k-server running several dbases, which has to be online. I've got an notebook which I use for development and it's running MSDE 2k. The problem: I have developed a new database on my notebook which I want to transfer / copy to the sql-server. If...