TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mwmosu
NA
10
0
Access 2002 issues??
May 19 2004 11:33 AM
I have written and deployed a program that will update, delete, and add data to tables in microsoft access 2002. The problem that remains (and didn't before the switch to Access 2002 was made) is that the mdb file grows at enormous rates as the program runs, and gets to the point where the program can't connect to it. Then, if you try to open the database, Access tells you that your .mdb file is either corrupted or isn't a .mdb file. "You or another user may have exited microsoft access while the database was still open" is another line on the warning. It then asks if you want to repair; if yes, the size of the file is reduced, and it works fine. If no, nothing happens. The src files were constructed in a way that combatted unnormalization of the database. Since all the tables had 4 fields in common, all records were combined into a master table with only these fields represented. This master table (7000 records) is used to draw info on what table to go to to make database changes in the program. (hope that made sense) I thought this piece of information may be part of the problem. The file size will grow (usually up to about 75~ MB from 7~ MB after repair) until it decides not to work. We probably add around 50 records in a day. Has anyone had any experience close to this? Thanks
Reply
Answers (
1
)
Manipulate the HTML controls before sending it to the client.
connecting to Access DB from C#