Wireless Network Card
Dec 21, 2005Sorry All,
I have a simple question, how can I tell if my laptop has a wireless network in it. Thanks.
ADVERTISEMENT
Using Access On A Wireless Network
Nov 29, 2005Hi guys,
does anyone know if there are issues using Acess on a wireless network? There seems to be problems access the database now that this has been installed... Lots of reboots required etc...
Ta muchly
Wireless Network Hard-drive Back-End
Mar 18, 2006Does anyone have any experience with placing a multi-user back-end access database on one of these inexpensive "external network hard drives"?
I have a situation where I'd like to share my database with multiple users, but the corporate IM rats have pretty much eliminated all means of allowing us lowly employees of doing that with their network. We have no file server. We do have sharepoint services, but we only have Access 2000, which as far as I know is not capable of exploiting the sharepoint/xml back-end database features. Also, no one in the office here can share a directory on their workstation because they won't grant us administrator priveledges.
So thats how I came upon the idea of buying or creating cheap (<$250 USD) wireless network hard-drive on which to put the back-end. I'm mainly interested in knowing if it will work, and that the performance isn't going to be absolutely pathetic. I'm only looking at having 3 or 4 users at any one time, and the entire database will only house a couple thousand records.
Access On A Wireless Network - Making It Work
Jan 23, 2007There are posts elsewhere on this forum about the adjustments you can make to Access to improve its performance on a wireless network, i.e. make sure you have XP SP2 and not an earlier version of XP, but the fact is that no programme will perform well on a network if the network isn't performing well. Here are a few things I've learned (the hard way!)
- Use USB wireless adapters, not card type adapters. One of the prime rules of wireless networking is to keep your adapter - and your Router - away from electrical equipment and metal objects, so why anyone even makes card adapters is beyond me.
- Place your adapters/Router as high as possible (above head height is best) using a USB extension lead for the adapters if necessary. Do not put them on or near metal filing cabinets!
- Think about line of sight when placing your equipment. If your Router and an adaptor are just on either side of a wall , opposite each other, the signal may only have to pass through, say, 6 inches of wall. If they are at opposite ends of their respective rooms, however, it may have to pass through several feet of the same wall!
-If there are other wireless systems nearby using the same channel as yours, change yours to a different channel even if the other signal is weaker than yours. Remember that you need to be 5 channels away from anyone else before there is 0% overlap in the frequencies. If you cannot achieve this because there are too many nearby networks, any difference is better than none.
I have a 9 user (each in a separate room) p2p network in my office running a split Access 2000 db. The place looks a bit odd with USB adapters stuck high up on the walls but it works. Only one user has the occasional hanging problem (about once a week) but she's using an oldish laptop with only 256k of RAM and it has to run Norton Internet Security at the same time. Three of the users have the db open more or less constantly, the rest have no problem or speed issues getting in whenever they wish.
Nearly forgot, our Wireless system is standard 802.11g. max distance from an adapter to the router is about 80 feet.
Sorry if any of the above is stating the obvious, thought it might help.
Why Is Access Slow On Client Computers Across Wireless Network?
Feb 8, 2006I have completed a database for a company with 60 000 clients and over 100 000 job records.
The database works at very resonable speeds on the Server computer, or the computer on which I installed the back end of the database.
Each of the other 3 computers on the wireless network, have a local copy of the Front End on their machine, and reference the Back End (BE) on the server computer.
Each of the Client computers have varing speeds when accessing the BE, some as slow as 10 minutes for a simple search, filter or just loading a form.
What can I do to improve performance across the network?
Do I need to install additional components on the other computers to improve the db performance?
Your help will be much appreciated.
Joseph.
Access 2007: Wireless Network Problem On Vista
Nov 7, 2007Hello,
I found a somewhat related thread but thought I would post a new one just in case my problem happens to others who were 'forced' to "upgrade" to Windows Vista Home Basic when buying a new machine....
Okay, no more complaining, here's the issue:
I have a small (8 MB) Access 2007 database stored on a machine in the office which is running Windows Vista Home Premium. There are two other machines running Windows XP Home (SP2) that can connect to the Access 2007 database with no issues.
But on my Dell Inspiron Vista Home Basic machine, I cannot successfully open the database stored on the Home Premium machine. I CAN see this database, I can see other files and open/copy them, but I cannot open the database. I am attempting to do this using the wireless connection.
I tried running these two commands as the administrator (found on another forum) because I think this is more of a network problem rather than an Access 2007 problem specific to Windows Vista Home Basic
netsh interface tcp set global rss=disabled
netsh interface tcp set global autotuninglevel=disabled
But these two commands did nothing.
I should also point out that when this database is stored on an XP machine (one of the others in the office) the database opens just fine on this Vista Basic machine!
I'm confused and frustrated! Any help is very much appreciated.
Thank you,
Mike
Wireless Mistake
Mar 8, 2006Okay I know i've been incredibily stupid and made a tremendous mistake but what i need is the best solution to the problem i have right now...
I have a database its msaccess with SQL Tables at the moment. There were an expected 40 wireless users expected but after horrendous crash on day one and only 10 users and after some digging i see that this is just not going to happen (why i assumed it would be ok is my own naivity and taking the word of the IT Manager)... the connection is totally unreliable and corrupts the database beyond repair.. infact i'd go so far as to say the wireless network murdered my database.. strong words but its my baby..
So what are my solutions here... the staff need this database... so what i have come up with are the following solutions and i thought i should ask for some advice before i plough ahead and make another fatal error..
use DAP? Or another internet based way of getting round it?
Get network points put in all the rooms?
Or can I make it totally SQLServer?
Help.. any advice would be greatly appreciated cause at the moment i have a fantastic application that just cant run and i feel such a complete failure.
Using A * (Wild Card) In Pop Up Box?
Aug 3, 2004
Is it possible to use a * (Wild Card) in a pop up box for a query?
I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field
My criteria in my search fieled is a follows:
05-May
06-June
07-July
08-August
etc...
As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data.
Any help would be appreciated.
Thanks, Scott
Fried Graphics Card. What Do I Do?
Jun 4, 2006Hi,
I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use.
In order to retrieve the information from the harddisk, I got a cable between this computer and another one.
This is my plan:
When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this?
second question:
If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer?
Fuga.
Magnetic Card Reader
Apr 7, 2008Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated.
Thanks,
Matthew
Business Card Scanner
Nov 17, 2006I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o
View 2 Replies View RelatedWild Card In IIF Statement
Jan 28, 2008I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using is;
IIf([Forms]![Criteria Form]![Customer Account] Is Not Null,[Forms]![Criteria Form]![Customer Account],[Data]![Customer Account]).
This works.
However for some of the criteria I want to also use wild cards, so that the user can enter just part of the data, and the relevant records will be returned. I understand that wild cards cannot be embedded into the IIF statement above.
I have tried many methods, and trawled the web for ideas, but I cannot get this to work. I either want the user to enter the wild card themselves ie "100*" returning records starting with "100", or for the query to append the wild card itself.
Can someone help please?
Wild Card Name Searching Help
Feb 27, 2008How would I make a query find a person like this:
Inputted Data: Smit
Outputted Data: Smith, Smithy etc..
The formula I have entered in the criteria of my query is:
Like [Enter the person's last name]
With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out.
Thanks.
Wild Card Searches
Jun 22, 2005Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query:
[Forms]![Search]![BoxNo]
So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13.
How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:
Credit Card Processing
Apr 18, 2005Does anyone know of any software or have any code that would allow to process credit cards.
View 4 Replies View RelatedEmployee Time Card System
Nov 15, 2006I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is
Date
Type of work
Hours
Rate
Comments
I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template.
Thanks,
Chrissy
Modules & VBA :: Authenticating User Using Their ID Card
Jun 30, 2014I want to create a database that utilizes the user's ID card to authenticate them and tie any changes to their name.If not that way, using their stored information (SSN, or other ID) as a means of creating a username/password. I've never messed with creating different user levels in Access so this is uncharted territory for me.
View 6 Replies View RelatedWild Card On Search Form Issue
Nov 3, 2007Hi all,
I need a little help with a wild card issue, Ive looked and looked and cant spot whats wrong.
I have two forms "Requisitioner" & "Engineers", each form has a subform.
These are basic search forms (unbound) that find related records in the subforms. The work is done in the query of the subform and then the form is refreshed. I have used this approach many many times without issue until now.
If the engineers form is opened "G*" is entered into the text box then all the entries beginning with "G" are found in the subform.
If the "*" is then removed from the text box leaving "G" no results are found in the subform, (Working Correctly)
Now if the "*" is added again "G*" then the subform shows all the entries beginning with "G"
Everything is good with the Engineers Form, If the same steps are made on the Requisitioners form after adding the "*" again no records are displayed.
I could change the way this works by doing a recordset find but i really want to know why this is working on one form but not on another.
I would appreciate any help with this.
Garry
Seeking Much Help With Generating A Card Number From Another Field
Jan 14, 2008Hi guys,
I need some help here and any would be muchly apprieciated.
I am building a database for a theme park fast pass system where a customer can book themselves a place on a ride at three session times a day.
Now my problem is, that I need to generate a card number. 5555 1946 as the first 8 digits (this always stays the same) and then the last 8 digits is the customer ID number, which is in the same table. So there are 16 digits in total.
Let me give you an example:
A new customer registers and are assigned a customer ID of 1000 0001. Therefore the Card Number for that customer must be 5555 1946 1000 0001.
I have used auto number for customer ID so when a new customer signs up, there ID is 1 more that highest already in te database.
Simple question really...but how is this done?
A million marks for someone who breaks it! Hehe
Thanks
Table Design For A Clock Card System
Jan 8, 2005i'm try to create a database to record staff sign in and out times and to get reports but i cannot for the life of me get it working after many many efforts. can any one help me?
View 2 Replies View RelatedID Card Making Printing And Data Base
Oct 23, 2004I have got a dbase created however getting it to print in the order I need for the PVC Id card just is not working.
Any Ideas
thanks
Matt
Queries :: Wild Card Searches With Brackets
Jun 26, 2014I want to prompt the user to enter a merchant name, but want the results to return close matches.I know how to use the wildcard in the Criteria field of the query, but I want to use brackets.I know that "*Southwest*" Will return Southwest Airlines.So I tried *[Southwest Airlines]* and it treats the criteria like a text string.
View 1 Replies View RelatedForms :: Hyphen Not As Wild Card Character
May 18, 2013I have a series of dates that I inherited from former DB. Some of the dates are Mon-Fri, Mon-Thu, Sun-Fri, etc. That is, there is a hyphen "-" in the middle of the text. I have an unbound control with an IIF statement using the LIKE condition, I just get an error. I tired the following to no avail. Using Access 2010.
IIF([Day1] Like "*-*", 5, 1)
IIF([Day1] like "-", 5, 1)
IIF ([Day1] like '-', 5, 1)
IIF ([Day1] like [-], 5, 1)
I've looked it up and the hyphen _ is used as a wild card character, but I need to include it just as a dash.
Open A Card Directly From Table View
Jun 7, 2015In fact, I have one principal d/b running on my access, ad/b which I had imported from my iPad... The import went smoothly enough but I face this problem. I usually scroll the table in order to locate a patient's name.
I can't find a way to select this line and have it switched to a card view in order to update it. I need to move to card view, search from there in order to locate this person in card view. I am sure there is a way to select a line ( a record) in table view and jump from there directly into this record in card view.
Validation Text For An Expiry Date On A Credit Card
Nov 20, 2005Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:
MM/YY but i cant find a way of doing this!
I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:
>=int(now())
So the input mask has to accept this validation...
If you could help, i would be very greatful!
Cheers
Converting Filter From Wild Card To Extact Match
Aug 30, 2006I have a search box and it looks up project id number.
the orginal code works but filters anything with that particular number.
I like to adjust the filter to equal to the number enter.
ex,, I enter 22 , i get records with 622, 223, etc
I want it to be only 22
I can't seem to figure this out.. here's te code
Private Sub txtSearchString_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
LSearchString = txtSearchString
'Filter results based on search string
LSQL = "select * from [Projects - Active]"
LSQL = LSQL & " where ID LIKE '*" & LSearchString & "*'"
Form_frmSearch_sub.RecordSource = LSQL
lblTitle.Caption = "Project ID: Filtered by '" & LSearchString & "'"
'Clear search string
txtSearchString = ""
End Sub