Member Avatar for BombAppetit
BombAppetit 0 Light Poster

hello

i am trying to create a list box of some sort to display time and date when a certain table has been modified in microsoft access

i included this line of code

Dim cat As New ADOX.Catalog
cat.ActiveConnection = "Provider='Microsoft.Jet.OLEDB.4.0';" & _ "Data Source='C:\Osman\cobaan.mdb';"

it gives me a run time error "The database has been placed by user "Admin" on machine "/AGMLHKHOO" that prevents it from being opened or locked.

it happens only when i open the form in access, not when i refresh the form.
how do i get around this one?

Thanks in advance
-Osman-

  • 1 Contributor
  • 0 Replies
  • 137 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.