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
12 1729
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******** *******@newsrea d3.news.atl.ear thlink.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******@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 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: 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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |