Child ID Access

Hi..actually i want to create a database on server (in ms access 2007) and forms on clients(using ms access 2007 only) such that whatever i input in the forms at client side gets stored in the database at server side. Also i want that no user on client side could access the database on server. OS is Windows Vista home premium..please help….thanx

"i want that no user on client side could access the database on server" would make sharing the DB impossible, since they need to "access the database" tables to work in the DB (unless You want to script a daily file import/export/update process… not enough room here to explain THAT).

In general though the best way to do this would be to create a "Master DB" with All of the Tables/ Queries/ Forms/ Reports/ etc… Then make a "Front-end" with the Forms/ Queries/ Forms/ Reports/ etc, BUT with LINKS to the "Master DB" Tables rather than actual tables.
Now copies of the "Front-End" can be distributed to individual desktops, and They all read/write to the same tables (on the network).

As for security, You can "lock it down" within Access through the START-UP OPTIONS (See the main tool bar>>TOOLS>>STARTUP…) by turning off the pop-up menus, hiding the DB window, and setting a "STARTUP FORM". But be aware all of this (in fact ALL MS Access security measures) can be bypassed by holding down the "SHIFT" key when You open the DB ("Back-door" for editing).

To make a truly Secure DB You would have to write it in VBA or SQL Server or some other more robust DB application.

I am using one Ms access file (access 2007 accdb file) in my system. the same file i have given it to another section for data entry. every day data entry is being done in that section and i am making reports in my access file. how do i synchronize both file because i need to update data entries from that system and update my new reports to that system. Plz help me how to do that? Network is not available between these systems and things can be done via storage devices only.

If you don’t have a network there are only three options. But many employers will reject all three as a security threat.

1) Set up online storage, so you are all using the same file.
2) Email the file as an attachment to each other, but you may have to zip/unzip it (Email providers don’t like Access files). Overwrite the old file with the updated file.
3) Physically transport the file between locations, using a flash drive. Overwrite the old file with the updated file.

Suggest to your employer that you need a network.

how to cannect a ms access databse with PHP, By this way can it be possible to access this database over internet?
and also can it be used in Appach Server?

you will have to us php’s odbc_* functions

http://php.net/manual/en/book.uodbc.php

It is almost the same as using mysql_connect and all of the mysql functions….

I have a copy of an old MS Access (2003) DB that I was given to update. However, it appears design view is disabled in this version. The DB opens strictly as a form, with no access to edit tables, forms, etc. Is there a way to get into design view to edit it?

First, if the db has a .mde or .ade suffix, you will not be able to make any changes to the db.

If not, hold the shift key while opening the file. It will then take you to the database view. You can then make changes to the db. This is assuming, of course, that the person who worked on the db initially, did not disable the shift function.

I am using MS Access 2007. I want to create a parameter query that searches a linked excel sheet by the Last Name and First Name fields and for the query to display any entries matching the entered names. How do I properly query this information and exactly what expressions should I use? Thanks in advance!

to display ANY entries matching the entered names (either first or last name)
in the first criteria row under Last Name field insert [What is the Last Name]
in the SECOND criteria row under First Name field insert [What is the First Name]
save and execute the query
You will be prompted with those two questions

to display entries matching the entered names (first AND last name)
insert both questions in the first criteria row

I added an input mask to my MS Access database. I found a way to edit it but no way to delete it. Does anyone know how to delete an input mask from the input mask wizard.

Your custom Input Mask’s are saved to the file ACWZUSR.MDT. Mine was located in c:\Documents and Settings\username\Application Data\Microsoft\Access. If you rename this file (ACWZUSR_old.MDT) Access will create a new one the next time it launches and your Input Mask wizard will only have the default masks included. Be advised though – ALL YOUR CUSTOM MASKS WILL BE GONE. This may not be a problem if you only have a few custom masks defined – just make a note of the config for each before you rename the ACWZUSR.MDT file and recreate those after renaming.

I have created a query in MS Access and i was wondering if it was possible for me to view only certain dates. I have two fields called Due date(the date the item should be returned) and date returned( the actual date the item was returned) and i was wondering, could i enter a formula or code that would make the query search and show, only items that where returned after the due date was exceeded. many thanks in advance for your help.

If using the Query Design panel. Drag the [date returned] field on to the grid. Against "Criteria" put
>[due date]

If using SQL, put this clause into the statement:-

WHERE [date returned]>[due date]

This video show the basic steps in connecting a JAVA program to Microsoft Access using the
JDBC-ODBCd bridge..

For more infor, pls visit
http://www.bsitpupt.blogspot.com

Join our groups at facebook.com:
The Computer Society
http://www.facebook.com/group.php?gid=83375209058

Duration : 0:2:11

(more…)

How To Publish Microsoft Access Online In Under 5 Minutes

Duration : 0:3:27

(more…)

Short overview and examples of using the Totals feature to see aggregate data in Microsoft Access.

Duration : 0:3:18

(more…)