What is easiest way to update BE linked table using forms?

  • Thread starter Thread starter New to Access
  • Start date Start date
N

New to Access

I am very new to this, so this may be the stupid question of the day
but I've searched and can't quite find the answer I'm looking for

1. I created a table and a form, then in order for two of us t
utilize the form to populate the table, I split the database, wit
the table on the back-end and the form linked to the table.
Problem is, if we're both in the form at the same time, we get
message upon saving that says - can't save because another user ha
the file open. Instead, it looks like I should be updating the tabl
via Tools, Database Utilities, Linked Table Manager, select table t
be updated. Is this really the only way to update the back-en
table, or am I missing something

2. Also, can I have the table and form both located on the server fo
easier access (this way I can VPN from my home PC) or must the form b
on my hard drive

Thanks
 
I split the database, with
the table on the back-end and the form linked to the table.
Click to expand...

presumably you mean that your BE table is linked to the FE database? if not,
it should be. simply open the FE database, click on File | Get External Data
| Link, navigate to the BE db on the server (recommend you navigate via
Network Neighborhood rather than via a mapped drive), select the tables to
link, and click OK. this should be done *before* the FE db is deployed for
use.

for the purposes of data entry in forms, Access treats linked tables just
like native tables; so you should be able to bind your form to the linked
table or to a query based on the linked table - just as if it were a native
table in the FE.

usually a copy of the FE db is placed on each user's computer. you can
accomplish nearly the same thing by placing a separate copy of the FE on the
server *for each user*. the goal here is that two users never open the same
FE file at the same time. the disadvantage to putting FE dbs on the server
is that all objects have to be pulled across the data lines to the user's
computer, rather than just the data itself.

hth
 
Back
Top