Recent content by kyoch

I'm using access because it's what I have, I'm famiiliar with the program, and it's easy to build meaningful reports and forms. If there's something else out there that works then please let me know. I just don't know what's the next steo after Access besides becoming a full blown DBA.

I downloaded the data from the Texas railroad commission and converted it to 750 excel 97 files.

Texas oilfield production data for every well in Texas since 1950 :D

All, I have 75GB worth of data that I'd like to add to an Access DB. Obviously, Access DBs can only be 2GB in size so just having a back end with 75GB worth of data is not an option. I don't know anything about SQL server or anything related to that. Does anyone have any examples or...

So I found that if your tables are hidden AND you do not have the "Show Hidden Objects" checked in Navigation Options then a user cannot import any hidden objects. If you have a table that is hidden but you select the "Show Hidden Objects" button then you can still see the object when trying...

Actually, all you have to do to get around that is select "Options" in the "Import Objects" window and they show up again. So that doesn't work.

Yeah that wouldn't be good. However, I was able to manually hide the tables through Table Properties and they were not deleted after compact and repair. Also, when I tried to import the tables from a separate database they were not visible so this solves my problem! Unless someone can think...

Ok, I have the ribbon and navigation panes hidden and vba editor is password protected so the user can't enter design mode or view any code to make changes. I've found another thread with a similar issue but it's old. Looks like they hid the tables but didn't provide the code to hide the...

Does this work with Access 2013? I'm looking to disable the import ability of tables and queries.

I'm currently using .accdb What's the advantage of using .accde? Also, I don't think the dsn less route is the way I want to go. Ideally, I'd like Access to prompt for a password when a user tries to import a table from the front end, or just not allow it at all.

All, I have a split database, the back end is password protected but the front end is not. I protect the front end by disabling the shift + open option, disabling F11, removing the ribbon, all menu buttons, and there's no right click function. Basically the users only see the forms I've...

I frequently get a pop up that says "2475" and can't figure out how to make this stop. Any suggestions?

So while it's staying on the same record and displaying the correct lat and long on the main form, I can't select filter anything inside the subform. Anytime I try to select something in the subform it deselects itself and I can't perform any filter functions. For some reason, the On Current...

So I deleted the subform and remade it. That solved the switching to the first record automatically but my cursor still looks like it's refreshing every second. Still looking to be able to plot multiple records on same map on parent form.

Nvm that last one got it. Now, it's working but there's 2 things... 1. The subform is constantly refreshing and when I switch to next records, it reverts back to the first record. 2. This displays each record but not simultaneously. I didn't make that clear in the original post but I'm...