Stay with Access or Switch to SQL

[Albion]

I have 3 or 4 Databases done in Access 2000 with quite a bit of VBA in each. They need to be accessed simultaneously by 6 or so users over the network. Do I need to go to SQL so multiple users can access the databases at the same time or is there a way to do this in Access over the network? I really don't need the power or scaleability of SQL all I really need is simultaneous network access.

Thanks.

Craig Manske

 

[Terpsfan]

If you only have 6 concurrent users then Access should be fine. In the database utilities, choose Database Splitter. This will separate the tables from the queries, forms, reports, code. Save the backend version to a shared folder on the network drive that all 6 users have the necessary rights to add, edit or delete data. Save the fronend version to each local user's PC. On their frontend make sure their tables are linked to the backend on the network share. You would use Database Utilities, Linked Table Manager to link the tables. After that you should be ready to roll.

 

[Albion]

Do I need to worry about permissions?

-al

 

[Terpsfan]

Well, as far as permissions go I'm assuming you are on an NT or Windows 2000 network. In that case the users need to have read, write, delete and execute to the directory and file that the backend database is on. If you have that much VBA code I would strongly suggest you keep a copy of the code in a text file, because Access databases can get corrupted.