I have made a simple database in access 2000. I wish for my reps to be able to use it and download it from my?

Question

website. I would like to make it into a program. Any ideas please

I do not want for them to be able to access to database from the web but to be able to either send them the database files or download them from a webpage

I am confused. Each rep needs their own empty database/records card so the can input details. The database dos not need to be on a server or website jst a program they can have on their desktops to put info into. I have tried this on excel but they need to be able to scroll through individual records

Answer 1

I think your missing the point of a database. You'd be better off creating a text file or an Excel sheet for the reps to download, because an Access Database is overkill. Having multiple copies of a database, where each rep has there own version of the database, is a maintenance nightmare. Your going to have data consistency issues.

What you need to do is create one single database that your reps can access on your server. You can allow the users to update the database with SQL or you should create a program, or website, where the reps would interact with a GUI and manipulate the database through your custom program.

But if you still want to let the user download a file like you wish, just dump the database contents to an Excel file. Let the users manipulate the Excel file.

Answer 2

You will need to create a frontend for your website to access the MDB, this can get a bit complicated, you will need a hosting company that supports Access first.