S
Stevie_393
Hello,
I have an Access 2003 Form that does ok until I do a Filter (right mouse
click -> Filter For) on a specific record (in this case client name). When I
get the client information back (its a 3 page continuous form with about 100
records about the client) I may or may not change some information on the
client. When I hit the "X" or try to close the form, the database locks up
every time and I have to do the three finger salute. As an FYI, the database
is split with the BE database on a network server, the front end on my
laptop. Network connectivity / speed isn't bad.
My database isn't complex. I have one FACT Table with about 20 lookup
tables joined to it. About 500 records in the database. The FACT Table has
about 60 columns in it. Most of those columns join back to a lookup table.
Last thing. The first thing I do when this database is launched is to
create a persistent connection using some VBA code. I use the vba command
CurrentDb.OpenRecordset on a table that has one row and one column in it. I
call this VBA code from a startup form.
Any suggestions on how to fix this? Thank you in advance.
Steve
I have an Access 2003 Form that does ok until I do a Filter (right mouse
click -> Filter For) on a specific record (in this case client name). When I
get the client information back (its a 3 page continuous form with about 100
records about the client) I may or may not change some information on the
client. When I hit the "X" or try to close the form, the database locks up
every time and I have to do the three finger salute. As an FYI, the database
is split with the BE database on a network server, the front end on my
laptop. Network connectivity / speed isn't bad.
My database isn't complex. I have one FACT Table with about 20 lookup
tables joined to it. About 500 records in the database. The FACT Table has
about 60 columns in it. Most of those columns join back to a lookup table.
Last thing. The first thing I do when this database is launched is to
create a persistent connection using some VBA code. I use the vba command
CurrentDb.OpenRecordset on a table that has one row and one column in it. I
call this VBA code from a startup form.
Any suggestions on how to fix this? Thank you in advance.
Steve