Search results

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...

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...

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...

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, 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...

Hi, I have a split FE/BE system running on a network and I am having a few issues with the FE's corrupting... Occasionally a user will call up saying they can't get in and when I go, I get the "microsoft jet database engine could not find object MsysDB" error message which basically means...

I am just about to release phase one of a DB and am trying to figure out a way to digitally sign the project? I managed to sign the development version on my machine but after reading about the self-certification process I realised it's not going to work on other machines. As I will be...

Hi - I hope this question isn't quite as noobie as it might at first appear! I have to store a TimeStamp value which is used to determine the chronological order of records. If this was a date field no problem but I actually have to decode it from an XML Base64Binary field and it comes out like...

Hi, I am in the process of adding a couple of extra bits to Bob Larsons extremely useful FE auto update utility and have got a bit stuck on something relatively simple but I can't find any good examples for the code I need because strictly speaking it's bad practise to dymamically link tables I...

Hi, I thought i'd post this example because I recently had to do this for a project but most of the MS documentation relates to the EightBall webservice on the now defunct GotDotNet site. I'm not sure if it will work or not unless you download the Web Services 2.0 toolkit which includes the...

Hi, For a project i'm working on I need to get data from a real time interface which uses web services and returns XML. I have managed to connect to the web service and get a DOM NodeList but I am now struggling to get the data into Access somehow. I was hoping i'd be able to Save the Node list...

Hi, For a project i'm working on I need to take data from a RTI every few minutes or so. The data then needs a bit of processing before it can be posted to another table which users will be constantly querying. I'm thinking about creating a second back end just to handle the "Real Time" table...

Does anyone know why A2007 has completely removed the User Level Security (ULS) from it's new DB format? It seems crazy not just for security but how easy it is to create user-specific functions (audit trail) etc. with Application.CurrentUser I know it will remain the same for <=2003 MDE's...

Hi, I would just like some general opinions about progressing from developing in Access/VBA to developing in VB.net? Basically I am a self taught developer. I started learning VBA by recording Macros in Excel and looking up the code afterwards. I then started building more and more complex DBs...

Hi, I'm trying to delete some records out of a table. I have a query that acts as a filter and is linked to two fields of the table that I want to delete from. I have put the * field from the table in the query and set the "Unique Values" property to "Yes". Access tells me "You cannot delete...

Hi, I have a DB that is basically a big electronic form. Each table is a section of the form and the main central table stores the ID's from the other tables. Most of the relationships are one to one but without referential integrity because sometimes sections need to be skipped. It's been...

Hi There, Is it possible to change ownership of a database to a group rather than an individual? The reason I ask is that i'm due to leave my employment this week and need to generally get things ship shape before I go. I currently own all the DBs that we use and I need to change that so people...

Hi, I have a networked DB and I can't update the FE because the LDB file is locked. It says there are about 8 users in the DB which I know isn't true (I keep a table of current users and I prevented any new people from logging on before I went home last night) I've never had this happen before...