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  1726 
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******@pcdata sheet.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******** *************@o 13g2000cwo.goog legroups.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******** *********@newsr ead2.news.atl.e arthlink.net... --
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.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******** *******@newssvr 23.news.prodigy .net...
"PC Datasheet" <no****@nospam. spam> wrote in message
news:Ks******** *********@newsr ead2.news.atl.e arthlink.net... --
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.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******** *******@newssvr 23.news.prodigy .net...
"PC Datasheet" <no****@nospam. spam> wrote in message
news:Ks******** *********@newsr ead2.news.atl.e arthlink.net... --
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.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******@pcdata sheet.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******** *******@newssvr 23.news.prodigy .net...
"PC Datasheet" <no****@nospam. spam> wrote in message
news:Ks******** *********@newsr ead2.news.atl.e arthlink.net... --
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.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******@pcdata sheet.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******** ******@newssvr2 3.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******** *******@newssvr 23.news.prodigy .net... >
> "PC Datasheet" <no****@nospam. spam> wrote in message
> news:Ks******** *********@newsr ead2.news.atl.e arthlink.net...
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> re******@pcdata sheet.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******@pcdata sheet.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******** ******@newssvr2 3.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******** *******@newssvr 23.news.prodigy .net... >
> "PC Datasheet" <no****@nospam. spam> wrote in message
> news:Ks******** *********@newsr ead2.news.atl.e arthlink.net...
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> re******@pcdata sheet.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******** ********@newsre ad2.news.atl.ea rthlink.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 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 in the same install folder, I get
errors and no way to reconnect the front and back end on the foreign computer.
Is there something in the developer package that allows this to happen, that
I'm not loading with the program and setup files?
...
|
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
strFilter = ahtAddFilterItem(strFilter, _
"Access Database(*.mdb;*.mda;*.mde;*.mdw) ", _
"*.mdb; *.mda; *.mde; *.mdw")
|
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>
But I am curious about what techniques those of you who have done higher
volume access implementations use to ensure high performance of the
database in a multi-user 100mbps LAN implementation???
Thanks
|
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 than 10 users. I'd like
each user to see only some of the records in the database. So for
example, if I have eight users in eight countries, I want each of them
to only see information for their country.
I was told that the easiest way to do...
|
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 separate
front-end and back-end, which is rather surprising considering that all
Access databases should be split into a separate front-end and back-end.
Noticing that there are quite a lot of questions on this subject in the
Access newsgroups...
| | |
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) can be done without having to manage the porting of the data.
Multiple users are less of an issue if the data is stored in a BE database. It's even possible (many developers prefer this in fact) to release the FE database to each user as a local db....
|
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 to prevent random people from accessing the .be file and/or tables? or by creating security on the .be, will it give me problems with running queries on the front end?
Can anyone help?
Thanks,
Matt
|
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 update all of these back-end databases for the release of a new front-end version.
when I try this:
DoCmd.TransferDatabase acLink, "Microsoft Access", Text1.Value, acTable, "Analyses", "Analyses"
CurrentDb().Execute "ALTER TABLE analyses ADD...
|
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 form name 'Switchboard' is misspelled or refers to a form that doesn't exist."
The switchboard is still intact because I can access it from the Switchboard Manager if I open the database with <shift>double-click, but I don't know how to get the front...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
