Programming the BackEnd path
Problems accessing a split database
I have successfully split my database (frontend/backend) and have the backend stored on a sharepoint for my team to use. One thing I noticed we all had to do is map the same drive letter to the network path where the backend is stored. Since I initally split the db on my pc using drive W, the db now requires everyone else to use the same drive letter.
So everyone maps a W drive for the path where the backend resides, and has a local copy of the front end. 3 of us can pull it up fine and we can have multiple instances running with no problems. One user however, gets the error: "W:\ is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides." I have verified that this user does indeed have drive W mapped to the correct location, but he still gets the error.
Problems accessing a split database
I have successfully split my database (frontend/backend) and have the backend stored on a sharepoint for my team to use. One thing I noticed we all had to do is map the same drive letter to the network path where the backend is stored.
Since I initally split the db on my pc using drive W, the db now requires everyone else to use the same drive letter.
So everyone maps a W drive for the path where the backend resides, and has a local copy of the front end. 3 of us can pull it up fine and we can have multiple instances running with no problems.
One user however, gets the error: "W:\ is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides." I have verified that this user does indeed have drive W mapped to the correct location, but he still gets the error. I'm lost.any takers?
Access 2010 Runtime - Link to backend database
and having trouble sourcing information that makes sense.
I have a database that is split into a front and back end.
The back end is to reside on a shared network location (yet to be determined but we'll call it \\SERVER\DBSHARE for now).
The front end will be installed on the client workstations.
The Client workstations have mixed versions of Access 03 and Access 07 but all have the Access Runtime 2010 installed.
The problem is when you open the front end it spits an error out saying it can't locate the backend. As this is the Runtime version there is no Link manager to set the path.
I'm assuming (and this may be wrong) that there is a way, somewhere be it the package manager, code, pathfile to be able to say something like "Path to Backend is \\SERVER\DBSHARE\be.accdb"
Does anyone know if there is some way to set the path so that the backend can be linked when using Access Runtime
Backend folder vs. frontend database
If I have an MS Access frontend that connects to an MS Access backend, is there a way to hide/permission block the pathway to the backend's folder but still allow access via the frontend db?
Right now I can't dedicate a server to a more "secure" form of DB or anything like that so I'm stuck with MS Access for now. say, a link table path and then navigating to that folder and getting access to backend information. What might be some solutions to this?
re-linking backend on shared folder
I have several front ends on different computers connected to a single backend on a shared folder on one of the computers. All is fine untill I update the front ends and then have to manually re-link each one with the backend. Since I am modifying the front end on my own machine and then copying it to the other machines, the path to the back end will not be the same.
Is there a way I could have a small text file or excel file in the same folder as the front end that has the location of the backend and use it to somehow to relink the tables?
When I change backend password.Frontend wont open
I have a passed down access 2003 database. That if I change the backend password. I get an error message that the previous owner set up. But I'm new to programming and can't fiqure this out. I cant leave the database with the old password because other users that have left the dept have this old pw and thus have access to my backend
Split db and have backend on local PC
I want to split my db for other reason than to share with tons of people and I need the backend on the local machine with the front end but in a different directory. The db front and backend will be
distributed as a packaged solution to a singler user. The user will install the access runtime as well as the db's.
When I try to split the db called My Jewelry Project and place the backend in a folder called My Jewelry Data using this address //My Document/My Jewelry Data/JeweryData.accdb
it will not find the location.even though the folder exists.
I've tried ~/bla bla bla | and ~//bla bla bla and these links do not work either.
So how do I split a db and have the backend on the same computer with a relative path?
Not a valid path
to fix a path.
I got an Access DB and try to open it but is showed "not a valid path, Error 3044"
I know I need to change the path, but where I can find wrong path and fix it? Seems I didn't see anywhre that have a path.
I am using Access 2007. I have developed a database that will be used in a workgroup environment by 3-4 computers. I will have no access to this network. All the PCs on this network uses Access 2007.
The database will be placed in a shared folder on one of the PCs. I will need to split the database. But because I am not on this network and can not connect to this sharedfolder, how can I split the database on my computer with the proper Network Path of the shared folder and then give them a copy of the backend and front end instead of giving them thedatabase as is and then guide them to split it?
Also, the users will have to have Read/Write access to this folder in order to used the backend of the database. I can convert the frontend to ACCDE, but not the backend. If the users can connect to this folder with Read/Write access, they will have access to an unsecured backend.
Unless I don't know any better, how does this splitting provide and security for the data?
Importing backend automatically with VBA
For a database being used in different offices, I want to provide a config page within the DB App itself so that the user can specify a custom path for the database backend for linking.
I've been messing around with it and am able to link to a backend, if I specify in vba the table names from the back end. I'd rather not do this.
I'm also able to load the backend (importing it, it seems) through VBA. If I check the tables for a connect status, it says it's zero, which is what I get if the tables are not linked.
What I want to do is use VBA to link every table in the backend without having to know the names of the tables.
If I try to do a for loop for each tbl.name after loading the database with :
'Set wrkAcc = CreateWorkspace("", "admin", "", dbUseJet)
'Set dbs = wrkAcc.OpenDatabase("C:\testdatabase_be.accdb")
It doesn't seem to want to work. I suppose I need a way to get each table name before linking all the tables with code such as
Using Backend database to slow
I have a problem where the backend data is just way to slow to work with so I am trying to come up with a plan for working around it.
I was thinking about just copying the backend data to the users mydocuments folder and have the program access the data there but when changes were made then update the backend database.
Then update the local copy with the new id from the backend to the local version so the ID's and whatnot are controlled by the backend.
When the user opens the program after closing then it would just pull the backend data to the local machine again overwriting it.
I am grasping at straws here
Network DB path has changed, unable to find users/passwords file
Due to a change to our network infrastructure, the network path to our database now has an extra level - from J:\blah\database.mdb to J:\shared\blah\database.mdb
We've updated the shortcuts that point to the database itself, but when we attempt to log in to the database, it gives the error "Runtime error "-2147467259 (8000 4005)" and then says"J:\blah\database backend\database.mdb" is not a valid path" - is there anyway to update where the passwords file should be?
backend table protection
Is there any way to physically protect the backend?
One way of doing it would be to create backups every day, but this still won't prevent ppl from accessing the folder and deleting the backend.
Any thought on this guys?
Display Linked table Path
One of my users would like the path to a linked table to be displayed at the top of a form. His reasons aren't the best, but---. I can display the mdb file path using [Application].[CurrentProject].[Path] but how do I do same for a specific linked object? I tried sticking the table name before path, but no go.
Frontend showing data, backend not updating
I have a very strange problem.
I have a backend-database on a network disk shared by 6 users. All users have a frontend client wich they use to administer the datebase. Everything in the frontend looks ok and they can query the latest data. However if I open up the backend database tables nothing has been updated since the middle of december. If I make a copy of the backend I can open it up and create new posts with ID-numbers that has already been taken by the frontend.
Ofcourse I have doublechecked that the clients are connected to the right backend file (there's only on backend file in the directory). Its all very strange and confusing, anyone with a good idea whats going on
cloning a table in the backend
I have a need to copy a table structure from an existing linked table in the backend
I have done this by
a) copying the table structure into a new table in the fromt ebd b) exporting the new table into the backend
c) dropping the table in the front end
just wondered if there was an easy way to do this directly in the backend?
backend and links questions
with the below.
I have a split database, with the backend saved on a network.
1) How can I retrieve the name and location of the backend in VBA?
2) Is it possible to change the linked location for each table via VBA, say for example if I wanted to switch the tables to point to a backup version of the backend, or if a user had different drive mapping on a there machine which meant that the table location had to be remapped
Location of backend database
I want to split my database into backend and frontend databases. I understand that the backend database needs to be placed in a shared location. I would like to know whether there are any restriction on the type of storage location for the backend database.
Must it be on a shared network location in a Windows environment? Can it be placed on some FTP server?
Browse for Folder - absolute path
Ive just used Terry Krefts code to "browse for a folder path" and then store that folder path in a field in a table. This code works absolutely fine apart from one thing. When browsing to network shares, the function stores the relative path rather than the absolute path, so what is being stored is for example is the drive assigned letter on my PC ie M:\Folder, when really what I want is servername\share\folder
Change backend through code
I was wondering it if is possible to change The backend through code? I want an easy way to switch between a test backend and the real one? To help prevent data mistakes when testing.