I have MS Accesss 2003 on one computer in a local office
network:DSL box
now I want to add 2 users for using the database program.
the computers have firewall and anti-virus (norton)
this is my first time.
how do I allow remote access for the other two computers
to use the database?
database...
I already have the table tblAppTimes
with 2 columns and 41 records.
table tblApptTimes
column1 column2
ATID ATTIME
1 8:00:00 AM
2 8:15:00 AM
3 8:30:00 AM
4 8:45:00 AM
5 9:00:00 AM
. ..........
. ..........
40 5:45:00 PM...
Oh Thanks
it is used as follows:
First it is Global string variable for a path.
right now, I don't have SQL just a MS Access 2003.
and this say sMainOpenSQL, this does not make sense!!
what does the whole thing do? please help.
Global gstrServer As String
Public Sub sMainOpenSQL(cnnDB As...
I would like to know
the following function
why do I need the path backend data?
I already linked front end with backend tables on
MS Access 2003
''''''''''''''''''''''''''''''
Public Function Autoexec()
On Error GoTo Autoexec_Err
DoCmd.RepaintObject
'SetStartupProperties...
so the programmer gave me an improved version database, with tables containing faked data with primary key and so on...
Step 1. rename the tables in the improved version database.
step 2. file-> Get extern data -> link
Q1. do I link to the tables with "non faked" data?
Q2. should I delete the...
tables? yes I have tables
tblmembers - fields: memberID, last, first, phone, address, dob...
this table has about five hundred members,
tblAppt - fields: apptID, ApptDate, ApptTime, memberID,paidYN,ConfirmYN, rescheduleYN
OH, I found it the data are stored in the tblAppt table.
so for MS...
record source is empty with elliptic ...
when I click in the slot of time
another form pop up for selecting name of people
please see attachment
is it ok for record source is empty?http://www.mediafire.com/imageview.php?quickkey=m9i5qxcwbjowqkt&thumb=4
I am new with this stuff.
table store
member's last name, first, phone, address....
I attach an image of the form
top part is: weeks radio button : week1, week2,wk3.. wk6.
left most column is time: 8:00am, 8:15am,8:30am,....,5:00pm
next six columns: monday, tue, ... Saturday
and I schedule...
How do you save forms with data on them?
say, I have an ms access application, and I am using it currently.
it has a form for scheduling gym members to come to practice daily, for five days a week, the form has name of people every 15 minutes scheduling.
now, I pay somebody on the internet to...
Thank MaxieMax
I read up about database corruption etc.. and
Kallal's article.
I have to concern with
1. firewall a little more tricky..
2. corruption of database over wireless network
3. standalone master.
with Sharepoint, solve my firewall issue, and database corruption
Can I put the back...
thank Maxiemax
when I split
will it ask for a network drive for the backend ?
how does it knows? on the laptop?
Later I have a question about autoexec.////
We have a MS Access 2003 with only a single user on laptop.
We paid someone to do it. it worked ok, with minor bugs. They are hard to duplicate but we can live with them.
I read about front end back end stuff here. I can read VBA code but I am not interested in writing new code.
It has been a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.