By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

in front end application and back end tables

P: n/a
Hey,

I want to build a database which has an in front end application and
back end tables. I am new to access, and all my knowledge is from
Access for Dummies. Could any one give me a clue where to find
information regarding this topic? should I use macro to set up in front
end application or I could get it down by the GUI. I have a big book
"Running Access for Window 95" by hands, but not sure which chapter
will solve my problem. Any comments are well comes.

Thank you very much!
Min

Nov 23 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
El
Here's what I would do: Go to Tools, Database Utilities, Database
Splitter and follow the instructions. Hope this helps!

Nov 23 '05 #2

P: n/a
Start by opening a blank Access file and enter all your tables and all the
relationships. When this is completed, you have your backend application.
Save this file. Now open a new blank Access file and go to Tables in the
database window. Click on File - Get External Data - Link Tables in the menu
at the top of the screen. Navigate to your backend file and select it. Click
Link. Click Select All. Click OK. You have now linked to all the tables in
the backend file. You will see in the list of tables an arrow on the left of
each table name indicating it is a linked table. When this is completed, you
have your frontend file. You can save it or start creating your queries
forms and reports and then save it.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

"Mindy" <ma************@yahoo.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hey,

I want to build a database which has an in front end application and
back end tables. I am new to access, and all my knowledge is from
Access for Dummies. Could any one give me a clue where to find
information regarding this topic? should I use macro to set up in front
end application or I could get it down by the GUI. I have a big book
"Running Access for Window 95" by hands, but not sure which chapter
will solve my problem. Any comments are well comes.

Thank you very much!
Min

Nov 23 '05 #3

P: n/a

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Ks*****************@newsread2.news.atl.earthl ink.net...
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


A quick note to anyone reading this message thread. This newsgroup is an
excellent resource for getting help with your Access projects. If you feel
the need, however, to seek professional help, I strongly advise that you not
consider hiring this PC Datasheet character. Steve is a bright kid but is
totally unprofessional. There are literally hundreds of competent Access
consultants available. Many post regularly in this newsgroup, others can
easily be located by googling or visiting guru.com.

Nov 23 '05 #4

P: n/a

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:cV***************@newssvr23.news.prodigy.net. ..

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Ks*****************@newsread2.news.atl.earthl ink.net...
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


A quick note to anyone reading this message thread. This newsgroup is an
excellent resource for getting help with your Access projects. If you
feel
the need, however, to seek professional help, I strongly advise that you
not
consider hiring this PC Datasheet character. Steve is a bright kid but is
totally unprofessional. There are literally hundreds of competent Access
consultants available. Many post regularly in this newsgroup, others can
easily be located by googling or visiting guru.com.


Hey Randy-- Mind your own business and go fuck yourself.
Nov 23 '05 #5

P: n/a

"XMVP" <ac***********@hotmail.com> wrote in message
news:OY******************************@vnet-inc.com...

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:cV***************@newssvr23.news.prodigy.net. ..

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Ks*****************@newsread2.news.atl.earthl ink.net...
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


A quick note to anyone reading this message thread. This newsgroup is an excellent resource for getting help with your Access projects. If you
feel
the need, however, to seek professional help, I strongly advise that you
not
consider hiring this PC Datasheet character. Steve is a bright kid but is totally unprofessional. There are literally hundreds of competent Access consultants available. Many post regularly in this newsgroup, others can easily be located by googling or visiting guru.com.


Hey Randy-- Mind your own business and go fuck yourself.


I'll take that as one vote for no objection to advertising in CDMA.
Nov 23 '05 #6

P: n/a
Don,

I abhor what you did to Davis F and personally request you never do it
again. However, I applaud your stance here!!! It's time for some people to
start telling Arno R, John Marshall, Keith Wilby and Randy Harris and all
their supporters that they are not the champions of the newsgroups and that
they are damaging the newsgroups severely. Thank you, but please nothing
more about David F.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!



"XMVP" <ac***********@hotmail.com> wrote in message
news:OY******************************@vnet-inc.com...

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:cV***************@newssvr23.news.prodigy.net. ..

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Ks*****************@newsread2.news.atl.earthl ink.net...
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


A quick note to anyone reading this message thread. This newsgroup is an
excellent resource for getting help with your Access projects. If you
feel
the need, however, to seek professional help, I strongly advise that you
not
consider hiring this PC Datasheet character. Steve is a bright kid but
is
totally unprofessional. There are literally hundreds of competent Access
consultants available. Many post regularly in this newsgroup, others can
easily be located by googling or visiting guru.com.


Hey Randy-- Mind your own business and go fuck yourself.

