Acces Pack And Go

Oct 2, 2006

I am looking for a way to export my database and all linked files into one folder with automatic updated links. I would like to transfer the complete project to an other computer. Is this possible? How to do? Thank you.

View Replies


ADVERTISEMENT

Pack Application

Aug 14, 2005

hi.. i've developed an application in access... and i want to distribute it to some of my collegues who doesnt have an access installed in it.. can anyone please help me in doing this.. i know about runtime.. but i wanna pack my application in disks or cd...

thanks
azzy

View 2 Replies View Related

How Can I Pack My Access Application

Aug 5, 2005

I have done my access application. I will give it to my friends to use but dont want them to modify my program. So, plz help me to lock the design view(like some access application) so every using my program can't access it to modify.

Or who can tell me the way to hide everything in design view. Just show the interface. Eventhough when user hold "Shift" button while openning but still cant view a design view part.

I'm not goood at security in Access. Plz help me to show this problem.
Thank you everyone.
:)

View 3 Replies View Related

WindowsNT 4.0 Service Pack 6 Error In Access Runtime Install

Aug 28, 2005

WindowsNT 4.0 Service Pack 6 error in access runtime install
I have an access runtime install package that has worked numerous times
installing on XP Home. It was built using Office XP developer's packaging
wizard.

I tried installing it on a brand new PC running XP Home but it generates the
error:
Visual Basic 6.0 Setup Toolkit
The office system pack cannot be installed on this system because it
requires Windows NT 4.0 Service Pack 6 or later.

I cannot find any info on this - any ideas?

View 2 Replies View Related

Acces Or MySQL

Oct 16, 2006

Which is better fo running a website which is small?

MySQL or Access?

Sathu

View 1 Replies View Related

Acces Hide Field Value

May 10, 2005

Hi i've got a table with a couple of fields

What's in the fields is irrelevant but i'd like to
change that to *****
the original value should stay there
but when you view the record it should only give *****

for example

field value : HELLO
when viewed: *******

Does anyone know how this could be done I ones knew how it was done but can't find it anymore

plz help

View 3 Replies View Related

Every Acces Screen Has Its One Toolbar Btn

Dec 21, 2005

I only want the active screen on the toolbar. and all other screens like the DB screen and forms that are not active to be hidden on the toolbar.

I hope you can understand it. else i wil make a screendump of what i want.

View 1 Replies View Related

Pictures/PHotos In MS Acces

Jun 25, 2007

I'm not brilliant at using MS Access - can't use the VBA codes or anything like that.

basically, I want to set up a database of photogrpahs where you store thephotograph in Access, and then run a query to search for specific photos, which brings up a form showing the picture.

I seem to be OK at doing all of this so far except I can't get the photo to appear in the form - it just displays a link which you double click on to get to the photo.

I've tried to look up how to sort this on the web but don't understand the way people speak about access :confused:

can anyone help???

View 12 Replies View Related

Finished Acces Db. How Should I Set Up For Users?

Feb 28, 2008

I have completed a db and am satisfied with the structure and forms. The object window is hidden when the database is opened, and the main entry form automatically opens for the user. This db will be in a network folder and several users will have access to it. I want people to be able to enter data and run reports, but not make any changes to the database itself, or accidentally delete the database file or some other change to the structure. What is the proper way to set up the folder rights and anything else associated with the previous question?

Thanks.

View 1 Replies View Related

SQL Pass Through Query/ms Acces To Oracle

Jun 3, 2005

I'm getting an error (SQL command not properly ended) but main thing is, I can't get it to recognize the ms access db.
In a nutshell...I want to query the oracle db for a number and count, then scan a number into msaccess and have it 'find' the matching number in oracle and return the count only to ms access. More comments below between the code and here are table names for both oracle and access:
ORACLE: Table name is: batch_status bs
Field names are: batch_num and Batch size

MS ACCESS: Table name is tblbatchstatus
Field names are: batchnum and idcount

CODE in PASSTHROUGH QUERY:
select batch_num,BATCH_SIZE
from batch_status bs
(this works and selects all batch numbers and sizes from oracle)
(If I say 'where batch_num = 60024 -----this works also....)
However...when I add the below part...I get errors...it can't seem to match to access database....


SELECT tblbatchstatus.Batchnum, tblbatchstatus.Idcount
FROM tblbatchstatus;

where batch_num = tblbatchstatus.batchnum

And I want to just say: where batch_num = <<<scanned batch number>>> and return the id count.

View 1 Replies View Related

How Do You Create Acces Data Pages For Update

Jan 22, 2006

I am a first time user of access. i am trying to create an Data Access Page which will list all entries in a table and then allow me to add, change and delete them. I have created the page using the wizard but it will not let me add, delete or update. i view all the entries at one time but that is all. the navigation toolbar shows up at the bottom but it is grayed out. any ideas on what i may be doing wrong?


thanks
brian

View 5 Replies View Related

Selective Data Acces Depending On Login

Jan 11, 2006

I have a two level security system to protect my date. The first uses the MS Access security, the second is a simple login system wherby a user enters their name and personal password to gain a customised view of the data eg if the user is me, I can see all tool bars, other users cannot. What I would like to be able to do is write a query wherby I can use the users login details to diplay only their data. An example of the script I built is as follows

'IF USERNAME AND PASSWORDS CORRECT THEN LOGIN TO THE MAIN SWITCHBOARD

If Me.qpwd.Value = DLookup("PWD", "AUTHORISED", "USERID = '" & Me.quserid.Value & " '") Or UCase$(Me.qpwd.Value) = "abcd" Then
DoCmd.Close
DoCmd.OpenForm "Course Booking System"
Else
MsgBox "Invalid Password"
End If

Is there a way of including a select criteria like the following

SELECT USERID, DETAIL
FROM COURSE
WHERE USERID="Me.qpwd.Value"

I have tried several differnet versions for this syntax without success!

Any help would be greatly appreciated.

Regards

Peter

View 3 Replies View Related

Handling Filter In A Ms Acces(2000) Forms

Oct 19, 2006

hi,

i am currently dealing with a form which does not show data after it has been opened.

it shows the data after removing the filters from the form when it is opened.

in fact the filters are set to false

Me.FilterOn = False.

so kindly help me out from this problem

thanking you

View 3 Replies View Related

DateDiff Function - It Doesn't Work In Some Version Of Acces ?

Apr 11, 2008

Hi All

I've created a database where a query who'se result is loaded on a form uses following function --

DateDiff('d',Date(),[Target Date])-(DateDiff('ww',Date(),[Target Date])*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between Date() and [Target Date])


I've notice that 2 ppl get an error message when they try to open database, with thatt function coming on an error message
Does this mean they have older access version ?
How can I tell ? Any advise on what to do ?

View 2 Replies View Related

Populating A Listbox In Excel With A Growing Table In Acces... Uhh...

Oct 13, 2004

So here's my problem. I'm trying to update a listbox in excel with values that are being pushed in a table in access. The problem is that there are repeated values in the column in access, but I only want to show each value once, regardless of how many times it appears in the table. I would give a code sample but I'm having trouble getting started...

Any help is appreciated.

--patrick-->

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved