multi users - corrupting database

[Fiona]

HI,

Let me apologise now for the length of this post. I have
designed a pretty basic database to record the results of
a survey. So far it is ready of data entry and I have
filed it on a network drive so that users can enter it
from their own pc -simple right? BUT, when they do, they
can open the db but cannot open the form to enter the
results - the following error message comes up.

The Microsoft Jet database engine cannot find the input
table or quesry 'SELECT [AddressTable].[ID],
[AddressTable].[Last], [AddressTable].[First],
[AddressTable].[BusinessAddress], [AddressTable].[City],
[AddressTable].[State], [AddressTable].[ZipCode],
[MainResponseTable].[MainResponseID], [MainResponseTable].
[Facility Name]'. Make sure it exists and that its name is
spelled correctly.

This would imply to me that it cannot find something to
open up the form but I can open it from my pc direct from
the Network Drive (so why can't they)!! This is confusing
me greatly. It did work before but then decided not to
work after my pc crashed. I used the back up to try to
get rid of any corruption but still this mystery
continues. Can anyone help me?

Thanks in advance.

 

[Byron]

The sql statement does not look to be correct. Do you
know if this statement is comming from the Row Source of
the form or is it an actually query?

In either case try building a query that will return the
record set with the fields you are needing and then
replace the existing sql statement with the one that you
create while defining the query. When the query is
created, just go to the SQL view of the query and you
will see the statement.

HTH

Byron

 

[Guest]

-----Original Message-----
HI,

Let me apologise now for the length of this post. I have
designed a pretty basic database to record the results of
a survey. So far it is ready of data entry and I have
filed it on a network drive so that users can enter it
from their own pc -simple right? BUT, when they do, they
can open the db but cannot open the form to enter the
results - the following error message comes up.

The Microsoft Jet database engine cannot find the input
table or quesry 'SELECT [AddressTable].[ID],
[AddressTable].[Last], [AddressTable].[First],
[AddressTable].[BusinessAddress], [AddressTable].[City],
[AddressTable].[State], [AddressTable].[ZipCode],
[MainResponseTable].[MainResponseID], [MainResponseTable].
[Facility Name]'. Make sure it exists and that its name is
spelled correctly.

This would imply to me that it cannot find something to
open up the form but I can open it from my pc direct from
the Network Drive (so why can't they)!! This is confusing
me greatly. It did work before but then decided not to
work after my pc crashed. I used the back up to try to
get rid of any corruption but still this mystery
continues. Can anyone help me?

Thanks in advance.
.

 

[Dale Tillock]

-----Original Message-----
HI,

Let me apologise now for the length of this post. I have
designed a pretty basic database to record the results of
a survey. So far it is ready of data entry and I have
filed it on a network drive so that users can enter it
from their own pc -simple right? BUT, when they do, they
can open the db but cannot open the form to enter the
results - the following error message comes up.

The Microsoft Jet database engine cannot find the input
table or quesry 'SELECT [AddressTable].[ID],
[AddressTable].[Last], [AddressTable].[First],
[AddressTable].[BusinessAddress], [AddressTable].[City],
[AddressTable].[State], [AddressTable].[ZipCode],
[MainResponseTable].[MainResponseID], [MainResponseTable].
[Facility Name]'. Make sure it exists and that its name is
spelled correctly.

This would imply to me that it cannot find something to
open up the form but I can open it from my pc direct from
the Network Drive (so why can't they)!! This is confusing
me greatly. It did work before but then decided not to
work after my pc crashed. I used the back up to try to
get rid of any corruption but still this mystery
continues. Can anyone help me?

Thanks in advance.
.