Recent content by ddelport

Well, how do they say: "The only constant thing is change..." I have a couple of databases on our LAN, all the users has (had) a copy of MS Access on their various pc's. Our old IT company is new something of the past and so is everyone's office licences. Only a lucky few will have this...

I had a similar problem once, only I didn't intend to delete that file(don't think you can or are supposed to). I wanted to work on some tables but coudn't access it. As far as I understand, that file indicates that someone (who could be anyone) is logged in to the database. Is this database...

Yeah, thanks, and your's takes less time AND space...

Thanx Chaz! Didn't know about that one. I suppose I can get along without the help of vbscript afterall! I have, in the meantime, found another alternative as well - just for info, but pleeze help me right if the following is wrong (it works in practise though) : dim flsysobj, thefile,thesize...

See the search facility is not working!? I want to run a procedure that is dependent on the evaluation of two files' sizes. As the one grow it's larger size will be used as condition to update the second file. This I need to build in an Access procedure but I don't know vbscript that well. My...

Thanx AvGuy, seen in hindsight it makes more sense to take your advice and Import rather than Link. Even though it is the same table (with a couple of new records) one would repeat this procedure when needed. The records are "imported" to the second table one-by-one anyway, so if this procedure...

Ja, fanx Mike! I know, but hey, I am from a 3rd world country, so we have to be satisfied with the crumbs on the floor. Not that I am reflecting my problem on you but how would you feel like paying almost $5000 for one software license for the latest MS Office pro package? Well, in my country...

I am using an Access 97 Database that contains a link to an HTML table. I have no control over this table because it is generated and updated automaticaly from other software. My database is based on the info from this HTML table which is compared to a second resident table. New records are...

Thanks Ya ALL! I haven't tried out all the suggested option yet, but I couldn't find anything saying "missing" and checking/unchecking didn't work in my case. I then did as Hap007 suggested, I imported the frontend to the sick PC and that immediatly remedied the problem. Although I cannot find...

No suggestions yet?...Well, I have explored other avenues and have decided to rather work in 3 phases. Phase 1 - limit the amount of faxes in the desktop/user interface to 10 or less. Phase 2 - run a "compare unmatched query" on a second table that resides in my database with the HTML table...

One of the PC's in our LAN using my database wouldn't run the VB code that contains the above functions. We run Office 97 in a Win 98 environment... Which libraries contain these functions and where should I be looking for the problem. I compared the library references on my own pc with those...

Hi, I am working on a database to manage, and make incoming faxes available on a network server. The faxes come in on a fax machine on a standard landline. It also has a network adapter that sends these faxes as .tif images to an e-mail address. Or so I think it works. Then there is what I will...

Thanks JGillespie! That is a quick solution. I think(hope) that the average user wouldn't figure that out, maybe I'm a bit too paranoid...

[dragon]Once upon a time I tried to use a custom toolbar to enforce some extra security in a database. You know what I mean that there is some places you just don't WANT users to be going to. In my nervous outbreak I took out some options in the start menu as well and ended up locking myself out...

Thank You Roy-Vidar! To be honest: I took this long because it took me THAT long to completely process and file the last posting you sent me. This was worsened by the fact that the saved Access query still complained about an "undefined function". Well, my (and your's thankfully)...