Recent content by TKnight

Hi, I have some VBA that is used to export a series of reports as snapshots, and then they are converted and rolled up into a single PDF document. The code works fine in the development version of the DB but when I tested the function in an MDE for 2000, I get an error message about halfway...

Oh I got it: IGNORE_DUP_KEY ON If anyone else stumbles across it!

Hi, I am new-ish to SQL server (2005) and I would like to do something that I did fairly regularly in Access but I can't seem to figure out in SQL - use a Primary Key (or index) to reject certain data being inserted into a table. With Access, if I had 100 records and a few, say 20 would break...

Hi, Please accept my apologies for posting this a second time but despite some pretty good help from JPaulo in the original post (here) a couple of weeks ago - I didn't manage to get the issue resolved. I really need to get the Novell Netware File Owner property because the way our network is...

No Probs... thanks for your help. Anyone else done this before? Cheers, Tom

Thanks for your help JPaulo but that code looks like it is more concerned with Network Connections rather than file properties. Let me elaborate a little... Take a word doc on our network as an example. The Windows properties show the file owner as "S-1-1-0" (The same as every other file in the...

Hi, I really need to get the Novell Netware File Owner property because the way our network is set-up is that the windows file owner always says "Admin" or "Everyone" (which isn't very helpful!). I've searched everywhere online and although there are a few mentions of the Netware APIs for VBA...

If you go to tools->options->view and check system objects then you will be able to view the system tables which contain all the objects. You should be able to pick up identifiers for each object type and build the queries/code you need from there. HTH, Tom

Thanks Lagbolt, I have done that before but I thought there were some issues around repeatedly opening the Access.exe? I could potentially be opening it up to 500 times a day. If there are no issues around that then it is the simplest way. I think i'm suffering from a classic Access...

Hi, I have an Access DB which is essentially a form with a timer event which runs code every few minutes to get data in "near" real time from a web service. It then processes the data a bit and feeds it into SQL server tables before waiting for the next timer event. It all works fine but it's...

Hi All, Here is the URL for a dev guide for the groupwise module you are using. http://developer.novell.com/wiki/index.php/Image:GWDevGuide.pdf I found it really helpful and enabled me to get a lot of extra functionality out of the module. It includes logging in to different accounts (just...

Sure, PM me with your e-mail and i'll send it on....

Hi, I have a database that uses the date picker control from MSCOMCTL2.ocx The problem is that in earlier versions I used a calendar control and not everyone has the OCX on their machine. I put the file in a self extracting zip file which unzips the OCX to their system32 directory and...

Hi, I recently bought the book "MS Access Projects with MS SQL Server" by Ralf Albrecht + Natascha Nicol (Microsoft Press) because it was recommended to me by a couple of people on the forum. It was a bit pricey to buy new so I got it 2nd hand but unfortunately the CD isn't inside! I don't...

Rabbie: Yeah each user has a copy of the FE. Gemma: If it only happens once in a while it's not so bad. I guess the error is generated at runtime so I could probably trap it and automatically replace the corrupt FE. I'm using an auto-update function to roll out new versions anyway so this...