Split Database Back End On FTP Or Web Server

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 Replies


ADVERTISEMENT

Moving Split Database Back End To Sql Server

Jan 8, 2015

So 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 Related

Move Split End Back End To SQL Server

May 11, 2015

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 Related

Split Database W/be On A Server

Nov 20, 2007

Hello..

I am new to split database format... If I put the backend on say windows server 2000 or 2003 in a folder, is there anything else I need to do? Any setting on the server?? Or do I need a specific type of server os ie sql server etc?

Thanks

View 14 Replies View Related

Split Database, Roll Back Can I?

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

Split Database Back End Password

Sep 24, 2010

I have a database already split and I wanted to put a password on the back end. When I open up the front end and try to navigate through the forms it says "Not a valid password".Is there somewhere I need to go / something I need to do to link up the two now that a password has been created?

View 4 Replies View Related

Split Database: Back End File Path (via Vba)

Mar 2, 2007

Hey guys,

How can I change the tables' splitted file path via vba?

Ex.: c: ables.mdb -> c:ew path ables.mdb

thank you.

View 3 Replies View Related

General :: Backup BACK-END Of A Split Database

Jan 24, 2014

I am trying to use VBA to backup the BACK-END of a split database (so I can automatically archive selected data). If I use FileCopy I get a message that the BACK-END database has not been found.Obviously I could 'unlink' the BACK-END, copy it and 're-link' it..Is it possible to copy the BACK-END tables(not just the links) into the FRONT-END and get at them that way?

View 2 Replies View Related

General :: How To Split Database And Upload To Server

Dec 11, 2012

I 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

View 1 Replies View Related

General :: Split Database Access FE And SQL Server BE

Mar 4, 2014

I am currently working on an application where I am using MS access as my FE and working with linked tables to SQL server BE. I also have a few temp tables within Access that are not linked but needed.

1. What are my steps into making this into a SPLIT DB? I am assume the BE will have my linked tables from SQL and the FE will have my temp tables and forms. Is this correct?
2. Once I split it, then I can make an .ACCDE file for a Mulit User environment, is this correct?

What other steps should I be made aware of?

View 8 Replies View Related

General :: Database Back End Keeps Hanging (Tables On Server)

Aug 10, 2012

I 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.

View 10 Replies View Related

General :: Split Database - Prevent Linking To Back End

Jun 25, 2015

I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution.

As the database is on the network drive, is there any other way to prevent people to link to the db? Can I hide the db in the network drive? Or should I hide tables in the BE. Should these still be available to be linked?

View 6 Replies View Related

Split Database. Update Linked Tables If Back End Moved.

Dec 7, 2007

Hi.

I'm about to move to a back end / front end system, from a single database file. Before I do so, I want to make sure I have all bases covered so to speak.

My back end file will reside on a server. I am aware that path names are sometimes changed by network administrators without warning.

From tests, I notice that, if the path to the back end can't be found, one cannot open the front end database file at all (Access 2003).

My question is: if my back end file gets moved, or the path changed, how can I get into my front end file to update the linked tables.

Many thanks in advance.

Mat.

View 1 Replies View Related

General :: Split Database - Putting Password For Both Back And Front End

Jul 10, 2013

I have designed a split database( with back end and front end), I am just wondering what would be the best way to put a password for both of the back and front end.

View 10 Replies View Related

Forms :: Create A Navigation Form On A Split Database With Front End And Back End

Apr 4, 2013

I am trying to create a navigation form on a split database with front end and back end.But Access is not letting me drag forms or reports into the navigation form. Why?

View 1 Replies View Related

General :: Updating Front End After Adding New Table To Back End In Split Database

Sep 22, 2013

I have split the data base

Added a new table to the back end .But do not know how to update it to the front end

View 4 Replies View Related

Running Back End On A Linux Server

May 12, 2006

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!

View 1 Replies View Related

Back Up Tables Inside A Server

May 12, 2006

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

View 1 Replies View Related

General :: Duplicate Back End On Different Server

Feb 22, 2013

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 5 Replies View Related

Does File Server Hosting Back-end Mdb File Need To Have Access

Nov 15, 2013

I'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?

View 2 Replies View Related

Back End Database

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

Take My Database Offsite And Back?

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

Database Back By Button???

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

Moving Database To Another Server

Dec 3, 2006

Howdy,

I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine. Until I tried to open any of the databases. I kept getting the message that they all were read only.

Do I need to bring the database back together before transferring it? I also plan on converting the databases to Access 2003. What precautions should I take in doing this?

Thanks for any and all information you can pass along.

P

View 1 Replies View Related

Sharing A Database Without A Server

Jun 12, 2012

At work a few of us all need to access the database to edit/update etc and at the moment only one of us can use it at once.We are getting a server in the near future so we will all be able to access it at the same time but I was wondering if there is an alternative way to do this in the meantime? I have been looking at "shared folders" but am unsure if they are suitable or how they work.

View 4 Replies View Related

Split The Database, Should I Do It?

Jan 12, 2006

:confused: I have read a quite a few threads on spiting the database. My database is 50 Meg and running very slow. I have compacted and repair, still the same. This just happen all of sudden. Could that be possible?. What should I look out before I try to spit it?. It’s given that I will make a backup. I am running Access 2003. I have over 150 users.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved