Opening Access - NEED HELP! (1 Viewer)

mnicolas

New member
Local time
Yesterday, 20:27
Joined
Aug 10, 2022
Messages
4
I have been building a database for work. It will be a request form. Once it is complete It will disperse the data to all the appropriate departments for additional data management. The issue is........I don't know how users will be able to open the file! My department does not have the ability to publish the database to the web, so the goal was for there to be logic in the front-end to guild them through the process. Does anyone know a good way to provide users access to the database?

I've tried:
1. Sharepoint - Prompts a download
2. Dropbox - Prompts a download
3. Path in the directory - When posted on our website, it prompts a download

Not sure what else to try and at this rate, I'm going to have to start all over.

Thanks in advance for your help and support, I'm new at all of this.
 

plog

Banishment Pending
Local time
Yesterday, 19:27
Joined
May 11, 2011
Messages
11,613
Do you have a shared network drive? Something you all map to and have read/write access on?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:27
Joined
Oct 29, 2018
Messages
21,358
Hi. Access is a desktop application, so it must be run on the user's machine. They either need to download it first or you could email them a copy.
 

GPGeorge

Grover Park George
Local time
Yesterday, 17:27
Joined
Nov 25, 2004
Messages
1,776
I have been building a database for work. It will be a request form. Once it is complete It will disperse the data to all the appropriate departments for additional data management. The issue is........I don't know how users will be able to open the file! My department does not have the ability to publish the database to the web, so the goal was for there to be logic in the front-end to guild them through the process. Does anyone know a good way to provide users access to the database?

I've tried:
1. Sharepoint - Prompts a download
2. Dropbox - Prompts a download
3. Path in the directory - When posted on our website, it prompts a download
Not sure what else to try and at this rate, I'm going to have to start all over.

Thanks in advance for your help and support, I'm new at all of this.
Please do NOT try to distribute the Access relational database as a download from SharePoint, Dropbox or as a link on a website. Access is not designed to work that way. You can NOT manage the data safely that way.

Invest some time learning more about deploying a Split Access database. That is the approach which you probably can implement properly, but you do have to learn how to go about it first.

The basic scenario is that the current accdb you created is split into two. One of the accdbs contains only the data in tables. The other accdb contains only the interface and logic components, i.e. forms, reports and VBA, along with queries to retrieve the data into those forms and reports.

We commonly refer to the data accdb as the Back End, or BE. The BE contains only tables.
We also refer to the interface accdb as the Front End, or BE. The FE contains only forms, reports, queries and VBA.

Next, link the FE to the tables in the BE. Invest some time, as noted above, in learning how to do this.

Place the BE on your network, not in SharePoint, not in Dropbox. They work differently and don't support the file system required by Access. It has to be a shared folder on your network.

Give each user a COPY of the FE. One copy per user. no shared copies. That way, they don't cause problems for one another.

When you update forms or reports, create new FEs and give those replacement FEs to the users. The data stays in the shared BE.

Back frequent, systematic backups of the BE and your own master copy of the FE in which you do further development. There is no such thing as too many backups.

With this approach, everyone can share the data and do their work as required.

 

mnicolas

New member
Local time
Yesterday, 20:27
Joined
Aug 10, 2022
Messages
4
Hi. Access is a desktop application, so it must be run on the user's machine. They either need to download it first or you could email them a copy.
These are kiosks used by nursing. Each people would have to download each time it was used as the computer resets often
 

GPGeorge

Grover Park George
Local time
Yesterday, 17:27
Joined
Nov 25, 2004
Messages
1,776
Yes, the file will be on a shared dirve that everyone would have access to read/write to
(y) However, they need read/write/delete permissions because of the way File Locking works in Access.
 

GPGeorge

Grover Park George
Local time
Yesterday, 17:27
Joined
Nov 25, 2004
Messages
1,776
These are kiosks used by nursing. Each people would have to download each time it was used as the computer resets often
Not necessarily. The FE resides on the computer in that kiosk (and that brings up another factor). It only needs to be replaced if YOU, the developer, change something in the master copy and need to update the Kiosk copies.

To run, Access requires either the full version or a free runtime version installed on each of the workstations where your users will use it. Another topic to learn about: Access runtime.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:27
Joined
Oct 29, 2018
Messages
21,358
These are kiosks used by nursing. Each people would have to download each time it was used as the computer resets often
When you say "resets,' does it mean it wipes out all stored files in it?
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 20:27
Joined
Feb 19, 2002
Messages
42,981
You need to also install the Access runtime on each PC if the PC's won't have the full version of Access installed. There are several methods to handle an automatic "download". My preference is a batch file. The batch file is only four lines long and it resides on the network share. The users have a shortcut on their PC's. They run the shortcut and that runs the batch file which copies the latest version of the FE to the local disk. FE's tend to be pretty small in size so this doesn't add an undue burden to the network and it saves potential hassles should the FE become bloated or corrupted. A fresh copy every day means those things are unlikely to ever happen. You also need code in the opening menu of the app to match the version in the local table of the FE with the version in the linked version which is in the BE. If they are different, you code need to display a message to download a new version and then exit the application.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 00:27
Joined
Sep 12, 2006
Messages
15,614
These are kiosks used by nursing. Each people would have to download each time it was used as the computer resets often

They shouldn't need to download it repeatedly, even if the computer resets - but if your network is not stable, then you (ie someone) needs to get that resolved, as that is a risk for all of your systems.
 

Users who are viewing this thread

Top Bottom