When converting the Front End of my database to an MDE, Access just hangs and says (Not Responding). I've left it our an hour and there's no sign of stirring.The Back End converts in just a second or so.
View RepliesSimply put, I have a front end that does a bunch of file moving and if it encounters an error and stops processing (which is intentional) I am the only that can login to the machine and fix it.
Is there any way to run it that would allow others to login on their own user profile, solution the problem, and start the processing again or am I stuck to a "per profile" instance?
I can't just let others login as me
I was successfully using a front end and back end setup for the past two years. Today I needed to push through some changes and "deactivate" the previous back end database and setup a new back end database. The new back end database has been sent; however the front end is not recognizing the back end database anymore. I need to re-link the existing front end to the back end database - I cannot import the front end into a "fresh" file because I put a password on the VBA Editor.
View 14 Replies View RelatedI am trying to convert a table that looks like the following...
Customer Name SumofSum of Bill Rate Reviewer
000462 John 500 Mike
000224 Mike 900 Jeff
I would like to covert it to....
Customer 000462 000224
Name John Bill
SumOfSum.. 500 900
Reviewer Mike Jeff
I don't think Access has any functions for this but I am not 100% sure. I know this can be done in a Module but I am not sure of how to code it.
I was looking to see if there was an easy way to create a user front end desktop application for a small access database.I have three users on different computers i would like them to input or amend data within one table of the access database.
View 2 Replies View RelatedI have created a Login form in Access Database in which the users can log in to enter the work information like how much time and which job they worked on particular day , this data is stored in a table . How can make the users to use this form , I dont want to access to be installed on every machine..I want to give something like a URL so that the users can use it..
which software I can use for creation of website so that it can be compatible with ms access ...I basically need to create a front end application and connect ms access my project in the back end scenario..
hello..
I have this problem that when I update the value in one of my tables, MS Access hangs up. I don't know why. I dont know if it's because of the updating or because of something else.. Any help would be greatly appreciated.. Thanks in advance! ;)
here the code that's executed when the approve button is clicked..
Private Sub Command43_Click()
Answer = MsgBox("Are you sure you want to approve this timesheet? Note that only projects approved by respective project managers will be approved.", vbYesNo)
'if cancelled
If Answer = vbNo Then
Else
Dim rs As Object
Dim x As Integer 'will be used as a flag for do while loop
x = 1 'initialize flag
Set rs = Me.Recordset.Clone
rs.FindFirst "[weekending] = #" & Format(Me![weekending], "mm/dd/yyyy") & "#"
'finding the first record wich matches the weekending doesn't give the right record
'right away. it may give a record with the right weekending but different eno. that is
'not supposed to happen. so once a weekending match is found, check if the eno also
'matches. this do..while loop will do the trick =)
Do While x < 18
If rs!eno = Forms!TimesheetDetailsFrm!eno And rs!statusPM = "approved" Then
rs.Edit
rs!status = "approved"
rs.Update
x = x + 1
End If
rs.FindNext "[weekending] = #" & Format(Me![weekending], "mm/dd/yyyy") & "#"
Loop
'close this form and refresh the 'timesheets for approval' form
Answer = MsgBox("You have successfully approved the timesheet. Close this window to continue viewing other submitted timesheets.")
Forms!SupervisorFrm.Requery
End If
End Sub
Thanks again..
ps. How do I mark a post as 'resolved'? Coz I have a previous post which has already been solved.. Thanks to all of you guys. ;)
My Access app hangs when running the following code on Form_Load:
VB Code: Original - VB Code Private Sub Form_Load()On Error GoTo listbox_errorDim strSQL As String, strList As StringDim listrs As New ADODB.RecordsetSet listrs = New ADODB.RecordsetstrSQL = "SELECT * FROM sections"listrs.LockType = adLockPessimistic With listrs .ActiveConnection = open_conn() .Open (strSQL) End WithDo Until listrs.EOFstrList = strList & listrs("id").Value & ";" & listrs("section").Value & ";"LoopstrList = Left(strList, Len(strList) - 1)Me.cmbSection.RowSource = strListMe.cmbSection.RowSourceType = "Value List"listrs.CloseSet listrs = Nothinglistbox_error:MsgBox Err.DescriptionExit SubEnd Sub Private Sub Form_Load()On Error GoTo listbox_errorDim strSQL As String, strList As StringDim listrs As New ADODB.RecordsetSet listrs = New ADODB.RecordsetstrSQL = "SELECT * FROM sections"listrs.LockType = adLockPessimistic With listrs .ActiveConnection = open_conn() .Open (strSQL) End WithDo Until listrs.EOFstrList = strList & listrs("id").Value & ";" & listrs("section").Value & ";"LoopstrList = Left(strList, Len(strList) - 1)Me.cmbSection.RowSource = strListMe.cmbSection.RowSourceType = "Value List"listrs.CloseSet listrs = Nothinglistbox_error:MsgBox Err.DescriptionExit SubEnd Sub
The connection is in a module named publicfunction:
VB Code: Original - VB Code Public Function open_conn() As ADODB.Connection 'Opens connections to database Dim sPath As String sPath = CurrentProject.Path & "endjftocbe.mdb" Set open_conn = New ADODB.Connection With open_conn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=" & sPath & "; Jet OLEDB:Database Password=*****" .Open End WithEnd Function Public Function open_conn() As ADODB.Connection 'Opens connections to database Dim sPath As String sPath = CurrentProject.Path & "endjftocbe.mdb" Set open_conn = New ADODB.Connection With open_conn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=" & sPath & "; Jet OLEDB:Database Password=*****" .Open End WithEnd Function
Any ideas why it is hanging? The conn to the database is successful when I use it for the login procedure, but after that, I can't seem to get back in.
thanks
Access 2007 has hung up while I scrolled from left to right through the columns in a linked ODBC table in datasheet view. I understand why it "hangs" while scrolling through rows, but I've never heard of it doing this for columns and I am talking about a complete freeze up here.
View 3 Replies View RelatedI have built an Access 2010 split database on my computer and it functions as built. My next step was to copy it to the server at work and test it. I discovered the tables had to be re-linked and so did that. As I have read in the Access World Forums in order to function as a multi-user database a copy of the front end must be placed on the individual workstation with the back end residing on the server, however the hyperlinks in the back end will not function when the copy on the workstation is run. I simply get an unable to open "filename" error pop-up. I can run the server copy and everything functions as built. I know that the hyperlinks require all the files to be in the same folder (relative vs. absolute), but if the back end contains all the hyperlinks why does the location of the front end seem to affect the operation of the back end?
View 3 Replies View RelatedOK, sorted out that last problem I had.... Heres a new one.
This query runs fine:
SELECT [Piping Models by Area].AREA_NAME, [Piping Models by Area].MODEL_NO, [All Pipes].LINE_ID, [All Pipes].PIPING_MATER_CLASS, [All Pipes].PIPE_LENGTH
FROM [Piping Models by Area] LEFT JOIN [All Pipes] ON [Piping Models by Area].PARTITION_NO = [All Pipes].PARTITION_NO
WHERE [Piping Models by Area].AREA_NAME like "545*"
ORDER BY [Piping Models by Area].AREA_NAME, [Piping Models by Area].MODEL_NO, [All Pipes].LINE_ID, [All Pipes].PIPING_MATER_CLASS;
Add one WHERE criteria, and it no longer runs, under Access or TOAD for Oracle, or SQL*Plus, or anything:
SELECT [Piping Models by Area].AREA_NAME, [Piping Models by Area].MODEL_NO, [All Pipes].LINE_ID, [All Pipes].PIPING_MATER_CLASS, [All Pipes].PIPE_LENGTH
FROM [Piping Models by Area] LEFT JOIN [All Pipes] ON [Piping Models by Area].PARTITION_NO = [All Pipes].PARTITION_NO
WHERE [Piping Models by Area].AREA_NAME like "545*" and [All Pipes].PIPING_MATER_CLASS = "F13B"
ORDER BY [Piping Models by Area].AREA_NAME, [Piping Models by Area].MODEL_NO, [All Pipes].LINE_ID, [All Pipes].PIPING_MATER_CLASS;
It works fine, and is nice and fast, until I add the second "WHERE" criteria.
[Piping Models by Area] and [All Pipes] are both queries and run fine on their own. This query also runs fine without the WHERE clause.
Any ideas? Is there some small syntactical error causing some kind of infinite loop or something?
Edit: formatted for easier viewing
I have a program abc.mdb and abc.mde, I made some changes to the codes in abc.mdb and now I have been trying to convert the access file from abc.mdb to abc.mde so that the users are able to use the updated file. However, whenever I make MDE file. It doesnt work but creates another file called db1.mdb instead.
View 9 Replies View RelatedI have just delivered my front end to the user. I have incorpoated a splash screen which uses the timer event and then a sign-in form opens. Trouble is, when the user opens the FE it just sits there on the splash screen. The Access security won't let the above process run because it stops all VBA until the user shift-starts and clicks the 'allow' button. After that it all works fine until I deliver an updated version and it all starts again. All using A2010. what I need to do to avoid the user having to shift-start?
View 5 Replies View RelatedIs there an easy way to convert an old ACCESS db from version 2003 to version 2010?
My ACCESS db is .mdb and I want to convert it to .accdb as version 2010. It has hundreds of modules that may take awhile to export. Exporting is the only way I know to transfer from one db to another.
Currently the system where I work is set up so that everyone has their own front end on the local network. I would like to change this because updating all of them takes a lot of time for me and skill level for users is too low for me to trust them with updating it on there own.
My question is this:
If I were to create a shortcut on everyone's desktop that linked to one front end would this be wise? I can't seem to get a straight answer from anywhere on the internet. I know most places say that it is better to have the actual front end on the staffs computer but that would make my job of keeping the database updated even worse because staff have multiple computers and this isn't my full time job.
If this is okay practice how many users would this be able to sustain? Currently we only have 6 users on the database with there own front end and it works great. I am planning on adding around 10 more users in the future but if needed they could have there own database as they are separate programs.
I am in the process of updating a database to 2010 (.accdb) and cannot get past a problem. We are using Access 2010.
I updated the back end data to .accdb with no problem. I can't link the front end to that data without updating the front end to .accdb as well. There are no tables in the front end.
I try to update the front end to /accdb and I get the error message 'You are trying to convert an encoded database. Decode the database, then try again.'
How do I decode the database? I tried setting a password and then unsetting it, but that made no difference. I have not previously encoded the database.
can't finish the update to .accdb data. The alternative is to stay with 2003 MDB data. Is that a bad thing?
What is the best solution for sharing a front end DB as me having the BE installed at my pc, giving all user the FE and then refreshing table link with BE installed at pc but the problem is that the shared FE becoming slow any option ? as only 5 users using this at a time.
View 4 Replies View RelatedI'm trying to move a couple tables into the Front End of an Access 2010 database because the drop downs take awhile to load. We have horrible servers at work.
I can get some of them to convert to local table but naturally the ones I really need won't. The only table I want to remain in my backend is "project log data final". I don't even get an error message it just doesn't do it. Why would it not let me convert some to a local table. Does it have anything to do with relationships?
I have a database system into the back end and front end and then created the accde file with the front end file to give this to users on their computer. The back end being placed on a server with a path of type servernamefolder..I have used the Linked Table Manager to point to the tables server name folderfilename.accdb
but in doing this I get a message Windows cannot access servernamefolder..is this to do Network Rights on the server that I don't have permission to access the server and folder.
I have (on a company network) a FrontEnd .accde and a backend .accdb - currently ~ 10 users (some over wifi - slow!)The FrontEnd is becoming a rather large file ~ 10 MB and is also becoming slower.I am looking to separate this in to 3 FrontEnd files as to simplify and to lessen the file sizes etc.
My question is - are there any issues around a 3 x FrontEnd databases all connecting to 1 x backend database holding all the tables - over a network?
I just split my DB into a front end and a back end. I only want the users to have access to 2 forms in the DB because the form already has buttons that link to all other forms and reports needed. How do I customize the front end view so that they only see these 2 forms?
View 6 Replies View RelatedI am trying to manipulate some Ebay data, which returns a string like "1d 00h 29m"
Is there a function I can use to convert this string to relevant hours in total?
I have a file called CAPTURE.BUF. I am trying to convert it to text. Here is what I ahve done, but I get the message box ever time.
Public Function copyFile()
Dim SourceFile As String
Dim DestinationFile As String
SourceFile = "C:PCPICSWCAPTURE.BUF"
DestinationFile = "C:INVESTMENT_REPORTSCAPTURE.TXT"
On Error Resume Next
FileCopy SourceFile, DestinationFile
If Error > 0 Then
MsgBox "Could not copy mls file."
End If
On Error GoTo 0
End Function
Using 2010 (accdb format) on windows 7.I'm trying to convert a memo field's format from Plain Text to Rich text. The problem is that every time I try to select the Rich Text format option the field immediately changes back to Plain Text.
Just as a test a created a new memo field in the same table and set this to Rich Text (worked fine) then copied the records for the Plain text memo field to the new memo field. Unfortunately this removed all line breaks so instead of my text looking like
I have recently asked about being able to use my table system online. i have just thought. what about creating a front end that works online. still have the front end on the desktop and the table system on the desktop but have both of them connecting to the one table system.
View 8 Replies View Relatedi have one front end access database and want to connect with more than one back end at time but both back ends have same table names
View 2 Replies View Related