Recent content by mmmk

Right, that was irrational thinking on my part. Now I have to type up instructions on how to do this. Thanks.

If the msaccess.exe file is located in a different folder for each user, is there a way to make the shortcut work without configuring the shortcut on each computer? This would be alot easier if the user's computers were in one location, but they're not. Can I save the msaccess.exe file to the...

Thanks! My fingers are crossed that the msaccess.exe file is saved in a standard location, since people are in different buildings it is hard to verify. Thanks again for your quick response.

I got the shortcut to work. I didnt realize I have to point to 3 different files in the target area. Will the first part in the target area, "c:\programfiles..." work for all of the users? Now that I have the shortcut setup, do the users access it off of the shared drive or should they copy it...

the Security.mdw file is on the shared drive. In the shortcut properties, the target points to the security file, and the start in points to the database frontend file. When I open the shortcut, the security file opens. What am I doing wrong?

Thanks! This link is very helpful. Can you explain exactly what goes into the "target" and "start in" fields of the shortcut? I will be using the \\Server\Directory\.. method. Do I need to create an individual shortcut for each user?

When I join the workgroup, it applies security to every database on my computer. The database is on shared drive, and my other dbs are not on this drive. any ideas? Thanks.

i am using access 2003. Do you have any suggestions on how to get back administer permissions on my db?

any ideas?

new problem, somehow I do not have administrator permission on my own db. When I go into user and group permisssions, it says the current user is Admin, but when i try to set Administer DB permissions an error message pops up saying I dont have permission to change permissions.

Could you explain this? Im not sure what you mean.

When i try to change the path using the linked table manager i get the error: "application defined or object defined error". How do i deleted the linked tables from each front end to relink them to the correct file path using the servername\\partition\...

I recently uploaded my database to a shared drive on the server. Once I had the files uploaded, I went to linked table manager and set up the file pathes. I set the path up as "z:\....dbname_be.mdb" I know this is wrong but now that it is set I cant change it. When I select the tables and click...

Thanks Bob! I am going to work on another version of my DB and set it up using your advice. For now, how would I modify my code to get this filter to work? He is what I have: Private Sub Form_Load() Dim StrFilter As String StrStatus = "Ops" StrFilter = "[Area] <> '" & StrStatus & "'" Me.Filter...

The form is based off the Events table, The Events table is the main table in my DB which has tables, suchas Area, related to it. The Event table holds all the records related to one event and uniquely identifies with an event_ID. Only the Area_ID is kept in the Events table, which then...