Recent content by tweetyangel

sql server isn't an option for us I don't think. We may create the tables in Oracle instead of Access though and leave the front end the same. I am not going to make any drastic changes until we change out the hard drive on the server we are using (Win2K). I will do that Monday night. If...

Yes, Open database using record level locking is checked. Default record locking is set to edited record and default open method is set to shared.

What is MSDE?

The file being flagged to repair is 36mg. I have less than a dozen users at a time working in it. Only about 200 records per day are being added to one table. The same number of records are added to another table in another database that is larger and it is not being corrupted. (reminder: i'm...

It is not the database with the memo field that is getting flagged to repair. I removed the table with the memo field from the 'data' database and it is still going down.

I moved the table with the memo field into another database and the other database is still the one crashing. I already use FQN's for my linked tables, I am assuming by FQN you are referring to 'server\path\filename' instead of mapped drive letters. The size of the database crashing now is...

I have a front end and back end application. the front end is on the C drive with linked tables, queries, forms and reports. One of the tables that is used daily has a memo field. The back end lives on the server and there seems to be no problems with the server itself. Almost daily and...

The "Search Fields As Formatted" option in the find dialog box is checked by default in Access 2003 and is slowing down searches tremendously. How can I change this default setting?