Error 'Not a valid file name'

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

Ihave made some changes to a database that I created, I
had someone else test it and when they click to go to a
form for data entry a message pops up 'Not a valid file
name'. I can access the same forms with no problems its
just the other users.

Thanks,
Annette
 
It sounds like you may have linked tables in your
database. If you link to a table that is in a database on
your hard drive, and then send the front end to someone
else, they will not be able to access the information
that is in that linked table. If the form used the linked
table, that is the error message that you would get.

You have a few options:

1. You could put the database that contains the table
being linked to in a network location accessible by both
you and the person you are sending the database to, and
use the link table wizard to update the path to the
linked table.

2. You could send the recipient both database, making
sure that he/she saves them to the exact same path that
you have them saved on your system. (For example, if you
have the database saved in c:\databases\sample database,
have the recipient create a folders on their drive using
the same path.

3. Delete the linked table in the database, and use the
import wizard to import the table instead.

If a network is available I recomend using the first
option, as it is the most reliable.
 
Back
Top