Search results

Edgar, I would never store money under YOUR mattress. When I go into a SCIF, I always have two guards carry my laptop. I figure I can't be too safe.

The_Doc_Man, I checked my hard drive and the largest file size in the backup folder is 2.07Gb. I suppose that's why my database hasn't crashed. I will keep working on it. Just a little more and I should see smoke. Thanks for the heads up.

I am still working on it, so I am fluid. The only thing that I don't want to deal with is splits. I have a partner who wants us to use them. We are like Steve Jobs and Steve Wozniak.

Colin said it correctly. I have a real problem with the concept of a split database. I learned from Mike's article that someone in the organization can change the data if he has access to a split database. I don't want that to happen. In other words, I do not want my database to be used by...

Using a split database requires two files. To me that means twice as much work and managing a split database could also mean using special tools. I don't use and I don't want to use anything other than Access.

The_Doc_Man. You mention 32-bit. I am running my database on a 64-bit laptop. Does that make any difference? When I commercialize the application I plan to sell it with a PC. I don't want users to have any hardware problems that I don't have.

Amorosik. At this time I have one ACCDB file with all of the tables, queries, forms, and reports in it. One day I may split it into a front end and a back end. I won't do any splits until I have separated the database into multiple files by domain. Currently I am the only user and I learned...

Yes, The_Doc_Man. Clayton Christensen wrote years ago in one of his books about Disruptive Innovation that Access could kill off SQL Server if it was allowed to run wild. Personally I would like for MS to do away with Runtime Access and EOL older versions. They don't make any money off...

Yes, Edgar, the application reads information aloud. You have to understand that this database has an information focus rather than a data focus. It has lots of information about each entity (e.g., staff member, customer, project, etc.) Each staff member for example has a name(s), multiple...

I use File Explorer to tell me the size of the database. It has been between 1.93 and 2.1 Gb for years. C&R always brings 2Gb+ back to 1.9 Gb, but I expect that to fail one day so I would like MS to increase the file size to 1 Tb or at least 8 Gb. I could even live with 4 Gb for a few...

XPS35, I am more than happy to describe the database to you. It is designed to be used by companies that pursue multi-million dollar contracts (>$10M US) and take months (6 to 24 months) to develop a proposal. The primary domains include: customers, competitors, personnel, projects...

No sir. I don't touch SQL. I have one Access file that is not split. I frequently run C&R. I am not sure why the database has not crashed. Perhaps 2 Gb is not real. I have been teetering on it for years. I back up the application every few days, just in case.

Thanks. As you can see, I set out to develop a comprehensive Access application and not an app. Some of the 4000 tables have between a hundred and two hundred fields. One piece of code says that I have 25000 queries. I have no idea where that number comes from. If not for the 2Gb...

My largest database has 4600 forms, 3200 reports, and 4100 tables. A few tables have between 100 and 200 fields. Most of the forms and reports have a custom graphic and many of them have text-to-speech. It is a little over 2 Gb. It doesn't have a lot of data. And there is very little code.

Hi all, I am new to AccessWorld but I have been using Access since Y2000. I am developing an Access database that currently has 4,600 forms and 3,200 reports. I enjoy adding custom graphics and speech to the application.