L
Lisa B.
1. How to speed up database connnected through the LAN????
I have an access97 database that is split Front end - Back end with the Back
end on a network drive.
When I am connected to the back end on the network drive, the program runs
vvvvvvery ssssssslow!
Is there anything I can do to make it faster ( I compact and repair both
databases on a regular basis...like every day)
ALSO
2. How to decrease the size of an unusually large database???
The front end is very large(13,296K) and I don't know why. I have other
databases with way more forms, reports, queries, and code and are attached
to larger back-end databases with more data and tables - that are less than
half the size of this database. I'v even tried creating a blank database
and importing all the tables, forms ect... but the resulting database is
just as large.
Note: I repair and compact my databases daily
I have an access97 database that is split Front end - Back end with the Back
end on a network drive.
When I am connected to the back end on the network drive, the program runs
vvvvvvery ssssssslow!
Is there anything I can do to make it faster ( I compact and repair both
databases on a regular basis...like every day)
ALSO
2. How to decrease the size of an unusually large database???
The front end is very large(13,296K) and I don't know why. I have other
databases with way more forms, reports, queries, and code and are attached
to larger back-end databases with more data and tables - that are less than
half the size of this database. I'v even tried creating a blank database
and importing all the tables, forms ect... but the resulting database is
just as large.
Note: I repair and compact my databases daily