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 12 1698
Here's what I would do: Go to Tools, Database Utilities, Database
Splitter and follow the instructions. Hope this helps!
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
"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.
"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.
"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.
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.
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.
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.
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
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Lumpierbritches |
last post by:
Thank you for your assistance in advance. I'm trying to figure out why on my
computer the front and back ends are ok, when I use Access developer and set up
the program with the front and back ends...
|
by: Lumpierbritches |
last post by:
I took everyone that posted to this advice, however I get an error here in the
code:
Function fGetMDBName(strIn As String) As String
'Calls GetOpenFileName dialog
Dim strFilter As String
...
|
by: Bob Alston |
last post by:
Most of my Access database implementations have been fairly small in
terms of data volume and number of concurrent users. So far I haven't
had performance issues to worry about. <knock on wood>
...
|
by: Julia |
last post by:
Hello there.
I have a question somewhat related to this topic, and I don't know
where else to go. I hope somebody can help. I've created a database
in access, that I'd like to share with less...
|
by: Stephen Poley |
last post by:
Whenever anyone has a question about securing an Access database he/she
is usually referred (unsurprisingly) to the Security FAQ. This is
however incomplete/unclear with respect to databases with a...
|
by: NeoPa |
last post by:
The concept of FE/BE is to separate the code and control parts of a database solution from the design and storage of the data.
Benefits include :
Releasing new versions of the code / control (FE)...
|
by: Supermansteel |
last post by:
I created an Access Database and added the Security thru the Securtiy wizard. Then Split the database into the fe and be files, however, the security did not stay with the .be file. Is there a way...
|
by: swethak |
last post by:
Hi,
How to do the bring front and bring back an images using javascript.
|
by: Stijnele |
last post by:
Hello,
I've got a Split database, where there a lot of back-end databases. There is one Backend-database for each customer. And there is also only one back-end linked at a time.
Now I want to...
|
by: sueb |
last post by:
In my front end, I removed a form named simply "Switchboard", thinking it was left over from an early attempt to make my own switchboard. As a result, opening my database gives me the error "The...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |