Search results

hi All, Is there a size limitation on how many rows an Excel 2007 spreadsheet can have when importing to Access 2007? I have about 9300 rows of data in Excel(not big) and the eventual size will be much bigger. But even now, it's taking forever to import just 9300 rows of Excel data. Geez. I...

Jeanette et al, This is very handy! Didn't know one could do this. Cool. My question is there a way to turn off the calendar icon programmatically in VBA? Since these tables are created on the fly... thnx! flyinghippo99

Figured that much in the interim. So, it seems I have to manually set it on each user's desktop as part of the installation....

Bob, 1) Do they put the trusted location as where the FE sits(on their desktop) or the BE location on the network drive? (Note: If it's the BE location then I can set that in the accdb version then when I convert it over to accdr version that network drive BE location will be considered safe...

Also, everything runs SUPERSLOW on the FE(frontend) version for the other users. It's superfast for me. But it's the EXACT same version I put on the network drive and then copied it to the deskstop for each users(including me). Not only that, some of the UI disappeared when they run it on their...

Hi Bob et al, OK. So, I created a working accdb(Access 2007) database. Then I turned it into an accdr and put it on the network. My users copy a version onto their desktop for testing. However, when they run it prompts them to enable macros. Is there a way for me to set the accdr to run...

Hi All, I figured out a significantly better data schema already. It reduced the number of tables from hundreds to just a few. And the SQL is simpler for update, insert, delete. Ironically, the view(select) is still complicated. It's OK. I can live with that. This forum is a great resource...

Since this is a db design forum, perhaps, the better question is what is the best/optimal table design for the problem I described above. Instead of trying to fix the symptoms, let's get to the source. I know needing more than 255 columns seem like something is wrong with the normalization...

Bob, Steve, et al: I was celebrating the last few days with this new data representation since I can eliminate hundreds of tables and collapsed them into 1 big table with -1 and -2. HOWEVER, I just remember why I had to my complex methodology. It has to do with Access 2007 limitations of 255...

Steve - Thanks a great point. It's all positive. So, I can map na = -1 and so forth. Is there an easy way for this in SQL? Or would I have to do it through ADO/DAO and stepping through the recordset looking for -1,-2 etc and replacing them with the strings "na" etc. just for the...

Bob - Would it help if I use multi-value fields? Also, I was thinking using class objs in Access, but not sure if it will really help in this case...?

This is the business reqs. :) They want to be able to view a biz data series(let's called it F1 for fieldname1) that looks like this: 1/1/2008 534530 2/1/2008 na 3/1/2008 na 4/1/2008 4353409 5/1/2008 nr 6/1/2008 34590 ... you get the idea. That's why it's so complex...

Yea, I thought about that from Day 1. HOWEVER, the Data Entry forms, the user reqs is that they can enter the data in their original format($, %, text, decimals, integers,etc.) Ack. I guess I could let them enter into a local table with the right data types then do a conversion into text to...

Bob et al, The source of the complexity is this. I might as well lay it out here since this is afterall the Theory and practice of db design forum. So, here it goes: 1) I got Fieldname that needs to have heterogenous data values. For example, Field1 is usually numeric("Standard" as Access...

I take it back. The BE is SMALLER than the FE. HOWEVER, the FE is the SAME SIZE as the original unsplitted db file. Hmm... I thought after the split the FE should be smaller than the original size..

I just went to Database Tools menu and did a split. I closed all forms and tables. After the split, I looked at the FE db and most of the tables are LINKED to the BE. But the file size is IDENTICAL... Strnage..

Bob, It stopped working?!! I added more data to my original single unified db. Then I did the split the db into FE and BE again. This time the FE is the SAME size as the BE?! Did I miss something? Thanks, flyinghippo99

SideEnd! Sounds interesting. Never thought of that. So, the FE would do the intermediate calculations in the SE db? And where would this SE sit? FE is on the user's desktop. The BE is on the network. Should the SE be on the user desktop or on the network? As to why I have hundreds of...

I take 3) back. There are lots deletes too and lots of appending data...

thanks for the suggestion. I have it compact & repair after quitting the application. The bloating still persists...