We 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 RepliesI have a database with a front end and back end (tables on the server) that was recently converted from Access 2003 to Access 2010.
For some reason the back end keeps hanging and I have to constantly compact and repair and there has been major data loss on a regular basis.
Hi Guys,
I hope this isn't too stupid a question, but I have a db that needs to be accessed from several workstations. It is currently a split db, with the backend residing on one of the workstations in the workgroup. I was wondering if it possible (as I am looking at buying a server) to "house" the backend on a Linux machine? The main reason I ask is that Linux is <$100, but MS Server is >$1000. Does the server need to be able to run the program? If yes, is there any way around this?
Thanks in advance for your help!
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
Hi
I have 5 PC clients and a server.each user upon shutting down his PC,is prompted to send all the information inside a table "Patron" to a table inside the server.That way each user backs up his information to a table inside the server and at the end of the day,the table on the server side contains all the data from the 5 PCs.I am new to access,can anyone guide me through the steps I need to accomplish this project?
thanks in advance
I'm looking into buying SQL Server 2014 Standard Edition.I would like to move my split end back end to the SQL Server, however I'm having a little confusion with all the different licensing out there.I have 20 computers that will be accessing the SQL Server.
View 12 Replies View RelatedSo the database I have right now is split, with the back end on our server. Everything has been going great, however there are several second time delays when loading large forms, queries, etc. I've heard that moving the back end to an sql server is the way to go for speed.All forms and queries are on front end of database. Tables are located on the back end which is sitting on the server.
View 7 Replies View RelatedI would like to duplicate table from SQL Server 2000 to Access using VBA. How to programmatically establish a connection to SQL Server using VBA codes?
View 4 Replies View RelatedI'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.
Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?
How can i convert a .mde back to a .mdb? I need to change some material on our program and have lost the .mdbs!
View 3 Replies View RelatedMy forms and reports jump to the back, behind anything that is open when ever I open them into design.
View 6 Replies View RelatedI plan on using Excel as the front-end and Access as the back-end only. (all queries and forms are in Excel). A single Access database will be queried from multiple Excel files that will be located on the share drive (Linux server). Access tables contain memo, text and number fields. Data will be sent to Access tables and records will be appended/deleted; all via Excel.
There will be multiple users interacting with a single Access database via multiple Excel files located on the shared drive. Users will be interacting from different workstations with Windows 7, all have Access 2010 and Excel 2010 installed.
This process works for me from my workstation but I am not sure what will happen when other 4 people will be sending/appending/deleting records to the same Database? How do I make this work? What settings do I need to check in Access to make this possible?
I have a database which is split so that several people can have a 'front end' to the database to access one common back end. This works fine on a network but I thought I could load the backend up to my webspace and then with the links manager point to it, but it doesn't work. I get an error report of 'not a valid file name.'
The website is [URL] .... and the backend database name is Probus_data_A.accdb and so I entered [URL] .... as the address in link manager.
I currently manually run a compact and repair on the backend of a database at work, but was wondering if it might be sensible to set it to compact on close so that (in theory) it is done at least daily and therefore shouldn't take much time?
The back end resides on a network server, which is backed up continuously, so in theory it should be easy enough to roll back to a backup copy should anything untoward happen.
So i want to protect the back end of a database but im limited to what I can do....I am unable to restrict members from accessing the file by username...I am unable to place it in a local area which is pass protected...I am also unable to encrypt the back end as the front end needs to be able to access it (and I dont know how to allow it to do that...)
View 2 Replies View RelatedHave a database with a back end that I have been working on. The database resides on a USB at the moment. I was ready to deploy and now when I try to re-link the back end tables, I repeatedly have the following error: "Your network was interrupted. To continue, close the database, and then open it again."
At first I thought this was something to do with the network, as I was moving it to a shared network drive. However, I can recreate the same issue using someone else's computer and using my USB (although it's mapped to a different drive letter). I've tried a few things, including recreating the back end by importing only the table structure, but still no luck.
I 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 have created an access 07 database and split it to a back-end and a front-end with linked tables.
I wish to deploy it an a network of 4 computers, 3 of which are running on XP. The back-end will be on a computer running on XP. Now, from the instructions I have come across online, the Back-end has to be located on a folder where all users have Red and Write rights!!! And I am thinking, if the users on this network can actually see the back-end since it is on a shared folder where they have all the rights, then does that not compromise the security?
Is there a way of linking to the back-end on a network WITHOUT the users being able to access the back-end?
I have a back-end db in access 2010, linked to a set of sharepoint tables on office365.
I want to make a completely unlinked copy of the db to store a "snapshot" of the data on a fixed date.
I have tried "save as" using the "Save as Local Database" option, but for some reason, it still saves as linked tables.
How to go about it?
i 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 RelatedI need to change the password to the front end of my split database. How would I do this?
View 1 Replies View RelatedI've created a custom ribbon for my end users (Access 2010) and everything looks and works great except for one issue that is becoming a deal breaker for me and my end users:
I've got a number of tabs on my custom ribbon and on each tab there are a number of buttons that open various forms and reports. Anytime one of those forms or reports is opened and then closed, the ribbon jumps back to the first tab in my custom ribbon. So if you were on tab 3, opened a form and then closed it, you would be jumped back to tab 1.
Any workaround for what seems to be "by design" behavior for custom ribbons? The built-in ribbon does not do this.....