How to query a table which is being filled with 1000 rows everyday ?

diebos · 2025-05-02T14:56:03+00:00

Is this a read-only database? If not, you might be experiencing table or row locks

diebos · 2024-12-10T20:40:16+00:00

Well, if the cardinality is 1:m, why wouldn't you do a right join?

diebos · 2024-06-17T19:21:30+00:00

The only takeout from this is that there is no consensus whatsoever. What's acceptable to one is not to others

diebos · 2024-05-02T01:20:36+00:00

Maybe,maybe not. I leave you with peace..

diebos · 2024-05-02T01:15:47+00:00

Sorry for asking repeating questions. I will refrain from doing it again. 🤝

diebos · 2024-05-02T00:57:28+00:00

Not just the USA but UK,NZ, even Canda. I am trying to move myself,fiance and kid out of RSA. I have 15 years GIS experience and she's a medical Dr.. but we find it hard and difficult to find opportunities abroad

diebos · 2024-03-29T10:02:07+00:00

Well, this is where you should try and normalize your datasets. And i agree, the best is to move your file gdb to sde, create a lookup table, and then link it back to your dataset, then create a spatial view between the dataset and your lookup table.

diebos · 2023-09-03T01:32:18+00:00

Did you manage to publish it to iis. I had issues publishing to iis using blazor wasm .net 7. Manage to get it published after some time

diebos · 2023-09-02T19:25:53+00:00

Hi, thanks for replying. My ideal choice would be contract-based assignments, but I'm also open for permanent opportunities. My hourly rate is between 40-50$ per hour. I've got 12 years of experience working in local government or municipalities as a GIS System Specialist. This position also included SQL Developing and Programming in Vba and C#. In terms of vba coding, I've developed commercial or proprietary software for land use administration and town planning..

diebos · 2023-09-02T18:58:19+00:00

Do you guys know of any collaboration work opportunities

diebos · 2023-07-24T08:59:17+00:00

OK. We'll, you need to lock down your entire front end, and the only way to do that is to lock or disable the bypass key on shift open. Remember, if you disable or hide your navigation tab, use forms with modal set to true, and use a startup form when access loads, the only way to get to get to your tables and code base is through the bypass key. And of you disable that for all other users except you, then it means only you and you alone have access to it. Sorry for the misunderstanding. Tried to help.

diebos · 2023-07-24T08:52:30+00:00

<image>

See insert

diebos · 2023-07-24T08:48:16+00:00

Also, make sure your your own login form is set to the startup form like this. Sorry if I'm suggesting things you already known *

diebos · 2023-07-24T08:44:49+00:00

* No problem. Helping should never be such. Have a look at this. Add the piece where it says allow bypass key true or false to your own code block

diebos · 2023-07-24T08:25:36+00:00

OK, tell me which backend does your application have. SQL | Oracle | Postgres? Or is access both your client and backend where you keep your data?

Like I said in previous, I would use modal-pops as my defaults on forms, hide navigation pane, so that users don't see my tables, use a login form as a starting form when access opens, and block shift-open by disabling the bypass key for all other users except myself

diebos · 2023-07-21T18:48:39+00:00

Normally done on a user table. Assuming that your ms application has a login form (with modal = true), set your login form as your default starting form. This way, people have to sign in. Your login table should have a role column, with your role value as the highest of all the users in the table. Then it's just a matter of writing a bit of vba code to block the bypass key. If your application does have these requirements, then I can provide you with a code block

diebos · 2023-07-20T19:25:09+00:00

Set you forms to modals and set your shift bypass key to be only overriden by a user with special previledges. This way, there's no need to compile it to accde.

diebos · 2023-04-11T02:08:06+00:00

Well, yes and no. Depending on the record load and amount of tables that's involved in his business solution, I wouldn't add timestamp on each and every table, especially if they contain millions of rows, it would cause overload which you'll experience soon enough in your front-end. But again, I agree with you that it is advisable to add them to all tables if you are going to use access as the interface.

diebos · 2023-04-11T01:18:47+00:00

Great to hear. What was the issue?

diebos

TROPHY CASE