Re: An Interesting Occurance w/Access 2003
- From: "DFS" <nospam@xxxxxxxx>
- Date: Wed, 13 Feb 2008 00:09:40 -0500
Also interesting would be the occurrence of some paragraphs.
Donald Calloway wrote:
I have an application with a number of tables, one of which I named,
Calls, which holds information relating to telephone calls. Anyway,
making a copy of the database file, then making a number of
modifications to it, I deleted all of the records in the Calls table
of the modified database, renamed the table to Calls2, and then
proceeded to copy and paste the Calls table from the original
database to the upgraded database. Of course, the upgraded database
now contains two tables of the same design: A blank Calls2 table and
a Calls table, a copy of the table from the original database
containing all of the original data. There is a data entry form in
the original database which uses the Calls table as the record
source. Naturally, the upgraded database also contains the form
which uses the Calls table as the record source. When I opened the
upgraded database, I received an error whenever I clicked on a
switchboard option which opens the data entry form in edit mode. A
microsoft error dialog box said the form's record source could not be
located or accessed. This occurred, mind you, even though the record
source property of the form was the Calls table, and there is a table
by the name of Calls in the database. I scratched my head and
wondered, why doesn't the form recognize the blasted Calls table
since the table is right there in the database? Anyway, what I tried
and and it worked was, I had to go to the form's properties, click on
the record source property combo box and select another table as the
record source temporarily, then reselect the Calls table as the
form's record source. Somehow, the Calls table had to be
reestablished as the form's record source after the copy and paste
was done even though the names were identical. Has anyone else ever
come across this before?
.
- Follow-Ups:
- Re: An Interesting Occurance w/Access 2003
- From: Donald Calloway
- Re: An Interesting Occurance w/Access 2003
- References:
- An Interesting Occurance w/Access 2003
- From: Donald Calloway
- An Interesting Occurance w/Access 2003
- Prev by Date: Re: preventing user to access/see/import/linking tables
- Next by Date: report repeats himself three times
- Previous by thread: Re: An Interesting Occurance w/Access 2003
- Next by thread: Re: An Interesting Occurance w/Access 2003
- Index(es):
Relevant Pages
|
