I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server situation as it impacts on the various links I have set up within the database to files etc that are part of the program but are external such as Excel, Word files. The current links are all set up as C:MainFolderNameFilename. Of course these all stop working when I place it on a server and link the users up via shortcuts. On our own installation I changed the links to the \MyServerMainFolderNameFilename format and everythings fine but due to the number of links this is a fairly lengthy process and I wouldn't want to have to repeat it at every clients installation.
Can any one please advise me if there is a way to set it up so that I could say enter the clients server name in a field. Then insert that field's contents into the pathway details for the links so that they all update automatically.
I have a multiuser database where the tables are split from the rest of the database and is being used by three locations. That portion works fine, BUT the traffic makes it horribly slow to the end user. The servers are located in Dallas and both east and west coast users access the information. Just doing updates makes me tense!! So I duplicated each database and positioned them on each locations home based server. Runs great no problems....But the information needed for work and reports is now written to 3 databases all with different server names. ( I realize this is more of a network issue but there is no way around it) My issue is that I need to get to that data from all three locations and combine them so that it can be worked and reported on....THEN sent back to the database from which it came. I tried to build a macro that would go to each database, retrieve the information into one server location but when I put the path name in it defaults to my local database rather than the one I am pointing the path to. Anyone have any ideas on making this happen?
i have a database file that holds 1 inventory table.
Then i have 2 other database files that represent 2 retail stores.
my problem is that the store files have a form which acts like a sales invoice. The sales order number is an autonumber. this worked fine in the past with local network setups, but now going to a server the issue is that the sales order numbers cannot be the same from one store to the other. Since its related to the inventory table it steals the invoice from one store to the other..
i tried formatting the autonumbers differently.. like /100 on one and /3000 on the other. And they are still the same autonumber anyway.. the format doesnt mean much other than a different display..
is there a way to control the auto numbers to be in a specified range of numbers...
i would like to be able to say for store 1 the sales order numbers can only be from 1000-5000 and store 2 6000-9000...
I have a database that consists of one server.mdb which houses the tables and a folder called users with an individual folder with a copy of client.mdb for each person (This helps see whos on and whos not). The server is in the networks root directory and the clients are in a users/name/ I just moved these files from a windows 2000 server to the linux server and now only one person can access the database at a time - The Microsoft Jet Database Engine cannot findopen file VET/tier2/server.mdb someone has the file opened up exclusively or you need permission to view the data. Nothing has changed other than the network path and I relinked the tables and compacted and repaired both the server and the client.
I have some code that when a check box in a table is ticked, sends a pop up message to the users logged in (message is on a hidden form), then it closes the DB after a pre-dtermined period of time.
The problem I'm having is that we are a large site with a about 25 differnet servers that our users log onto via Citrix, when a user is on a different server it isn't displaying the message nor closing the DB down.
trying to achieve this? Or is there a better way to see who is logged in and get a message to them?
I'm using Access 2003 btw
Code I'm using below
Code: Option Compare Database Private Sub Form_Load() Me.TimerIntderval = 10000 ' change to 300000 for about 5 minutes End Sub Private Sub Form_Timer() DoCmd.Close Application.Quit End Sub
Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!
I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.
Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.
Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.
Does anyone have a good easy sugestion on how to distribute a db with access runtime in a package to users without access 2003? I have tried setup2go and it makes a fine .exe file. But I can't make the package with access runtime.
I have a Query with many part numbers in column A and their inventory location(s) listed in column B. However, some part numbers are listed 2 or 3 times because the item is located in multiple inventory locations. How can I take these items and put list their inventory locations in multiple columns across one row?
I have finally completed my database project. It is a split database. Back End on a network server.
I want to distribute the front end to all users however I want to limit to the best I can what they can do to it. Can someone please advise me on the best way to wrap up and send out my front ends?
All security has been established. I am talking about the availability to see the tables, macros, control bars etc..
I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.
I have several questions that I may need some help on.
How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?
How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?
Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?
Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.
i want to display a single field values in list box with query as row source.the query will produce variable number of records or rows. sometime 1, sometimes 3 or 6 my thought is to distribute these records/row into list box column. for example:
if query = 1 then listbox column = 1
if query = 6 then listbox column = 3 (two rows per column).
I have a list that shows how many books we have for each PO No. (Sorted by PO No.) Like below:
LIST 1:
Code: PO NoTOTAL BOOKS PO-0001 12 PO-0002 15 PO-0003 26
Now I would like to distribute/divide these different books to boxes and each box gets maximum 10 books. Like below list:
LIST 2:
Code: BOX NOBOOKSPO NO 0001 BOOK 1~10 PO-0001 0002 BOOK 11~12 PO-0001 0002 BOOK 1~8 PO-0002 0003 BOOK 9~15 PO-0002 0003 BOOK 1~3 PO-0003 0004 BOOK 4~13 PO-0003 0005 BOOK 14~23 PO-0003
Format is not important in the list2, for example in Box 0002 we have book 11~12 means (book 11 of 12 +book 12 of 12) in po-0001
+ book 1 of 15 until book 8 of 15) in po-0002
books have bookno, for example for po-0001 we have 12 different books it means we have bookno (1 of 12) until (12 of 12) for this po no.
How I can produce automatically list 2 from list 1 by query or coding.
I have multiple databases (Front-end, Back-end, Import, Reporting) which enables auditors in our company to audit loans.
I use an Import database which imports a random sample of loans (10%) into the Back End database for audit. I import a spreadsheet of loans (let's say 5000 loans) into the Import database, and I have the query return 10% of the loans, which is then imported into our Back-end database for audit (500 loans for audit).
Currently the auditors look at the daily list of loans (the 500 imported loans) and divide the work amongst themselves (5 auditors will audit 100 loans each.) They decide Bob will do 1-100; Joe will do 101-200; Bill will do 201-300; etc.
Is there a way using a query to assign these loans to specific auditors when importing the loans into the BE for audit? I would need to enter how many auditors will be working the loans so the work is divided evenly, and then enter the auditor's initials. (Since the auditors perform different audits, I would like the ability to select or key in auditor initials when importing the loans..
Looking for efficient table structure for this. Let's say I have a list of contractors who will get paid a certain amount of money each week. The amount of money changes each week by measuring the amount of work done, giving it a price and calculating it. The fields are these:
[pk]WeeklyWorkID WorkID Quantity UnitPrice Total=Qty*UnitPrice (not stored in this table) EmployeeID WeekID
So far, it's all good, but we wish to pay the contractors in an unusual way. Let's say he makes $16,000 of work this week, and we want to pay him using cash AND/OR either one or multiple debit cards. For example:
We can only deposit $7,500 max in each card. But it's even worse... two or more contractors can SHARE the card and it's not always the same card. Sounds pretty funky, but it's what the company wants to do. So, what would you recommend me in this case?
I'm guessing I'm gonna need these tables: tbWeeks to hold the week number, tbCards to store the cards' info, and an extra table to make a many to many relationship between the cards and the employees.
