Search results for query: *

Great Thanks!!!

Thanks for your reply, but all of the things you mentioned above for me to do have been done. My question is how do I let multi-users some located in the state of Florida and some in California to have access to the DB off of my server in real time. Do I need a FTP, VPN, etc? Thanks

Hello, My question is, how do I make my DB accessable to users in a different location (two different states) in real-time? I want both location to be able to add and edit data and that it is current for others to view. We were using the DB (split) on a server in one location, but now a part...

I'm trying to build a report that has 4 details which numbers records will have to show for each detail, for example Detail All Passengers Customer Payments Supplier Payments Additional Charges Misc Fees When I try to build the report all of detail for the record will not show or it's...

After I have split my Database and installed FE on each terminal it opens very very slow and moving through records. Please advise

I have split my DB, and when I go to the FE to open the swtichboard it give me an compile error: User-defined type not defined and this where it lead me me. Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. Dim dbs As Database Dim rst As...

A client of mine has 5 computers running Access four are running 2002 and 1 running 2003 over a SQL network. The one running 2003 is the bosses son and every since he has been going into the database with 2003it's been nothing but problems. They are now losing data once inputted--prior to this...

Im splitting my database. I want to put my lookup tables and switchboard on the FE instead of BE. My Question is do I import those lookup tables to the FE and then do I delete them from the BE. Or do I leave them in both locations

I will be go out to split the database on Monday I didnt set up workgroups because they have to use--users passwords to login onto the network

Still having promblems. Locking users out was not an issue until the IT Tech changed everyone rights to full access--Now one machine is locking everyone out. The IT Tech gave everyone full access to the database instead of limited access. Everything was fine for about two days, then they...

Well I thought I was out of the woods, I just rec an email now they are saying that one person is still losing their city info. The other for workstations is retaining all of their info, but now its one person who continue to lose the city she inputs or it completely changes to a different city...

Needless to say I talked to one of their IT people and he looked at the network and come to find out that only one person had full accessability to the database the other people could only read and thats why the data was not sticking. Today is the first day that the staff will have writing...

Could you please advise me on the code I would use to check for broken links on start up and initates a relink dialog

No the data didnt change it was for whatever I had entered through the form thats how it appeared on my query.

I ran the query report and the city names are as I put them in form my server. I have never seen data just change like this, they were running fine for a week then all of sudden problems. I have check the city and how it's setup, the state field is setup the same way no problems. Now they...

Hello I have created a database it's on a Cisco server and ever since it has been put on this server their has been nothing but problems. The problem is the city field which is a combo box to recall previous inputted cities. If the city at the time is not in the combo box list the user is...

This is my first try at splitting up my database. My question is once I split it how do I relink the two? What I have done thus far I made two copies I renamed one back-end and I put the tables in that one, the other I named front-end and I left the queries-forms-report ect. in that one--now I'm...

Where can I get more information on back-end and Front-end building, could you please reference some books that you highly approve of. Thanks

I have created a database---I have a copy at my office and the design master is on my laptop. The problem that I am having is now since I want to sync the two. When I go to tools down to replication and over to snyc that options is not highligted. Not the one at my office nor on my laptop. Now...

My customer table has the City and State fields and then I made two table lookups for City and State and linked them with the city and state in the customer table. The names are the same. As follow in the Customers Table City Lookup State Lookup City CityID...