Search results

This is a real mind bender. I am running a2k. I am merging two databases. table1 is in the backend database. table2 is linked to the second database. I run an append query to add table2 entries to table1. The append fails for 96 recs saying key violation. Turns out I can rerun the append if I...

I agree. Our users are usually very good about shutting down. But it can't hurt to remind the 'night crew'. The symptom just started happening over the past few weeks. That is why I am curious if it is a MS critical update vs. users.

Any update on the reason for corruption? We have one database running on a slow Novell network which is getting corrupted every week. I think it is a user at night who is getting frustrated with the speed and simply killing the process or shutting down without closing the db. I can't prove it...

Thanks VERYMUCH for all your guidance Uncle Gizmo, Ken and Pat. I think I will head for the the .mdb/mde solution to keep the users familiar with the existing access screens and make the handful of DAP screens for the 'light' users. You have all convinced me it is not worth the time/effort to...

Ken- Thanks for the ranking! I am extremely tempted to jump on the .net bandwagon and go for vb.net, asp.net or c#.net. I most likely will go via asp.net since my client likes the idea of a browser based solution. Curious you have no preference of adp vs. mdb as a solution. Or does it plain...

I need your opinion/comments - We are looking to consolidate four copies of the same A2K db into one sql server db. Naturally the access db could use more normalization. Heck, two main queries are at the maximum number of fields allowed in access! I tried importing into SQL server and the main...

I like that fancy hand waving Doc Man! There are two .ldb's, ex: db1.ldb (database) and users.ldb (security). So I have to assume the karate kid is happening in the db1.ldb vs. the security lock file. The db1.ldb will always be in directory of the mdb (db1.mdb), Therefore on the server. And the...

What about the security .mdw & .ldb? Does it matter if they are local or remote? There should not be a lot of updating or reading going on with the security lock file. Simply write operation when the db opens & delete entry when it closes. Correct?

Thanks DOCman! I've asked them to move the database up in structure. Not physical structure, but logical structure. I'm not sure if that will help or not in the Novell world. There is a Novell kb article confirming too many subdirs is bad. Good point about the ldb file. It makes sense why the...

Can A2k run over a 1.5Mb line? Would A2002/2003 run better? Any network parameters to tweak for speed? Any registry settings for Access worth trying? Splitting it to a fe/be did nothing for performance. It actually ran slower ;) I read other threads and will try to turn off name auto-correct...

Thanks Ghudson, The two button method works. fyi-I had to put in a Me.Refresh also.

I have a toggle button which is supposed to flip the form from 'view only' to 'edit mode'. Problem is once .Allow* is false then the toggle button is disabled. I had a break point in VB and it never was hit. I tried pushing the users to click yes/no on an Update Record question (Forms...

We can view/edit the A95 reports. We can NOT run a compact on the database. A repair runs with no error messages. When we try an import report by report from A95 to A2k, it seems to go along for a while, then gives a memory error. Does anyone know a good utility or tool (hopefully free) which...

Pat- You are probably right on the money with the autocorrect. This database was in 'beta' as A97 and then ported to A2k. I then imported what was 'worthwhile' into a new A2k db. So the error seems to have propogated between versions. -norm.

Do a search in these forums for "Macro Security" or "Sandbox". Take a look at this thread

Thanks PAT! You helped firm up my plans. The handful of power users are at their wits end with the exclusive access issue. I think they understand the benefit of splitting the db now! I only have tried FE/BE, so the MDE w/ BE & FE environment will be a first for me. But it sounds easy enough :)...

Thanks mcadle for the confidence. I want to steer them to mde's for their regular users and make sure the FE's don't give exclusive lock errors when a power user wants to make a custom report. I'll probably give the three power users their own FE's so they don't get exclusive lock errors or have...

ANything to watch out for?? We have a database where most users would simply run w/ menus & forms. So standard /runtime. I want to split the database to fe/be's as follows: 1 BE - obviously 1 FE - typical users. Will sit on shared network drive 3 FE's - for the three power users so they can...

I also had this error. I want to trap the error so my user doesn't need to run the task manager to stop access. I have a form, the user fills in the criteria, clicks a button, opens a report. Problem is: I changed the field name of a linked table. The form receives the 2766 error, traps it in...

I tried GHudsons ExportDatabaseObjects code but fails in A95 with an unknown method: Application.SaveAsText Does anyone know the correct syntax in A95 to export report&form objects to text. Or the code to export the objects directly to another db from A95. note: I can not bulk export from A95...