Recent content by emzipoo4u

As I said the csv file updates daily so importing directly isn't ideal as it creates another step in the process. No other option by the looks of things though so have to create an SSIS package that will run daily to update the data ?

The csv updates each evening and is a file written from out POS software.

I have an Access database which has a linked table to a CSV file. Only one user can use this part of the database that links to the CSV - for other users we get the error 3051 - opened exclusively by another user. How can the csv file be a linked table with multiple users ? The query itself is...

Hi there, I have 2 tables. Vehicle table - gives vehicle details Vehicle defect table - lists defect reports for vehicles One vehicle can have many defect reports. I have a form that is linked to the vehicle table. On this form I want to display a count of the number of defect reports in...

Just tried and i'm logged in now and all tables linked, however I still cannot view the design mode of the forms.I go into users and permissions ; User and group permissions, it says current user Admin and Admin can Open, Read, Modify and Administer. Yet I still cannot get into Design Mode, any...

No but I will try that tomorrow , thanks !

hello everyone ! I have 2 access database files on my USB stick, one is the back-end which holds all the tables and I can open this no problem. The other is the front end, which holds forms, queries and reports and it links to the tables in the back-end database. trouble is it links to the...

Hi, I have an access database that is currently 17,000 kb and hosted on a basic hosting package with zen internet. (£5 a month). We've been testing the application for 2 weeks, but yesterday made it live to our customers. There are about 4 or 5 users that read and update the database and...