General :: Network Based Access 2000 DB Won't Open Via Shortcut
May 20, 2013
We have an old Access 2000 db that is used by most of the company. I also have users who use it via a windows 2003 terminal server. I just created a new win 2008 remote desktop server and installed Access 2000 (What a pain that was).
Now from access, if I go to fileopen, navigate to the DB server and open the DB, it works fine. If I create a shortcut to the database on the desktop of the remote server, nothing happens. No error, no warning, no nothing. It's weird.
If I place a copy of the db locally, it opens just fine.I also tried mapping a drive to the db server and then made another shortcut and still nothing. I also created a shortcut and entered the path like this:
"C:Program Files (x86)Microsoft OfficeOfficeMSACCESS.EXE" J:QS XYZ.mdb
But that throws an error that it can't see the database.
View Replies
ADVERTISEMENT
Jun 24, 2005
Hello..
I got the following code from this forum to create shortcut on the desktop..
==================
Set objShell = New WSHShell
Set objShortcut = objShell.CreateShortcut(objShell.SpecialFolders("AllUsersDesktop") & "" & sShortcut)
objShortcut.TargetPath = sDB
objShortcut.WindowStyle = "3"
objShortcut.SAVE
=================
I have Access 2003..but file format is 2000 because others have access 2000.
This code works great on my machine..but getting error on access 2000 machine..It does not recognize "New WSHShell" in the above code.
-------------------error message
Compile Error:
User-defined type not defined
-------------------
Any references needs to be added?
Please help...Thanks..
View 1 Replies
View Related
Nov 3, 2005
Hi.
I was wondering if any of you have had experience firsthand or knew of reasons why an Access 97 database should not be installed on a WIndows 2000 network?
Russ
View 3 Replies
View Related
Mar 26, 2006
I am having problems with a database that is on a network. When I update it, the computers that have a shortcut on their computer to this database does not get the updates. How can I make sure that my updates are also on the computers with the shortcuts.
Thanks
View 2 Replies
View Related
Dec 17, 2007
Running 2007. In 2003, to make a shortcut for an object, all I had to do is right click and place the short cut where i wanted.
I can't seem to find anyway to do it in 2007
Anybody have any clues?
View 3 Replies
View Related
Oct 24, 2007
We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message.
"Microsoft Access cannot open this File
This file is located outside your intranet or
on an untrusted site. Microsoft Access will not
open the file due to potential security problems.
To open the file copy it to your machine or an
accessible network location."
Do not understand why all the coputers cannot open the same access database file. Please Help Regards Keith
View 12 Replies
View Related
Dec 10, 2014
I am building a db and i want to disable the Shortcut Menu (pull down menu at form's title bar) to prevent the users from closing the main form.
There is a Disable Shortcut menu setting in the File/Options menu but the whole db gets the setting.
I simply want to deny the users from accessing the Shortcut Menu when on the Main Menu (or a particular form) but allow it on other forms where Printing is required via the Shortcut Menu.
Im looking at 2 options; edit the shortcut menu or force a form to disable that w/o affecting other forms.
View 3 Replies
View Related
Apr 21, 2005
I greatly appreciate your help on 2 issues:
1/ At work, I have Access 2000 application residing on a Novel server for multiusers purpose. Everyday, occasionally, the application is locked out by whoever opens first (I think?). Some of other users could not open it since it has the message like "locked out by a particular (computer name)...". Therefore the user of that computer name needs to close the application so others can open it. This issue is not happen in Access 97 as we used that version before and it is not consistent happening, so I could not find the pattern or know why?? Please let me know if you have seen this problem and how to prevent it...
2/ Do we have a way to trigger or initiate GroupWise email inside an Access 2000 application. For example, if a purchase order is created in Access 2000 application, I want to email a co-worker...OR it can be automatically sent an email to my supervisor for notifying the purchase order so he can approve it?
Thanks so much in advance for all the helps...
Access2k
View 1 Replies
View Related
Nov 4, 2014
I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.
Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.
I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?
View 2 Replies
View Related
Jun 10, 2012
Some of my users have laptops and usually at work finish, they remove their laptops. The issue occurs when they restart their laptops again without network access and then they have some dialog boxes showing below messages:
"Your network access was interrupted and you should close MS access and restart."
When OK is pressed, some other messages like " Object invalid or not set" appears and by pressing many time OK, it does not reset. Last option is to use "Ctrl+Alt+Del".
View 5 Replies
View Related
Jun 13, 2013
I have a small Access DB (multi-user) on a network that keeps turning into a read-only DB, with a message bar saying please save as . . . and it will not let you complete that. It seems to lock the application, and when I can get everyone out and copy the file out I can finally get it back to its normal state.
View 3 Replies
View Related
Aug 23, 2012
I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed.
I have a local copy of the access app. When I close the app, it takes ony a few seconds. But when on a network drive, it is taking 2 mins.I just wanted to know if the time taken to close the application on the network drive can be brought down without disabling the compact on close option.
View 1 Replies
View Related
Jul 26, 2015
I've just joined a company based in Scotland, they are running a multiple user access 2000 database: backend and front-end. Recently they have had an issue where a user inserting a new row in a table, as they do, the record above drops off the table (disappears/unrecoverable). My first impression has been that this is a DB corruption issue and as such have ran compact/repair.We are running this database on network server:
-Backend resides in central location
-Frontend - Each user has their own front-end, storded on their personal network drive.
Would I be right in saying that the best solution would be to convert to newer version of access ?
View 3 Replies
View Related
Nov 5, 2013
We have a new user who is unable to get into a database. Another user in the same office had no problems.
The other user is using:
"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerNameShareNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb
The new user was not able to access the share at all using ServerNameShareNameSFTP until he changed the path to:
"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb"
Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw 1" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb" (Note the space and 1)
I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.
View 4 Replies
View Related
Aug 22, 2013
I have written a database in Access 2003, saved as an Access 2000 format. This runs fine on Windows XP workstations. When I install the same system on a Windows 7 system, my login screen launches, the user is able to enter in their name and password. Then nothing happens. What is supposed to happen is a form opens up after the password is entered that applies security written in code based on the user.
View 3 Replies
View Related
Oct 24, 2005
Hi
I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email
chris@ctbjs.co.uk
many thanks
Chris
View 1 Replies
View Related
Jun 2, 2006
I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.
However, there are 2 instances when this stops and waits for a human option to be selected:
1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:
"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"
How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?
Any help most appreciated.
Dalien51
View 1 Replies
View Related
Mar 27, 2006
If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?
To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?
Please help...Thank you so much....
View 3 Replies
View Related
Aug 20, 2007
Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
Thank you in advance for any help,
Dom
View 10 Replies
View Related
Nov 15, 2006
Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?
Thank you in advance.
View 3 Replies
View Related
Oct 24, 2006
I was using the database when there was a network error and I had to close it. When I tried to reopen it I got the error message: Record(s) cannot be read; no read permission on 'MSysAccessObjects'. I logged off the PC and logged back on various others, but keep getting the same message. Can anyone tell me if this is terminal or is there a way around it. I do have a backup, but it's a few days old and a lot of work will need re-entering' so any help would be appreciated!!
View 1 Replies
View Related
Nov 8, 2004
KTYPE=text; EXPIRATION_DATE=date/time; OVERAGE=date/time
im doing a report based on a query (which has a few fields, including KTYPE, EXPIRATION_DATE, OVERAGE). im trying to determine the OVERAGE based on the following conditions:
here are the conditions:
if KTYPE="PO", then OVERAGE:=(EXPIRATION_DATE + 6 months)
ie.. KTYPE=PO, OVERAGE:=(01/04/2004 + 6 months) = 07/04/2004
if KTYPE="IAA", then OVERAGE:=(EXPIRATION_DATE + 20 months)
if KTYPE="FA", then OVERAGE:=(EXPIRATION_DATE + 12 months)
and so on and so forth.
I'm very new to Access. What formulas do I use and do I put the formula in the query or the report.
Please help. thanks in advance
View 2 Replies
View Related
Jun 2, 2014
I cannot remember (or find) a simple thing like the shortcut key for selecting the current record I am editing.
I have a form (or sub-form, or table even) set as a continuous form. I want to delete a record. I select the "record selector" on the LHS by left clicking on the grey box. I press [Delete]. No problemo.
I do not want my users to see the "record selector" grey box on LHS of my continuous form. I switch off record selectors. Now I am in edit mode, editing data in a field of my record. I decide I want to delete that record by using the [Delete] button. What is the shortcut key for selecting the record so that I can then press [Delete] do this, given that there is no "grey box record selector" to click on?
Same could apply in direct table view. No clicking on grey record selector box allowed.
View 1 Replies
View Related
May 8, 2013
I am using access 2010 and I created couple of buttons on my forms that do some stuff in vba, but beside triger them with mouse I would also like my users to be able to have shortcuts on keyboard so for example I have btnClose an I widh when user press ALT + that btnClose do the same thing as it is doing when you press mouse on it.
View 4 Replies
View Related
Aug 7, 2013
I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.
Is there a way to only bring up the form, unless I obviously need to edit the date base.
I've done some research on Google and it seems I need to use:
SW_SHOWMINNOACTIVE
However I can not seem to find how I would use this or where?
and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?
View 2 Replies
View Related
May 9, 2014
I remember there is shortcut keys for input field name when creating a queries. For example, when we try to create a query to combine field [firstname] and field [lastname] from customer table and we use: fullname:[firstname]+" "+[lastname]; instead of input this expression {fullname:[firstname]+" "+[lastname]} key by key, is there shortcut key that can input [firstname] into expression?
View 1 Replies
View Related
