Search results

Not having tried this for a very long time I have just tried it now and Leigh is absolutely correct it doesnt work in the current Jet version. Like I said I dont have the need to reset it as I never use it for anything in context.

True, but a lot of people (Not myself) tend to use the autonumber ID as a PR number or Job ID number.

After a compact and repair the auto number should reset to Max ID + 1, even after many deletes have taken place.

Have you tried to compact and repair the DB? If the highest current ID (autonumber) is about 2100 it should continure 2101.

What error message are you getting?

I have planned an online demonstration of my DB application next week to a potential customer in the USA. I will be doing this demo using ‘Logmein.com’ so the customer can see the same view that I see including mouse movements etc. To provide immediate answers to any questions they might have...

You can read the .ldb file but it will not tell you which tables they are using. It sometime gives duff information with refrence to how they left the DB. I prefer to create my own table and add users when they open up the DB and delete them when they leave, I also capture the machine name and...

What is the make of PLC Mitsi, GE Fanuc, Siemens or AB.

Interesting... So are your using the web browser as a two way thing, setting the web page up and then collocting the resulting data from the page and loading it into tables? Do you have an example available to post?

I have just helped a friend out with changes to a db by adding a web browser to add address and postcodes to google maps and create a route and see if it the route is optimum. (See attached A2003) Using google maps are the only real use I have found for putting a web browser into MS Access...

Try turning your Query into a 'make table Query' and run the report off the local table to see what performance you get.

What version of access are you running? How have you linked to the SQL 2008 tables? What is the connection string for the table? Are you mixing local tables with linked tables?

Thread update. I have managed to find a solution to my problem. I have been using the MDAC ODBC driver to connect to the SQL servers which works well with SQL 2005 Express but not for SQL Developer Edition so I have changed the connection string. From ‘MDAC ODBC connection’ oConn.Open...

Why don't you stick with the first part by closing down all users at a known time and then get windows task scheduler to open the backend a minute after that? This is method that I have used before. Garry

Hi I have MS Access 2003 FE running against an SQL 2005 Development server or SQL 2005 Express server. When I run it against the SQL server all is good but when I run it against the SQL 2005 Development server the speed is around 5 – 6 times slower. Both Access and the servers are on the...

Thank you once again. After i have tried it i will post an update. Garry

Thanks for that, (I will try it out later) is there any methodology behind this being more reliable, robust or just a better way. Garry

After inserting a record into a table that has an Auto number I retrieve it using the Dlast(field,table) Is Dlast(field,table) infallible in the way that I am using it in the code below and is there a better way? ssql = ("INSERT INTO ARF ([requisitioner],[Department...

I have had this before with forms. The trick is to not delete the label until you have closed the form and then reopened it.

Adam, Yep, 'if it would leave an orphan record it refuses to do it' But if there are no records there it should not be a problem. Dont figure (but then again Access never did) :) Do you have any views on changing the property Unique Records to Yes in the Query? Garry