Continuing with the abomination known as Access 2010…
The issue is this: I like to delete previous tables before importing new ones. Access 2010 will not let me delete tables. The only solution is to delete the database and create a new one from a Blank page. This worked before – at least it seemed to. So I’ve just opened a blank page and imported two files. I go to save the database, and I have to choose one of the files. When I try to save it, it will only let me save it as a table and not as a database.
Why won’t Access 2010 let you delete tables? Until last year, I was regularly using 2010 and don’t recall having any trouble deleting tables. A quick search of tutorials online seems to indicate that you can in fact do that in 2010, generally, so it seems like there’s something else going on that’s preventing the deletion. I don’t think it’s just a feature of Access 2010.
There are several possible reasons why it is greyed out. Your privilege level may not allow for deletion, or the tables in question may be shared by other users and programs. The fact that the command is there proves it can be done, but the fact that it is greyed out probably indicates that there is a good reason for you not to do it, at least until you do something else first.
OK, in Access 2003 all I had to do to save a database is click the Save or the Save As icon on the toolbar. In 2010, I have to click on File and Save Database As. I wish I could slap whoever came up with this POS. :mad:
Sorry… yeah like Jasmine says, there is some permission issue somewhere that is disabling that menu option. Clearing and resetting the admin password on the database is apparently one way to resolve that permission issue. But if you are not using a password to open the database, then that’s not it, and must be some other permission issue that’s blocking it.
I don’t know whether to keep trying to contribute to your threads. I get that you’re frustrated with your software, but I feel like you are directing some of that frustration towards those who are trying their best to help you.
Yes, I am extremely frustrated. I was using a product that worked for my purposes, and the ‘new and improved’ version doesn’t do what it’s supposed to do.
But I am not directing my frustrations at anyone here. I did misread your post. What I meant was that Access 2003 would let me delete a table in the left window, but I never open the tables because I don’t need to so there would never be a table open I’m trying to delete.
I can’t remember which version transition of Access heralded the change from open-tables-as-floating-windows to the more strict left pane list, and right pane workspace. I’m not even sure I ever used Access 2003 - I cut my teeth on 97, dabbled with 2000, and hardly touched it again until 2013.
Access 2016 doesn’t allow you to delete a table from the list in the left pane if the table is open either in the ‘table view’ mode (where it looks like a spreadsheet) or ‘design view’ mode (where you can set the field properties) - 2016 pops up a message box specifically saying that you must close the table before you can delete it. I am not sure what 2003 does, but it wouldn’t surprise me if it just greys out the delete command.
If you have no tables open as tabs in the right hand workspace, and you still can’t delete tables in the left pane, then the problem must be something else (and I am not sure what that might be)
I’m not sure what you mean about never opening tables - in your other threads, you discussed the columns being in the wrong order, etc - how would you see that without opening the table?
This just started with the new system, so last week. I would import .csv files and export them as fixed-position .txt files. I’d run the .txt files through Easytrieve programs to reformat them and do other things. The output from one of the Easytrieves looked wrong, so I went to the text file I’d exported from Access. It had a column where it shouldn’t have been. So I went into Access and then opened the table. That’s where I saw that Access had decided, for no apparent reason, to put column 10 between 7 and 8. Prior to that, I might open a table if I import more columns than I know exist. (Excel has a habit of putting a blank column at the end sometimes.) I just delete the extra column. So I don’t literally never open tables, but I have no need to and tend not to.
Which brings us to this thread. Since I could not delete the pre-existing table(s), and since there seems to be no way to avoid Access moving columns once it’s already happened, I am deleting the database and making a new one. Only there wasn’t a Save button like there was before. I did find ‘Save as database’ in another tab, so that issue is resolved.
Is the sole purpose of Access within this activity just the routine conversion of CSV files to fixed-width? If so, I’m thinking there’s probably a simpler way to crack that nut (I think I have a VB script that will do something like that at work)
Yes, the sole purpose is to turn .csv files into fixed-position text files so that the file can be read by something like this (Note: there are many, many different input layouts):
FILE FILEA V(1000) SEQUENTIAL +
SYSNAME 'H:\EZ_Text_Files\873152_Input.txt'
AR-NUM 6 12 A
FIELD-BYTE-IN1 AR-NUM 1 A INDEX SUB1
NAME 18 40 A
NAME2 58 40 A
ADDR1 98 30 A
ADDR2 128 30 A
CITY 158 20 A
STATE 178 2 A
ZIP 198 5 A
*ZIP-4 204 4 A
ZIP-4 203 4 A
PHONE-AREA 208 3 A
PHONE-PRE 211 3 A
PHONE-REST 214 4 A
DOLS-MM 223 2 A
DOLS-DD 226 2 A
DOLS-YY 229 2 A
TERMS 233 15 A
CURRENT 248 12 A
CURRENT-NUM 248 12 N 0
CURRENT-BYTE-IN1 CURRENT 1 A INDEX SUB1
CURRENT-DOLLARS 248 10 N
CURRENT-CENTS 258 2 N
01-30 260 12 A
01-30-BYTE-IN1 01-30 1 A INDEX SUB1
01-30-DOLLARS 260 10 N
01-30-CENTS 270 2 N
31-60 272 12 A
31-60-BYTE-IN1 31-60 1 A INDEX SUB1
31-60-DOLLARS 272 10 N
31-60-CENTS 282 2 N
61-90 284 12 A
61-90-BYTE-IN1 61-90 1 A INDEX SUB1
61-90-DOLLARS 284 10 N
61-90-CENTS 294 2 N
OVER-90 296 12 A
OVER-90-BYTE-IN1 OVER-90 1 A INDEX SUB1
OVER-90-DOLLARS 296 10 N
OVER-90-CENTS 306 2 N
BALANCE 308 12 A
BALANCE-NUM 308 12 N 0
BALANCE-BYTE-IN1 BALANCE 1 A INDEX SUB1
BALANCE-DOLLARS 308 10 N
BALANCE-CENTS 318 2 N
As you can see, the Easytrieve expects to find fields starting in certain positions, and for a certain length. Access is the only too I have (that I know of) that will let me put the input file into fixed positions. I don’t know anything about VB – not even how to run it. So if you have a script I’ll give it a try; but I’ll need to be instructed.
ETA: You need to be in Straight Dope v3.7.3 theme to read the code.
I’ll have to wait until next week when I am back at work (that’s where my scripts live) - but I’m fairly sure I have something that will just run with a double-click, and will create fixed-width copies of any CSV files it finds in a folder (it will need a bit of tweaking to set up the specific field widths you want, but that only needs doing once)
That sounds a lot easier than mucking about with Access. I could set up the positions and widths for each member’s data and save it under their number.
