Search results

Database maximum Size Thanks!

Database maximum Size Thanks for your response. I tried to Compact last night while the network was not busy. After clicking 'Compact' the progress bar appeared and went all the way across but it never actually compacted the DB. I tried compacting some of my smaller DB's and it worked...

Thanks! The database is really very small only about 5 queries, no forms or reports, one macro that updates one of the tables and no modules. Just about our entire office taps into this database constantly via other databases for data entry and reporting. Thanks for your help. I'll let you...

Thanks, I'll try that. One of my co-workers thought the compacting would be temporary because we run updates to this DB from another DB. Would I have to compact the DB after each update?

Thanks for the quick reply, I thought 15,000 was kind of low too. There aren't any other large (More than 20 records and five columns) tables in this DB. A linked table shouldn't affect size should it? When I look at the size of the DB it's 1.04 Gig. Sounds crazydoesn't it? Any idea where...

My Access 97 database has reached the maximum size. If I understand all I've read on the web, I think this is due to a couple of tables being around 15,000 records. One table has about 15 fields the other more like 30 fields. I still need access to all of the records, but is there a way to...

Thanks Ian. I'll Chew on this a while and see what I can develop.

Ian, I am interested in what ever I need to do to protect this. My users must be prevented from changing the Excel sheet at all costs!! Making a read-only copy is not a viable option so please provide the details to create Excel objects you mentioned. Thank you.

I'm opening various Excel documents from an event in Access via... Label22.HyperlinkAddress = "Z:\Quotes\" &

I'm opening an excel spreadsheet from Access via a function. Label22.HyperlinkAddress = "Z:\Quotes\" &

Thanks Wayne.

I may have done this the long way but I developed a solution to this situation. First, created a table with a large number of records pre-defined. Second, created an update query that would update the table for every record <= the box count on the input form. Third, My report pulls only the...

What does the dot.Newfolder.gif icon mean beside a post?

I'm trying to print box labels that contain the text "Box X of Y". The user is entering the 'Y' value on a form that queries the address information. I am stuck on trying to calculate the 'X' value for each label. The printing of the label is handeled by a report. How can I populate a table...