System.MDW File
I am still a bit confused about the system.mdw file.
I create FE and BE on my local computer and change name of system.mdw to say Jobs.mdw, after backing up system.mdw I then join jobs.mdw with my jobs FE and jobs BE and set secutity settings, etc. I then place
FE, BE and Jobs.mdw all in the same folder.
I now email jobs database with jobs.mdw file to client which places FE, BE and jobs.mdw in Jobs folder on server. Shortcut for fe is placed on each local machine.
My question-Does Jobs FE and Jobs BE still access Jobs.mdw even though placed on another computer and possibly another version of Access?
Does the shortcut have to reference Jobs.mdw?
I need to understand this.
Thanks,
Jim
View Complete Forum Thread with Replies
Related Forum Messages:
Missing System Mdw File
:mad: Somehow the system mdw file is missing after I have reinstalled Office XP Professional and every time I try to do anything like make a new file or open a mdb file the dialog box opens saying the workgroup administrator cannot create a new mdw file. I am the only person to use this computer so I must be the administrator. How can I rectify this situation as I cannot use MS Access without a system.mdw file :(
View Replies !
Workgroup File (system.mdw) Problem
I recently created a workgroup for an access database and it works fine. But I have other versions of that same database (beta copies) for which I didn't create that workgroup file. They have different names than the first DB for which I made the workgroup. But even when I open those beta copies it still launches the workgroup file (system.mdw) and prompts me to login. What do I need to do to revert these changes and go back to the unsecured version of my database? Is it as simple as deleting this file? Thanks in advance, Angelo
View Replies !
Security Hole If System.mdw File Is Used
I am a newbie and I am having a problem with MS Access 2000 security. I have created a workgroup information file for a database to secure a database using a user level security. Everything seems to work ok if I use this WIF. But if I join the system.mdw file the database is not secure and opens without prompting for login. Please let me know if there is a method to block the user from using the system.mdw file.
View Replies !
File Menu System By Pkstormy
Ok, I had to convert this mdb to 97 and strip the heck out of it (removing all the extra nice features) so I could zip it to less than 100kb so I could upload it. You'll probably need to convert the mdb when you open it (I really hated stripping out all the extra nice features and graphics.) It's a very nice fully functional file menu system I developed (I tested it ok on my machine and several others). Here's all the goodies that it does (definately worth trying this - I don't believe in wasting YOUR time and hopefully you'll think so after you try it): 1. It will search and find files in folders/subfolders of any file type you specify (Word, Excel, Access, picture files, etc..)and store the complete folder names and filenames (and file dates) in a table (or you can input *.* to search for all file types). The folder name, file name, file date stamp, complete folder/filename, are all stored in separate fields in the table for easy sorting, exporting, and organization (it doesn't store the actual file but stores the location of that file in the table so you don't have to worry about the mdb file growing to an unspeakable size). You basically tell it what folder to look in and what file type to search for and it will search for those file types in that folder (and subfolders) and store the location/filename in the table. You don't even need to type the folder name to search for but instead can use the FSO type browse button to select the folder (it can search any networked drives). You can even group the file type search to any name you specify (ex: Word Files, Excel Files, etc.) 2. Once it's populated the table with all the files it found, it will then show you all the folders, filenames, dates, etc, in a listbox whereby you can click on and launch any file (Word, Excel, Access, BMP, etc...) in the listbox. It knows how to launch pretty much any file type which is associated for windows. Ex: click on your Word file in the listbox and it will open that Word file in MSWord. Click on a bmp file and it will open that bmp file in MSPaint (or whatever application you associated bmp files to). Click on an Excel file and it will open that excel file in Excel. If it can't find the associated application to open that file, it will ask you for the application name to open the file and then launch it. 3. You can create desktop shortcuts to any file in the listing by clicking on the file and then clicking the "Create Desktop Shortcut" button on the form. You can easily see the new shortcut created on your desktop as it saves the shortcut icon as a bullseye (oops - I had to remove the saving it as a bullseye icon so I could compress this but you can still create the shortcut to the file on your desktop.) 4. You can sort the directory listing in the listbox any way you want (file date, file name, folder name). 5. You can search for any keywords in the folder name or filename. You can click the "Find Shortcut Files" button on the form and it will search for any *.lnk shortcut files it found. 6. It opens this mdb without seeing any of the Access information (I had to remove the code which removes the Access caption bar on the main form but the version which I couldn't compress small enough to upload has this removed plus some very nice looking graphical buttons/background). You don't even know this is an Access mdb (other than the caption on the main form). As with other mdb files, hold down the shift key when opening this mdb to see the code and get to the form design. There's NO protected or special unseen code!! Edit and modify this as you please. Again, this is completely modifiable. I only ask that you give me some credit. 7. You can filter the listing of files by the file date, showing files newer than the file date you specify in one listbox and older than the file date you specify in the 2nd listbox. 8. Similar to the FSO (but you don't need the Microsoft Office Object library), there is an API call where you can browse for folders or any file types. A reference to the Microsoft Office Object is NOT needed. 9. I almost forgot, it also tracks opened applications in a table (dbo_LogFiles table) and the date/time, which file was opened. I had to cut out the code which had a button to show the user all the files they've opened and when they opened them but you can get behind the scenes and look at the table to see what users are opening what files and when. It's very SQL Server upsizing ready and I do have a SQL Server version. I also have some fields in the dbo_LookupTable with True/False "Mark as Current" button to filter out current files in the listing. Also removed was the ability to click on a file and add comments to that file so you can see them by clicking on the "Comments" button. I've also removed the show recently opened files button which then lists all the files you've recently opened. I use this menu system often (as do my users) and it has been a godsend for me and them (I created it to help others find files and launch them quickly). It has many nice features where some of them "mimick" the Search button in Windows Explorer (but think of it as having your searches saved in a table and quickly accessed.) If you like this (and I hope this very stripped down version works for you), then PLEASE send the administrators of this website a post asking them to increase my upload size so I can upload lots of more coding examples (I've already asked them to increase my upload size but they haven't so far.) I'm a moderator on the www.dbforums.com website (pkstormy) where you'll find a LOT more different coding examples in the MSAccess Code Bank which I've uploaded. I'd like to upload those examples to this site if I can get the increase in upload size. Please send me feedback if you find this code helpful. I'm very interested in hearing if it's helpful or not (I'd like to say that an email to me is required to use this but it's beneath my nature to do so.) If it doesn't work but you'd like to try it, I sincerely apologize and you can send me an email: pkohn@charter.net (or post a thread to me on this site or the dbforums website) and I'll send you the unstripped down version in whatever version of MSAccess you need (I hope this thread/attachment isn't deleted so you can try this out.) IMPORTANT: There's NO special installations, NO trial period type stuff, NO demo-only version, NO special references needed, or other required files to this!! I like to keep things very simple and easy and don't use any special ocx or other required installations (I've spent more time writing this post than I did on the actual code.) It's a straight-forward mdb file with 2 tables, 2 forms, and about a dozen modules which you may find some of them very useful to import in your other mdb creations. It's been tested on several machines and the code compiles without errors or adding any new references other than the typical MSAccess installation. I've documented everything I could and left the author names of any code which I imported from other sources. This can be improved upon but I coded this within a weeks time-frame so please, no complaints or obscene emails. Moderators of this website - would you please increase my upload size so I can upload more helpful examples I've created? I'd also like to upload the unstripped down version of this. Special thanks to all the other authors of the different modules I copied code from to make this work. - pkstormy (Paul)
View Replies !
Compacting And File System Security Problems
Hi I've done every search I could think of, but haven't come up with a solution. I'm having a problem with file system security settings of windows 2000. I have a FE/BE database setup, the BE is stored on a network drive that all users have access to. The FE is stored in the same spot on every workstation (C:dataXXXXXX.mdb). The FEs demonstrate considerable bloat and I understand that the solution is frequent Compact and Repairs. However, each physical workstation is used by more than one user (different shifts) and the compact process removes the Everyone file system access from the database and replaces it with Administrators, and the current user; thereby preventing anyone other than the compacting individual from accessing the FE on that computer. Is there a solution?? thanks Jesse
View Replies !
Spa System
I am new to Access and Ive created adatabase to control a spa system. I have several tables: Customers Employees Types Of Haircut - Their prices Types oF massage Their Prices Now I want To create a form where i am able to choose customer, the employee performing the haircut or massage The price should be displayed and the total AMount How can I do that? Should I create a Query and based on the query I create the form? Please Help!!! Thanking you all
View Replies !
Payroll System
Hi All, Need your expert advise. Is it ok to develop a simple payroll system using MS Access or do i need switch to Visual Basic? Also, is there anybody can help what tables do i need to produce a payroll system, i.e. tblEmployee. Thanks, 19Summer95
View Replies !
Reservations System
I am creating a database to room allocation in a small hotel. I want the system to check room availability between two dates. What would be the best way to construct this in Access? Kev
View Replies !
Set An Equiry System
Hi, I am trying to implement my Database with an enquiry (or quotation) table and I am not sure I am heading in the right direction: -We use assemblies made of components and the data are held together in the database with a 'Bill of Material' set up. -A typical assembly is made of 1 or 2 bodies + Fasteners (straps and screws), -The body price is calculated depending on his weight and an extra costs can be added with extra tooling and machining, The costumer ask us for a quotation for various number of assemblies and we send back the estimation of the price, I am really struggling to see if my tables are set right and this is what I came up with (attached rr.zip): A main Enquiryfile Table is linked to an enquiryDetail Table which would record each individual item information for each Enquiry. I have also added a Extracost detail table that would record all the Machining and extra pattern making cost for each assembly. And finally, and that's what I am far to be sure about, a TblChildItemCost where the price of each components would be recorded (for each enquiry detail). The body price is based on his weight but also depend of various market exchange rates, that is the reason why I have created a table for the price of component for each enquiry. I really hope someone can help me on that one...Thanks in advance.
View Replies !
System Tables
Hello, My application I develop should retrieve some meta data from Access system tables. It should find: - What tables are stored in database. - What columns have each table in database. - What relationships are between tables in database. I opened systems tables of some .mdb file and took interest in such kind of information. But I got some problems by looking for what exactly I need. Please, could someone help me at these points: 1) I found that in system table MSysObjects I can find names and ids of tables created by user (for example by me). But how to determine that these tables are created by user and they are not let’s say a system tables? 2) I didn’t find any meta data about columns of tables! How to determine what columns has each table? I created application which uses MS SQL Server to retrieve such a kind of meta information and there where no problems. But I stuck using Access. I was looking for some information in Internet but ineffectively. Please, help me...
View Replies !
Hire System Help
I have two tables, one named Loan and one named DVD Details. On my DVD details table i have a field name, on_loan with a data type yes/no. I have created a form called LoanForm where i want to select a DVD with a combo box, then select a Set loan button that will set the corresponding DVD on_loan field to yes(true), in the dvd form. on the button i have the following code Private Sub HireDVDButton_Click() Update dvd Set car.on_loan = True End Sub But it doesn't seem to set the on_loan field in the DVD table to true, which is what i want to do. Sorry if it's not clear what i want to do. I am just a beginner. Thanks in advance :)
View Replies !
Difficulties With System
Hi, I’ve been having some problems being able to do some things on my database, I was doing ok creating my system but now I’m a bit confused about what to do and I’ve been trying but getting no where. Firstly on my order form I need a total for the products which are in an subform and after the order is complete I need to be able to create an invoice and keep all the order information in the 'invoice' and 'invoice details' tables. I also need it to update the stock levels after the order is complete. Then I had created a tab in 'view customers' and I wanted to have it so that past customer orders could be viewed. Any help is appreciated; here is a link to my system: 'Gamez System' (http://www.savefile.com/files/5877934) Thanks, Bob.
View Replies !
Checking If The Same Name Is In The System?
I have a form where I enter student names, and it often happends that I enter the same student a couple times, Is there any way to let the user know that there is allready someone in the system with the same name, like a pop up message.:confused: thx
View Replies !
Getting Into An Access System
Someone, who is no longer working at out organisation, created a system in Access which we are trying to get into, however the creater put on some security which will not let us open the system to alter. Is there a way of getting into this?
View Replies !
Issue System Commands From VBA?
Hello, I would like to issue a system command from within a VBA function. Specifically, I'd like to start another application using a command-line startup command, but am not sure how to do that. Any suggestions? Tom
View Replies !
|
TRACKER
