Reattaching Back End Database After Drive Change
Jul 20, 2013
I have a big (reasonably big) Access 2003 db which I have split. On the E: drive this functions perfectly. Years ago I moved it to an other drive and found that to reach the back end again I had to change the drive letter in the link to the tables. Unfortunately I can't remember how I did it - all I remember is that somehow I brought up the link path and could then simply change the drive letter. I now find it necessary to put the db on an external drive for use with different computers. It will probably be easiest to put "." instead of a drive letter in the link, but after trying all menu options for db, tables and macros I still haven't found out how to access the link path.
View Replies
ADVERTISEMENT
Feb 25, 2013
I have built a Database links to multiple back end databases. The whole database is completed, and I have to share it across the company, so I have placed the Database and all of the Back End databases on a "public" shared drive. I have the "public" drive stored as my Q drive. So when I link to the back end databases, the path it stores is Q:DatabasesDatabase.accdb
However, the problem is that not everyone will have the "public" drive mapped to Q. It's possible they could have it mapped to P or A or whatever. So if someone has their "public" drive mapped to P, this database will not work (since Q:DatabasesDatabase.accdb would not exist for them - it's really P:DatabasesDatabase.accdb).
Is there a way around this? So that instead of it mapping to the relative letter (Q or P), can it just refer to "public"?
View 2 Replies
View Related
Jul 22, 2015
I need to change the password to the front end of my split database. How would I do this?
View 1 Replies
View Related
Jun 27, 2014
using the "back-end" and "front-end", how to put a password also in the "back-end"? is to lock the database "backend" for anyone to change the data?
View 1 Replies
View Related
Mar 18, 2006
Does 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.
View 3 Replies
View Related
Aug 29, 2014
My workaround was to temporarily map the URL to a vacant drive letter on the local machine, then copy the file over, then drop the mapped drive again. A bit clunky but doesn't incorporate much of a delay and this download only has to happen once per day.
The good news is, the file download / copy now works every time. The bad news is that removing the temporarily mapped drive after the copy has taken place, doesn't and I can't figure out why.
Here are the functions I use to map / unmap the drive :
Code:
Option Compare Database
Option Explicit
Private Const RESOURCETYPE_ANY = &H0&
Private Const CONNECT_UPDATE_PROFILE = &H1&
Private Const RESOURCE_CONNECTED As Long = &H1&
[Code] .....
I have separate functions to check existing drive mappings on the local machine and thus determine an appropriate vacant letter to use for the temporary mapping - they work fine.
Unfortunately the UnMapDrive function returns False (even though I switch the active drive to C: and force the connection to be cancelled with the fForce flag) So the mapping always remains on the users profile.
I don't want to permanently map drives on the users' profiles, just briefly for the purposes of this daily file download.
View 11 Replies
View Related
Oct 24, 2006
I was using the database when there was a network error and I had to close it. When I tried to reopen it I got the error message: Record(s) cannot be read; no read permission on 'MSysAccessObjects'. I logged off the PC and logged back on various others, but keep getting the same message. Can anyone tell me if this is terminal or is there a way around it. I do have a backup, but it's a few days old and a lot of work will need re-entering' so any help would be appreciated!!
View 1 Replies
View Related
Oct 30, 2007
As the thread title suggests, my problem is that I have a database that will not open via the mapped drive. There are other databases stored on this drive that open fine so it is only the one database that is causing me a headache.
Any suggestions as to why only this one database would be having this problem and any ideas on how to resolve it would be greatly appricated.
Thanks
View 3 Replies
View Related
Oct 3, 2013
I need securing an Access database. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view everything like forms and reports), and my boss to ONLY be able to view everything (form/report wise).
I found this post [URL] .... about how to secure a database. I spent all day doing it, but it didn't work at all! I just got a bunch of errors whenever I tried to do anything, so I deleted the database and re-used an earlier version.
View 6 Replies
View Related
Aug 29, 2014
I want to access my database from different locations. More than 1 user may be using it at the same time.
Can I put the back-end of a split database in a Google Drive folder or a Dropbox folder and have multiple copies of the front-end for each user in their own location.
I know that Dropbox creates copies if two people update the backend at the same time. What about Google Drive? How does Google Drive handle it.
What are the potential problems of using these two services to share a database?
View 2 Replies
View Related
Jan 11, 2005
Is there a way to change the back color of an active field in a form? Meaning, when I tab through my form and the field I tab to becomes active, the field turns white. This poses a problem because my form back color is black and my field text is white. When the field is active, I can't see the value in the field due to the back color defaulting to white. Does this make sense? Is there a way to change it?
View 7 Replies
View Related
May 10, 2013
Is it possible that once the command button "Send Cost Request" in red is pressed it will change to green?
View 3 Replies
View Related
Apr 30, 2014
I have images in my form, say, Image1 and Image2 . The default background color for all of them are white. If the user click image1, the background color has to be red. If the user click image2, the background has to change to red and the image1 retains its default color ( White ).
I have six images to loop through these. Image1 to image6.
View 8 Replies
View Related
Aug 1, 2013
I have a form in datasheet with the fields "Date In" and "Date out" among other.
I want to be able to Change the backcolour of the "Date In" to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting, but now I only want to apply this formatting IF the "Date Out" is empty.
Access 2007.
View 3 Replies
View Related
Mar 15, 2014
How do I conditionally change the Back Color and Alternate Back Color based on the value of notes.FollowUpDate? I have a continuous form using the following code:
Code:
Private Sub b_all_past_Click()
Me.resultsFrame.SourceObject = "FollowUp_bystaff"
Me.resultsFrame.Form.RecordSource = "SELECT * From notes WHERE (((Notes.FollowUpDate) < Date()+1) And ((Notes.followup_person_id) = GetCurrentUserId()))ORDER BY notes.priority,(notes.FollowUpDate) DESC;" '
End Sub
View 1 Replies
View Related
Oct 21, 2013
I have an unbound form with a combobox which needs to be validated before the control is updated.In the Before Update event I check that the value is valid and need to reset the value back to the previous value if not valid and then change focus to another control.I thought that the following code would work but the selected value remains in the control and I cannot move the focus to another control.
Code:
Private Sub cboYears_BeforeUpdate(Cancel As Integer)
Dim dteNewDate As Date
dteNewDate = DateSerial(Val(Me.cboYears), Month(Me.txtCalendarHeading), 1)
[code]....
View 7 Replies
View Related
Oct 24, 2007
Cannot open back end database.
There are no other users logged on
Tried opening it in open exclusive mode but still error message.
Front end on number of desktop PC's.
Back End on server.
I need to get in design mode on back end but won't let me.
I get logon screen but when try to log on get message below
I can log onto front end ok.
Error message something like.
* You do not have perimission to open or enable database
* You must have open/run open/exclussive administer permissions.
* Request other users to log off
e.t.c.
View 2 Replies
View Related
Dec 28, 2006
Howdy all.
I need to take my database 50 miles to a factory site so that an engineer and I can review/modify all the records, ~450 so far.
Can I copy the front end and back end files to my laptop, review edit the data offsite, and then overwrite the back end file on my server when I get back? Are there any issues with doing that?
Thanks,
bugleboy
View 14 Replies
View Related
Mar 6, 2008
Does anyone know of a way to make a database back up by a click of a button in a main form in the database? (so a customer does not have to go tools/database utilities/back up database)
View 9 Replies
View Related
Aug 17, 2005
We are currently running a FE / BE splitted database abd would like to back the back end up (to a sepearate location) every 15 minuutes by using the On Timer event.
Troiuble is, I believe I cant use the CopyDataBaseFile method whilst other users are in it and it would be too much hassle kicking everyone off!
Manually copying and pasting is good, but would really like to crack this one
Any suggestions please?
Regards
Andy
View 3 Replies
View Related
Aug 30, 2005
I have done the mistake of not keeping a backup, what I did is split my database file access and then created my mde file, I need to change some data on my tables, but I get the msg that I cant edit a linked table, is there a way that I could put things back the way it was, also this path that was created is it possible to change for future purposes (I might have to move the dir into a different path)
Thanks.
View 2 Replies
View Related
Aug 31, 2005
Hi,
I have a question;
If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup
The next time I open the application how can I get them back?
Any help will be very appreciated,
Thanks,
CS.
View 1 Replies
View Related
May 17, 2006
I have been asked to take a database created last year and re-design it to make it more user-friendly.
Not a problem, I thought when asked but I am running into a little problem...(the database designer)
In my opinion, to make a system more user-friendly there is a necessity to access the code and tables in order to gain a reasonable knowledge of the way in which it has been constructed. Unfortunately, although I am allowed to LOOK at the front end, I am not allowed any further access to coding or back end information.
At present middle management are siding with the database designer as they feel that from a security standpoint, access needs controlling (I can agree with this to an extent)
Does anyone have any ideas of how I can talk the management round or any suggestions for a way through this issue?
(Oh, and I'm not allowed to build them a new database and substitute it...I already asked)
Regards
Jason
View 12 Replies
View Related
Jun 5, 2006
I need help making a front and back end to my database. How should I do it!?!? All I know is what I should put in the front end and what goes in the back end. The rest needs to be explained to me somehow...
View 3 Replies
View Related
Jul 12, 2007
Hi, I am not sure where to put this thread hopefully someone here can help me.
I have spent a good deal of time developing a very effective access database for a client. It is split into a front end and back end and connected using the Linked Table Manager when necessary.
The front end is quite loaded with queries, reports, forms, macros etc and the back end simply has the tables.
The front end is about 15 mb and the back about 8 mb.
Current set up is a small workgroup network with about 4 -5 consecutive users at any one given time.
I am looking for some advice on how to set up or facilitate getting the backend on the internet so anyone with a front end can access it outside of the LAN.
Today I set up an account with WebDrive which can connect to and assign a drive letter on your pc to any FTP, HTTP site.
I made the connection with WebDrive and using the linked table manager successfully linked the tables on my local machine to the back end on the FTP server - and actually ran the database at a pretty good rate.
I noticed however that it was downloading the backend to my local pc and once I closed the (a) form it was uploading the data back to the server? Very slow and often threw errors.
This of course is not what I wanted. Has anyone heard of doing this? Any work arounds or setting params would be greatly appreciated.
I have been told to create the DB in ASP but I do not have any idea on how to do that whatsoever...
Any advice or insight would be awesome!
Thanks!
Fen How
View 1 Replies
View Related
Mar 27, 2006
I am trying to repair my back-end database but am having trouble. Everytime I select 'Repair Database' I get the following error:
'\BE_Data.mdb' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names.'
Can anyone tell me what this means, or more to the point, can anyone tell me how to fix this problem.
View 3 Replies
View Related
