J
Joe Bohen
I have two linked Dbase 1V tables in my database, which
are generated by a third party programme; these are
located in on my PC in my documents. A procedure then
pulls records from these tables if records exist for a
given period. The date range is entered into start_date
and end_date text boxes, I use dcount (i.e. If DCount
("*", "qrymoney_in") < 1 Then) to check whether there are
any records for the given period, if there are a subform
is populated if not a message box informs the operator
that there are no records for the chosen period. I
constructed this database on my laptop and used sample
dbase tables copied to my documents to check it out and it
works exactly as I expected. However when the database was
placed onto a client machine on the office network, when
dcount is called by the procedure an error suggests that
the dbase cannot be locked or the table is in use by
another process. The client machine is operating on
windows 98 my laptop is on windows pro. I tried the
database on a windows 2003 box and this works without a
hitch. Why does this work on one operating system and not
another.
Thanks in antcipation
Joe
are generated by a third party programme; these are
located in on my PC in my documents. A procedure then
pulls records from these tables if records exist for a
given period. The date range is entered into start_date
and end_date text boxes, I use dcount (i.e. If DCount
("*", "qrymoney_in") < 1 Then) to check whether there are
any records for the given period, if there are a subform
is populated if not a message box informs the operator
that there are no records for the chosen period. I
constructed this database on my laptop and used sample
dbase tables copied to my documents to check it out and it
works exactly as I expected. However when the database was
placed onto a client machine on the office network, when
dcount is called by the procedure an error suggests that
the dbase cannot be locked or the table is in use by
another process. The client machine is operating on
windows 98 my laptop is on windows pro. I tried the
database on a windows 2003 box and this works without a
hitch. Why does this work on one operating system and not
another.
Thanks in antcipation
Joe