I have a MDB file that I am unable to transfer to my online server (I get a 'critical transfer error' message. I am, however, able to upload other MS Access databases to the same server using the same FTP software.This points to a problem either with this particular database itself or my ASP code.
I have six fields, all text fields, with simple named columns (such as username, password, etc). In Design View.
Where does one start to look for information on what is needed to set up an online web form that can write to an Access database? I'd like to learn how I could possibly set up an online registration form for clients to use via a web page. I don't really know where to start, but I have seen some information on asp.net stuff. What's the easiest path?
View 6 Replies View Relatedwe have got a table with the vehicle details with a sub forms (main Vehicle Details, Subform Booking details)
we cannot allocate a car until a week previous to the dates required.
we are using a recored (To booked) that we can store all the dates in, the idea really is to have a button we can click that brings up the parameter requesting the REG PLATE for the car that when entered will cut and copy the booking details from the NOT BOOKED into the corrosponding vehicle is this possible?
I dont mind a button beside each record in the sub form but really needs to cut + copy the fields beside it
Field Names are:
FirstName
Surname
Date From
Time From
DateTill
TimeTill
Reason
I recently designed a new database according an old database in order to replace it. I found that I have trouble transferring the data from old to new database.
Only transferring data from one table to another
Database A: [table]![customer]
to
Database B: [table]![Client]
Field name on both are different
DatabaseA:
Table Customer:
Name,
PhoneNumber,
e-mail.
DatabaseB:
Table Client:
FullName,
HomePhone,
CellPhone,
E-mail.
How can I transfer from "Database A/table customer" to "Database B/table Client"?
I'd like to to import some large oracle tables from a remote server using "DoCmd.TransferDatabase..." on a daily basis. Currently, the system works, but my database is getting quite large (800 Mb) and I'd like to split off the tables to a back end database.
Is there a way to import directly to the back end database? The postings that I've seen seem to imply that one must first import the tables into my front end, then export them into the back end. Does that sound correct?
I'm at home right now, but will give it a try when I get to work. It just seems like there's got to be a more direct way!
Jon Mulder
Department of Water Resources
Red Bluff, CA
I have a Table with a Field set to Number, Single, Fixed, 2 Decimal points in which I enter Hours (ie 11.25) then at some point I want to extract those new entries to create a Text file transfer.
I have a Macro which extracts those new entries from the main Table and copies/appends them to a new Table which contains only the new data I need to create the File to upload into a Payroll system (using TransferText option).
It all works well EXCEPT, the File it creates insists on showing 8 decimal points and I just cannot get it to show 2 only.I have tried using a calculated field, setting the secondary Table field to Text.why or where these 8 decimals are coming from.
I am creating a student database in ms access2007 but finding difficult to go further. In my database, I have created the following
Student-info-table
SemesterTable
SessionTable
PaymentTable
Then a query from the payment that shows student I'd,arrears,amount due,paid. And balance
My question is
1.How do I transfer the students and their balance to a new semester and session
2.Do I have to new student and payment tables every semester bcos payment are made every semester
3. I want to keep each students payment for as long as they remain in the school
4. A session is made up three semesters how do I transfer students to a new session
May be my tables layout are faulty...
I've written an application in VB.Net and now I need to transfer the data on textboxes on a form to a report for printing. Only the data on the form is what I want to preview and print.
View 1 Replies View RelatedWhen I click the Create MDE button I get the error message You cannot add or change a record because a related record is required in table 'MySysAccessStorage'.
I am a user who has been making some improvements to our database. Now that I want to test the improvements I need to create an mde, but can't.
The database was created in Access 2003 and I am now using Access 2007 on windows 2010. The original developer advised that we continue to use mde format - something to do with the runtime version everyone else who uses the database have.what I need to do to convert my mdb to an mde?
I have been using my db for 3 years without this particular problem: I am now unable to add records to one of my tables - either through the form or in datasheet view. I have a patient table and a visit table. I put in the patient data using a form and then go to the visit form to add all of the visits for the month. I have never had a problem adding data to any of my tables but now I am unable to add data to the visit table. As much as I didn't want to I brought up last month's back up to enter the patients again. Before I did I checked to see if I could add visits - I could not. So I checked January's back up - same issue. I made no changes to the db before trying to add a visit .
View 10 Replies View Relatedit is zip file unable to get the size lower yet minimal amount in database I have 2 tables and one form when I create an query on the form the form then becomes that I cannot enter data in it or edit etc
View 3 Replies View RelatedWhen trying to set a password I receive the following message.
You must have the database open for exclusive use to set or remove the database password.
To open the database exclusively, close the database, and then reopen it by clicking the File tab and using the Open command, In the Open dialog box, click the arrow next to the Open button and then select Open Exclusive.
When I follow the instructions, I don't get a dialog box. How do I set a password?
I am trying to close a form with a subform.
I enter data in the main form and then the subform.
The main form has a save btn with an on click event which includes at the end of code
If Me.Dirty then
Me.Dirty = false
DoCmd.Close
DoCmd.OpenForm "FormName"
However the Form will only close and open the required form if I remove the two "Dirty" Code lines.
I am obviously trying to ensure that the data is saved on both the main and subforms using the If Me.Dirty......code
I am new to MS access 2007 but not new to Access. I am trying to open a form in the design view but that option is disabled along with other menu options. I checked the Ribbon and it appears to be a custom toolbar. I deleted that out of the box but I'm still unable to view the design of any objects. How do I enable the menu items?
View 1 Replies View RelatedThe application was unable to start correctly (0x00007b)not sure it's an Access issue exclusively. What fix to apply (is it a Registry entry that's corrupted perhaps?).
View 5 Replies View RelatedWhen I start my database normally, I'm not able to add fields, change chart type, etc, by right clicking in a pivot chart or table. It works when I open the database while holding down the shift key though, so I suppose there is an option in my database somewhere that I have changed, but which one.
View 1 Replies View RelatedI have a user that is unable to edit records, He can click in the fields but he could not delete or enter data in the fields. He has the ability to edit records but its fields are locked. I created a split database and created a secure front which I distributed it to multiple uses. The other users front end is working fine, expect for the one.
View 2 Replies View RelatedWe have offices in other states that need to be able to open our data base. Due to the line speed it is extremely slow linking to our backend. Is it possible to have duplicate backends that can be merged, lets say over night or at the push of a button.
View 5 Replies View RelatedI have a database (Access 2003 and I am using it with Access 2007 with user level security) on shared folder on internal Dell server and I have created a shortcut to each user's machine to access it. This days I am facing a problem of db size as every 10 days it's increasing upto 2gb but the strange thing is when I am doing cut / pasting same database to my desktop from the server shared folder it will become 80 mb only and I am again placing that db (80mb db) into the server and it will work. What is a reason behind it? why my 80mb db is showing 2gb db on server?
View 1 Replies View RelatedI want to work on SQL Server tables located at my work place at home using Access. My question is; is it possible to link SQL Server tables on a server to my lap top computer using "Remote Desktop" or will I need to install Access onto the server and if tables can be linked using Remote Desktop how do I link them? I am using Access 2010 and have Windows 7 professional installed on my lap top.
View 3 Replies View RelatedMy DB is split into BE and FE into about 5 Laptops. The DB is for entering personal information of pensioners.
sometimes it becomes necessary to take a computer away from the office to capture data of sick and aged pensioners. Now if you take the server (BE) out all the other clients (FE) will not work, and if you take a client out it wont work.
To solve the issue I decided to install a standalone version of the db in all the clients. If out of the network, the standalone DB is used and later captured data to betransfered to the server.
My question: Is there a code that I can use to check if my server is available to start the FE or if unavailable to start the standalone?
I have a windows 7 machine with Access 2000 installed. I need to link to some tables on an SQL server and "SQL Server" does not appear in the dropdown of available link types. I think a driver is missing. I did a clean install of Office 2000 and only selected MS Access. Maybe that prevented everything needed from being installed. I would like to add just the missing driver if possible.
View 1 Replies View RelatedI need deleting a file from a ftp server. I have the code for uploading but I can't seem to figure out how to delete a file. This is the FTP module I'm using
Code:
Public Sub UploadFileToFTPServer()
On Error GoTo ErrHandler
Dim lngRet As Long
Dim abytData() As Long
Dim lngBytesWritten As Long
[Code] ....
And this is the code for uploading i use in the form when i click a button
Code:
Dim objFTP As FTP
Const conTARGET = "ftpserver"
Set objFTP = New FTP
With objFTP
[Code] ....
All that works like a charm.
Code to delete a file from the ftp server, i'm kind of stuck.
I'm having a problem with a database that i had split. While creating teh database, i had it stored on my personal drive at work, but wanted to move it to the shared drive so the data could be stored there. this is to deal with cross site network connectivity issues that we encountered with another database here at work.
When splitting the database, i split it on my personal drive and then dragged the back end to the common drive. I realized my error, but when attempting to correct it, i somehow have two of the same file, and no back end?
I receive the error on the attached document when attempting to access any of the tables or information in either of the files, the "back end" that i placed on teh drive, and the "front end" that i have on my personal drive.
I also tried to relink the tables through the linked table manager, but receive the same error when attempting that.
Is there a way to recover from this? I had backed up my file by making a copy prior to splitting, but somewhere in this process, this became linked to these and is having the same issue. Is there a way to recover the old "unsplit" version? I cannot copy over all of teh tables, etc. because i get the same error as earlier.
I can attach a copy of my database for reference...
I'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedI am new in database design . I did a database by access 2010 which contain form and tables and i want to split it to backend and frontend and then make then in website
I need step in detalis to do that
How to split
How to put the backend on my site
How to make frontend in site