Search results

Not sure why that is happening... It's either filtering something out of the table you're appending from or it's breaking the rules of the table you're appending into and ditching the records. Are you running the queries manually or with code? If with code don't use DoCmd.setwarnings = false...

Duckster, If I re-read this correctly you add records to your "mobile" version of the DB when you're on the road and then need to append them to the main DB when you get back. You're not editing other records on the road, only adding new ones. If that is correct this will solve your problem...

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

Well in theory staff are supposed to shutdown before they go home which should have reset all the connections last night. I'm sure all 8 didn't leave their PC's on overnight and as they left they should have dissapeared out of the .ldb shouldn't they? But I halted all new connections before I...

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

Yeah that is strange! I came across this recently and it wasn't too serious so I investigated it a bit and then worked around it. The info I posted to you previously I found on support.microsoft.com (search for the registry entry). If you do come across it loads then it may be worth...

There is a windows registry entry MaxLocksPerFile which allows you to customise the amount of records you can lock at any one time in a recordset. I think it defaults to 9500 but can be boosted depending on your machine spec. (not sure if it would go to 27000 though!) There is an extra twist in...

Hi, I have a report that contains just over half a page of data and then two sub reports. I have set the subreports "Can Shrink" property to "Yes" so that if they don't contain any data everything fits onto one page which is what I want. When there is data in the subreports though, I want it to...

Thanks Pat/Doc. Of course I can run one month at a time but I bet you didn't build up your vast knowledge by early submission to these things :) I can also split the data into smaller recordsets if needs be. For anyone else out there who comes up with the same thing my netware is v4.9 (SP2)...

Hi, I have some code which updates an invoice table with transaction numbers. It worked ok until this month when we had to run three months worth of invoices in one go. I recieved a runtime error 3052 "File Sharing Lock Count Exceeded" and Access told me to increase the MaxLocksPerFile registry...

Thanks Pat, I tried something very similar yesterday using delete/append queries or make table queries from linked tables to update the data. Unfortunately I then hit the "Numeric Field Overflow" message that I often get in the same situation. Compacting soothes the problem but by no means...

Hi, I have a DB that relies on text file imports as well as input and I recently split it. Unfortunately now my refresh script that updates the tables based on the text files imports them into the FE rather than the BE. I have messed around with workspaces but am struggling to get a solution...

Hi, I have secured a DB and everything is tickety boo except for the fact that I want to be able to administer permissions from the FE (MDE) and the modify permissions button that i have put on a custom toolbar is greyed out when I log in? I have full admin rights on my group and own all the...

Can anyone tell me if it's possible to enable active x objects on toolbars? I need to add a groupwise address book control to a toolbar and Access adds it ok but it is permanently greyed out. I can add it to forms with no problem. If I can't i'll need to call the object through VB wich i've...

Yeah I checked the version of the dll on the machine I was working on and it was different to the problem dll mentioned in the KB. I have sorted it now though. I couldn't view the code to export it so I just removed all the form, report and standalone modules and re-saved the objects. Then I...

Thanks for the help... I have the KB article and it does seem like the problem becuase I did import a module from another database a few minutes before I closed to do the compact. I can't seem to follow it's resolution though? It says to open the form in design view and save the code behind...

Hi all, apologies for the long post but this is a long nightmare! Using A2k on Win2k...Due to roll out a DB today, just made my final tweaks and decided to compact/backup as have done many times before. It's not a split DB but it is secure so I copied the mdw onto my desktop and accessed it...

Thanks Len, Haven't received it yet but some external stuff is taking a couple of days to get through our mail server at the moment! If it doesn't arrive soon i'll get back to you if thats ok. Thanks again, Tom

Ok, so I tried again, restoring the back-up I made of system.mdw This time there was a problem setting and unsetting the permissions. When I tried to remove all the permissions for the "Users" group it wouldn't let me alter the permissions for "New Tables/queries" as I didn't have admin rights...

I made a backup of system.mdw before I did anything. I then created a totally new workgroup file and joined it before changing any permissions. The new workgroup file is not in the working DB directory, it's in a sub-directory, would that matter? Just in case I had messed up the system...