Nov 23 '05 #7

P: n/a
You take that totally wrong!!! It's one vote for you to go fuck
yourself!!!!!! And I will make it two votes.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!



"Randy Harris" <ra***@SpamFree.com> wrote in message
news:Po**************@newssvr23.news.prodigy.net.. .

"XMVP" <ac***********@hotmail.com> wrote in message
news:OY******************************@vnet-inc.com...

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:cV***************@newssvr23.news.prodigy.net. ..
>
> "PC Datasheet" <no****@nospam.spam> wrote in message
> news:Ks*****************@newsread2.news.atl.earthl ink.net...
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> re******@pcdatasheet.com
>> www.pcdatasheet.com
>>
>
> A quick note to anyone reading this message thread. This newsgroup is an > excellent resource for getting help with your Access projects. If you
> feel
> the need, however, to seek professional help, I strongly advise that
> you
> not
> consider hiring this PC Datasheet character. Steve is a bright kid but is > totally unprofessional. There are literally hundreds of competent Access > consultants available. Many post regularly in this newsgroup, others can > easily be located by googling or visiting guru.com.
>


Hey Randy-- Mind your own business and go fuck yourself.


I'll take that as one vote for no objection to advertising in CDMA.

Nov 23 '05 #8

P: n/a
And by the way ----
A class act past contributor to the newsgroups emailed me not too long ago
and said he quit participating in the newsgroups because "he was tired
dancing with the pigs". You're one of the pigs he was talking about!!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


"Randy Harris" <ra***@SpamFree.com> wrote in message
news:Po**************@newssvr23.news.prodigy.net.. .

"XMVP" <ac***********@hotmail.com> wrote in message
news:OY******************************@vnet-inc.com...

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:cV***************@newssvr23.news.prodigy.net. ..
>
> "PC Datasheet" <no****@nospam.spam> wrote in message
> news:Ks*****************@newsread2.news.atl.earthl ink.net...
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> re******@pcdatasheet.com
>> www.pcdatasheet.com
>>
>
> A quick note to anyone reading this message thread. This newsgroup is an > excellent resource for getting help with your Access projects. If you
> feel
> the need, however, to seek professional help, I strongly advise that
> you
> not
> consider hiring this PC Datasheet character. Steve is a bright kid but is > totally unprofessional. There are literally hundreds of competent Access > consultants available. Many post regularly in this newsgroup, others can > easily be located by googling or visiting guru.com.
>


Hey Randy-- Mind your own business and go fuck yourself.


I'll take that as one vote for no objection to advertising in CDMA.

Nov 23 '05 #9

P: n/a
Who is this class act and why did he not try and do something about it?
Or is he one of your 1,000 who are always leaping to your defence?

John... Visio MVP

"PC Datasheet" <no****@nospam.spam> wrote in message
news:05****************@newsread2.news.atl.earthli nk.net...
And by the way ----
A class act past contributor to the newsgroups emailed me not too long ago
and said he quit participating in the newsgroups because "he was tired
dancing with the pigs". You're one of the pigs he was talking about!!!!

PC Datasheet

Nov 23 '05 #10

P: n/a
You are a class act steve, promoting physical violence against a member of
this community. It is too bad we can not vote you off the island.

John... Visio MVP
"PC Datasheet" <no****@nospam.spam> wrote in message
news:m1***************@newsread3.news.atl.earthlin k.net...
You take that totally wrong!!! It's one vote for you to go fuck
yourself!!!!!! And I will make it two votes.

Nov 23 '05 #11

P: n/a
Thanks. :)

Nov 23 '05 #12

P: n/a
Thanks. :)
PC Datasheet wrote:
Start by opening a blank Access file and enter all your tables and all the
relationships. When this is completed, you have your backend application.
Save this file. Now open a new blank Access file and go to Tables in the
database window. Click on File - Get External Data - Link Tables in the menu
at the top of the screen. Navigate to your backend file and select it. Click
Link. Click Select All. Click OK. You have now linked to all the tables in
the backend file. You will see in the list of tables an arrow on the left of
each table name indicating it is a linked table. When this is completed, you
have your frontend file. You can save it or start creating your queries
forms and reports and then save it.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

"Mindy" <ma************@yahoo.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hey,

I want to build a database which has an in front end application and
back end tables. I am new to access, and all my knowledge is from
Access for Dummies. Could any one give me a clue where to find
information regarding this topic? should I use macro to set up in front
end application or I could get it down by the GUI. I have a big book
"Running Access for Window 95" by hands, but not sure which chapter
will solve my problem. Any comments are well comes.

Thank you very much!
Min


Nov 23 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.