karatelung
Registered User.
- Local time
- Today, 18:55
- Joined
- Apr 5, 2001
- Messages
- 84
I have a stripped down version of our DB (front-end and back-end) on a notebook computer so that certain people out of the office can enter info. I did have the VPN set up with the tables linked to our back-end, but the notebooks connect via analog dial-up. it works, but it's just way too slow.
So I'm just having them enter the info into on the stripped down version with the tables on the notebook. Then the new records will be appended. Here's my problem. I want an append query that will only append the records to the back-end DB where [autonumber] is greater than [autonumber] on our server. The table name is the same on both the notebook and server - tblOnCallEntry.
I don't know how to reference the [autonumber] field on the server. The drive is mapped, so I tried this as the criteria for [autonumber] on the notebook:
> e:\HFKDB_be.mdb.[tblOnCallEntry].[AutoNumber]
it didn't work. Does anyone have any ideas?
Thanks
So I'm just having them enter the info into on the stripped down version with the tables on the notebook. Then the new records will be appended. Here's my problem. I want an append query that will only append the records to the back-end DB where [autonumber] is greater than [autonumber] on our server. The table name is the same on both the notebook and server - tblOnCallEntry.
I don't know how to reference the [autonumber] field on the server. The drive is mapped, so I tried this as the criteria for [autonumber] on the notebook:
> e:\HFKDB_be.mdb.[tblOnCallEntry].[AutoNumber]
it didn't work. Does anyone have any ideas?
Thanks