An Interesting Occurance w/Access 2003
- From: Donald Calloway <drcalloway@xxxxxxxxxxx>
- Date: Wed, 13 Feb 2008 03:32:35 GMT
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: DFS
- Re: An Interesting Occurance w/Access 2003
- From: Tom van Stiphout
- Re: An Interesting Occurance w/Access 2003
- Prev by Date: Re: How To Find Next Autonumber Value
- Next by Date: Re: An Interesting Occurance w/Access 2003
- Previous by thread: Access 2007 navigation pane (with Access runtime)
- Next by thread: Re: An Interesting Occurance w/Access 2003
- Index(es):
Relevant Pages
|
