Access Newbie here.

I created a simple little Contacts database and emailed it to my data entry
person who is in another city.

She has already entered quite a few records.

Now I would like to add a couple of new fields to the form.

Whats the best way to do that?

Is it possible for me to email her the new form and she can import it into
her database?

James

The database should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). In that way, anytime you need to make an
application change such as what you're describing, you simply have to give
her a new copy of the front-end.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"James Ivey" <(E-Mail Removed)> wrote in message
news:uSr%(E-Mail Removed)...
> Access Newbie here.
>
> I created a simple little Contacts database and emailed it to my data
> entry person who is in another city.
>
> She has already entered quite a few records.
>
> Now I would like to add a couple of new fields to the form.
>
> Whats the best way to do that?
>
> Is it possible for me to email her the new form and she can import it into
> her database?
>
> James
>

ummmmm.... ok )

Thanks for the reply Doug, but that one went over my head. Can you be a
little more specific on what you are describing? How exactly do I "split"
the database?

I appreciate your help.

James


"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:uv%(E-Mail Removed)...
> The database should be split into a front-end (containing the queries,
> forms, reports, macros and modules), linked to a back-end (containing the
> tables and relationships). In that way, anytime you need to make an
> application change such as what you're describing, you simply have to give
> her a new copy of the front-end.
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "James Ivey" <(E-Mail Removed)> wrote in message
> news:uSr%(E-Mail Removed)...
>> Access Newbie here.
>>
>> I created a simple little Contacts database and emailed it to my data
>> entry person who is in another city.
>>
>> She has already entered quite a few records.
>>
>> Now I would like to add a couple of new fields to the form.
>>
>> Whats the best way to do that?
>>
>> Is it possible for me to email her the new form and she can import it
>> into her database?
>>
>> James
>>
>
>

There's a built-in Database Splitter, but it's easy enough to do manually.
Take a look at what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"James Ivey" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> ummmmm.... ok )
>
> Thanks for the reply Doug, but that one went over my head. Can you be a
> little more specific on what you are describing? How exactly do I "split"
> the database?
>
> I appreciate your help.
>
> James
>
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
> news:uv%(E-Mail Removed)...
>> The database should be split into a front-end (containing the queries,
>> forms, reports, macros and modules), linked to a back-end (containing the
>> tables and relationships). In that way, anytime you need to make an
>> application change such as what you're describing, you simply have to
>> give her a new copy of the front-end.
>>
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "James Ivey" <(E-Mail Removed)> wrote in message
>> news:uSr%(E-Mail Removed)...
>>> Access Newbie here.
>>>
>>> I created a simple little Contacts database and emailed it to my data
>>> entry person who is in another city.
>>>
>>> She has already entered quite a few records.
>>>
>>> Now I would like to add a couple of new fields to the form.
>>>
>>> Whats the best way to do that?
>>>
>>> Is it possible for me to email her the new form and she can import it
>>> into her database?
>>>
>>> James
>>>
>>
>>
>
>